Search results

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.