Reset a module/database

[ClifCamp]

I have a db which does most of its work in VBA. On a button click, it imports a table, modifies it, and then users can run queries to see different data. Everything works perfectly until the user tries to click the button again to do a second import. Then it works erratically or not at all. The fix I found for this is to close then reopen the db. Once that's done, everything works perfectly. Is there a way to "reset" the db this way with out having to close and reopen? Is there a VBA command for "resetting" a module or db?

 

[vbajock]

need the code for the button click

 

[JoeAtWork]

Is there a VBA command for "resetting" a module or db?

Nope, no magic "fix my bugs" command. You'll have to crack open the code to debug it.