I don't even know if I have the terminology right, I'm feeling pretty useless just about now. I don't know how to write or use VB code, but I have a macro created with SQL. It runs about 12 queries and then opens a report in design mode as I need to change the dates in the title section of the report. I then export to Word and email to a number of people. I've discovered I can email from my Access macro using the Action "SendObject". However, I need the report to open in design mode and the macro not to continue with the "SendObject" until I've completed the date changes and closed the report.
Can anyone help a lowly SQL user?
As always, I appreciate everyone's help.
Thanks
S.
Can anyone help a lowly SQL user?
As always, I appreciate everyone's help.
Thanks
S.