Recent content by Millon

I always use CurrentDB when referencing queries. The only place I don't is when deleting them, but I don't know how to do it without using DoCmd. Now it may not seem necessary to delete the queries before updating the SQL, but I'm afraid that Access's refresh problems will export the old...

The error is on the export line DoCmd.TransferText acExportDelim...So are you suggesting that I change it to: CurrentDB(DoCmd.TransferText acExportDelim...)I'll give it a try and report back with my results. Edit: I don't think I'm doing what you had in mind. Could you please post the modified...

Access is giving me errors when I try to export a newly created query. Run-time error '3011': The Microsoft Jet database engine could not find the object 'example_query'. Make sure the object exists and that you spell its name and the path name correctly. However, if I go into...