I have a dropdown box that gets its data from a query, there is only one record thats fine.
I use "Me.ComboBox = Me.ComboBox.ItemData(0)" to display the first record (and only) that displays in the seen part of the combo box
but it wont "run" until I click on the arrow and select the same...
Is it possible to do a time difference from one query?
12:05
12:07
12:10
12:15
Need to have the difference between times
12:05
12:07 02:00
12:10 03:00
12:15 05:00
So from a query need to know the difference from the last line
Hope someone can help
I want to use the IF statment in a before update
I have tables Employees and keys
the keys table has a key no. and person1 to person5 fields
in the form the employee number is put in which shows a name
the next field is the key
I want the IF to lookup in the key table at that key number and see...
Can someone help me with VBA code for the following
I have a table with people’s names and what keys that they can have called (tblEmployee)
Name John
Key1 30
Key2 22
Key3 15
In a form (frmKeycollector)their name is entered, (first field) lookup from above table
Next...
I have a db one of the tables (TblScans) I have field called ProductName and a field called SapNo and a yes/no field called Repeated
In a form (frmScans) ProductName is entered as Text
then SapNo in its own field
I found from the net a dlookup that i use in SapNo Beforeupdate Event procedure...
My Name is Peter, did a bit of Access many years ago and need a bit of help with a few this as I go. Looking forward to getting back into it as I think Access is a great program, anyway I will enjoy this site and others on here, chat soon.