Search results

Thanks for update. Happy to report the process finished the remaining 200,000 records within minutes not hours! Thank you!!!

Thanks for reply. Will update to amendments.

My goal is, foreach rstA record, determine whether rstA's product+site+yr record exist in rstB, if rstB rec is found, update the monthly percentage, otherwise, create the record. Do you see a conflict which prevents this from occurring?

I have VBA code in access 2007 that's been running unexpectedly over 24hrs. Whenever I issue 'ctrl+break' to check progress and step through code with F8 all appears well although msaccess reports it is 'not responding'. When I first saw the 'not responding' I stopped the app, checked the code...

Yes, I am. I am deeply grateful for the help.

Thanks for response. Given that its been nearly 10 years since last VBA project, I am surprised I have memories of anything.

Greetings, need assistance understanding what I am doing to generate the above error using Access 2007. My goal is to cycle thru field collection of rstA which contains 79 fields. For each record in rstA, I want to create a new record in rstB using rstA.fields 0-19 plus 1 field beginning at...