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...
Any chance you could send me the tbltest (or the hole DB with query) table so I have a working copy to compare it to my not working one and figure out what has gone wrong
Thanks
Think I found what I need but cant get it to work
The DBguy Suggested "refer to previous records" using a subquery.
found exactly what I want (I Think)
https://www.access-programmers.co.uk/forums/threads/subquery-problem.269148/
In "Difference in query" DB looks perfect but I cant get the code...
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.