Search results

Yup! That's because I couldn't figure out where the heck the problem was and was just dumping code on ya. My issue was the missed OpenRecordset commands other VBA modules the Open event called. The debug tool stepped me through these calls to see where I missed the commands. The line of code I...

Perfect answer. It would appear that I did not know how to use the debug tool :D Using debug and stepping into the Open event I was able to find OpenRecordset commands that did not include dbSeeChanges. Thank you so much!

The company I just started working for has an Access database they have been maintaining for years. They have tasked me with converting the BE to SQL. My knowledge is very limited but I do understand basic concepts of VB and database management. After having converted the tables to SQL I am, of...