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!

Application Title Bug if Word Merge

Troubleshooting

Application Title Bug if Word Merge

by  Bullschmidt  Posted    (Edited  )
If you want to have Access open up a Word mail merge document, do NOT fill in anything for Tools | Startup | Application Title or else Word will try to open up another instance of Access and ask the user to fill in all the parameters of the query even though the old instance of Access may have the parameter values shown on an open form.

Or perhaps have code to temporarily change the application title to Microsoft Access during the mailmerge such as the following:

db.Properties("AppTitle") = "Microsoft Access"
RefreshTitleBar

And code to change back to your title sometime after the mailmerge code:
db.Properties("AppTitle") = "My Title"
RefreshTitleBar

J. Paul Schmidt, Freelance Access and ASP Developer
http://www.Bullschmidt.com/Login.asp - Database on the Web Demo
http://www.Bullschmidt.com/Access - Sample Access Invoices Database
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top