Locking queries so you won't have to repeat the process, streamlining?

[alcorp]

Hi,

I've been looking everywhere for info and I can not find any info on this.

Okay I've done everything I need to do in access to get my results. Now how do I set up a template(sort of like excel) with the queries already set in place? I have one access project that imports info from a text file but only certain info not all. Then is followed by 2 queries and I get the results I need in the 2nd query then export it to an excel file.

The 2nd project is basically the same as the first project but it not only imports info from a text file but also from an excel file.

I am trying to make it as easy as possible for someone with little access experience to do this by doing all the work now. I want to try and eliminate as many steps to avoid mistakes from a user but I just don't know how to create a template or pre-access file project to use. Can anyone point me into the right direction?

[burrina]

We don't have enough information to direct you. This process could be done when the db opens, via a command button or some other criteria. When and where do these queries need to run?

[ranman256]

User opens the db
the macro autoexec opens the form
A button on the form, for the user to click to run a macro
the macro :
runs the import (via append query)
then after the import it runs the 2 other queries.

[alcorp]

Well basically I am thinking of it how excel runs. I want to have it where the queries are set up and all ready to go but I just need to import the files. As soon as the files are imported, I want to where you click run and then the results are produced after you import the files.

I am trying to set it up where I can use the same file over and over with different data but with the queries locked and the import tasks locked if that's even possible.

The queries are pretty basic and nothing too complicated.

[burrina]

So set one command button to Import, another to Run. Not complicated. NO locking of queries, that does not make sense, either you run them or not. The data is updated each time you run them. IF you are asking to ONLY run them once and then Lock the command button, this can be done also or ask for password, etc...

[alcorp]

thanks! much appreciated. Now I know what I am looking for.

[alcorp]

Also when I create the buttons, should I just redo the access project and add the buttons as I go through the process or do I add them at the end when I am finished with everything?

[ranman256]

Doesnt matter. Buttons first, queries first.