Recent content by p4man

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

What is tbltest Please help

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...

Thanks Cronk Works after the "Then" and to "True" Total problem fix Can't thank you enough Stress relief Wow.

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.