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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rename report in access

Status
Not open for further replies.
cdlaforc

cdlaforc

Programmer
Oct 11, 2006
6
US
How do you with vba rename a report in access.
Thanks,

Chris.
 
Sort by date Sort by votes
How about:
[tt]DoCmd.Rename "rptReport New Name", acReport, "rptReport1"[/tt]
 
Upvote 0 Downvote
Thanks, I actually got it to work a little differently. What I was doing is querying a table with records for a bunch of different departments at work so I was looping through the departments and I wanted to rename the report and then print it to my adobe writer and name it back, then do it again. A guy at work just suggested to write it out and then use the Name method to rename the file at that point. It worked fine, but again thanks for the help.
Thanks,


Chris.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
258
dhookom
dhookom
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
557
renigar
renigar
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
307
dhookom
dhookom
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
910
EwaFAMA
EwaFAMA
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
265
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top