What I was actually looking for, and this is my fault, so I apologize for it. Any how, what i really wanted to know is how to make it automatic. For example, when the user hits the generate report button, instead of it actually generating a report it stores it to a file, text file to be specific.
What do you mean by the "generate report button"? And is the text file supposed to be formatted like a report, a datasheet, a CSV file, what?
Remember, I know nothing about your application and can't see it. Think out what it is you want and describe it as you would to a blind man.
Rick Sprague
Want the best answers? See faq181-2886 To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
I have a query which pulls information i need.
now what i want to do with the query is to send the information it pulls to a file, namely a plain text file. The type of file is not very important at this moment.
Now I want to do a form. On that form i will have a button that runs the query and upon running the query the information is sent to the file destination.
Ok. I would have thought the solution was obvious from my first post, then.
In the command button's Click event procedure, execute the code:
DoCmd.OutputTo acOutputQuery, "<name of query>", acFormatTxt, "<path name of output file>"
Rick Sprague
Want the best answers? See faq181-2886 To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.