Display database title = Filename.mdb

  • Thread starter Thread starter Bradley C. Hammerstrom
  • Start date Start date
B

Bradley C. Hammerstrom

Access2000

Is there some way to have the Database title (in the Startup dialog) take
the name of the .mdb file, whatever it happens to be.

For example:
"2003-06-22 Project123.mbd" would display in the title bar (extension
showing is optional). Later, the file is copied for a backup and the new
filename is changed to
"2003-07-04 Project123.mdb".

Excel and Word files work this way by default (filename in the title bar).
Can this be done in Access?

Brad H.
 
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


Posted via http://dbforums.com
 
Back
Top