Recent content by haydnm

Thanks for the assistance arnelgp, much appreciated. I've imported the modules and customised the code and it's working pretty much as I want it to.

Thanks for the sample arnelgp. Looking through it, the code seems to always export the query as zzquery. I have four queries with four different names and I need to keep these names intact when exporting. How would I do this in the code you have provided?

Hi Arenlgp, Yes the access query comes up when it has been run and it sounds like your suggestion would work. Unfortunately, as I'm new to Access I have no idea how I would go about doing what you've described. Would you mind providing an example using the code I provided? Thanks, Haydn

Hi, I have an Access DB that has 4 queries and one form. Depending on what the user does in the form will determine which query is run. This is controlled by a macro that looks at the state of three tick boxes and runs a query accordingly. What I would like to know is, can I have a single...