Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

save report

Status
Not open for further replies.
ksbrace

ksbrace

Programmer
May 13, 2000
501
US
I have a macro in MS Access 2007 that opens a report, prints it (print layout), then quits. I would like to Save as "report_date.txt" or some other text format before it quits. There is no Save/Save As command option in the macro design view. Any and all help would be greatly appreciated. Thanks in advance

 
Sort by date Sort by votes
Use VBA instead of macro.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
PHV,
Thanks for the reply. So, are you saying it's not doable within the Macro, itself?

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Dophia
  • Locked
  • Question
Problem using code to open a form, but works to open a report
Replies
1
Views
157
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Create report for each record in a datasheet subform 1
Replies
2
Views
164
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Create multiple reports 1
2 3
Replies
47
Views
795
TrekBiker
TrekBiker
TheresAlwaysAWay
  • Locked
  • Question
I want to save keystrokes leading up to error 1
Replies
4
Views
130
TheresAlwaysAWay
TheresAlwaysAWay
breezett93
  • Locked
  • Question
Access report fails to send via Outlook 2016
Replies
0
Views
104
breezett93
breezett93

Part and Inventory Search

Sponsor

Back
Top