Search results

Can anyone suggest the best method to create a temporary table? I would rather not use the (SQL) Make Table / Drop Table statements. Instead, create a table in which data can be temporarily stored in while my code runs, kind of like a table stored in a variable???? Thanks Doug

Can anyone suggest what method would be the best for the following scenario: In my form I have a serial number field. When a serial number is entered in this field and the focus is lost, I would like it to search and underlying table for a match of that serial number. If it finds a match or...

Does anyone know how to move to the next record in a subform datasheet using VBA? I tried this but it didn't work: DoCmd.GoToRecord acDataForm, "Forms!SerialTrack!SerialsSub2", acNext Any ideas???

Does anyone have a solution for the following?: I have a table with the following info: (feilds) PO# Supplier ItemGroup ItemNumber Qty I would like to use the qty feild to determine how many new records to INSERT into the serials table. example: ======== PO = 5545 Supplier = ACME ItemGroup...