Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Chimpanzee
Starting Member
4 Posts |
 Posted - 2003-03-07 : 07:10:05
|
| Is it actually possible to create a macro or module in access that will1) run a query2) merge the results of the query with an existing word doc3) print the resultsand put the code into the click event of a button so I can run the whole procedure by just clickin one button in access.thanks |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-07 : 07:13:27
|
| YesUse the "Press one button to solve everything" wizard in AccessDamian |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-03-07 : 07:26:31
|
| Have you tried writing a report in Access? That's pretty much what they do: open a query, merge with your report design, and print out or preview on multiple pages. And you run it just by double-clicking on the report name.Access has very nice reporting capabilities -- you can even embed a Word or Excel document right in the report.- JeffEdited by - jsmith8858 on 03/07/2003 07:27:20 |
|
|
|
|
|
|
Help! does this exist?