Search results

We only need the table temporarily and when we create and drop the table(s) everytime the code runs, our database increases in size drastically. I ran our code 3 times and our database size went from 380K to 780K. Compact and repair brought it back down to 380K. Thanks for your idea and any more...

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

Thanks for your help! This worked great!

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

Rich, I got it! I was writing the following code: Forms!SerialTrack!SerialsSub2.SetFocus DoCmd.GoToRecord , , acNext This didn't work.....but ______________________________________ ....after your posting, I re-thought my process and did it like this: Dim varSub2 As Control Set varSub2 =...

I've already tried that as well. Maybe my syntax isn't correct. When I try to navigate it tells me my subform isn't open. Funny thing is, if I open my subform by itself, I can navigate through the records from the main form button I created - it works only if the standalone subform is open in...

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