Return to Menu after closing Mailing Labels

[Uschi via AccessMonster.com]

I have set up a command to print mailing labels. I have discovered that the
only way to close the mailing labels once they are in print preview is to
close the entire database.

I would like to return to the form after closing the mailing labels.

Would appreciate help with this.

Thanks in advance.

Uschi

 

[Jeff Boyce]

?You don't have the option of closing the report?

What kind of menu do you have?

Which version of Access?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Uschi via AccessMonster.com]

Jeff,

Correct. I don't have the option of closing the report; just the entire
database. The menu only allows me to print.

I made this database in Access 2003 where the mailing labels, when closed,
returned to the menu. I discovered this problem when I put it into 2007.

Any thoughts on this?

I appreciate your help,
Uschi

?You don't have the option of closing the report?

What kind of menu do you have?

Which version of Access?

Regards

Jeff Boyce
Microsoft Access MVP

I have set up a command to print mailing labels. I have discovered that the
only way to close the mailing labels once they are in print preview is to

[quoted text clipped - 7 lines]

Uschi

 

[Uschi via AccessMonster.com]

Jeff,

I believe I have solved my problem by adding the code to close the report;
for some reason it was missing. The following seems to be working:

stDocName = "Mailing Labels"
DoCmd.OpenReport stDocName, acPreview
DoCmd.Maximize
DoCmd.Close acReport, "Main Menu"

Hopefully, the command will still be working when I put this database back
where it belongs.

Best,
Uschi

Jeff,

Correct. I don't have the option of closing the report; just the entire
database. The menu only allows me to print.

I made this database in Access 2003 where the mailing labels, when closed,
returned to the menu. I discovered this problem when I put it into 2007.

Any thoughts on this?

I appreciate your help,
Uschi

?You don't have the option of closing the report?

[quoted text clipped - 12 lines]