Database Startup

[ronreggin]

I am able to create and modify my tables and forms. However, I want to start
using my database, how do I get a form to automatically open when I start the
database. I have seen some of the Microsoft examples do this and I would
like to do the same.

thank you,
Joe

 

[Douglas J. Steele]

Look at the Startup option under the Tools menu.

 

[Wayne Morgan]

Go to Tools|StartUp... and set the desired options. Be careful, unchecking
"Allow Full Menus", "Allow Default Shortcut Menus", "Allow Built-in
Toolbars", and "Use Access Special Keys" can cause you problems if you
haven't provided your own versions of these.

The items you most likely want to set are "Application Title:", "Display
Form/Page:", and uncheck "Display Database Window". With the "Display
Database Window" unchecked, you can still access it by pressing F11 or going
to Windows|Unhide on the menu bar.

 

[Ken Sheridan]

Joe:

Select Tools|Startup form the main database menu bar. In the startup
dialogue select the form in the Display Form/page combo box at the top right
of the dialogue.

One thing I sometimes do with startup forms, if I'm not hiding the database
window completely, is to minimize the database window when the form opens.
To do this put the following lines of code in the form's Open event procedure;

DoCmd.SelectObject acForm, Me.Name,True
DoCmd.Minimize

The first line selects the form in the database window, which ensures that
the window has focus so that the second line can minimize it.

Ken Sheridan
Stafford, England

 

[ronreggin]

Thank you.

Look at the Startup option under the Tools menu.

 

[ronreggin]

I am not familar with programing in Access but I have years of experience
programming in other languages. Do you have any recommendations for books or
websites that can help me get started and familiar with the program?

Thank you,
Joe

 

[Ken Sheridan]

Joe:

If you are new to VBA programming in Access a good introduction is Evan
Callahan's 'Microsoft Access 2002 Visual basic for Applications Step by Step'
( I don't think a 2003 version has been produced). Amazon.com are currently
offering it at 44.50 USD. It doesn't go very deep but gives a good
foundation on which to build. It comes with files on a CD for you to work
through in conjunction with reading the book

Also study the way things are done in the sample Northwind database. That
covers many basic programming tasks in Access.

One site which has lots of useful stuff is the Access Web:

http://www.mvps.org/access/index.html

Ken Sheridan
Stafford, England

 

[john.demetris]

HELP!!! I unchecked the display menu settings in the STARTUP pane, now
I can't open or edit the data base anymore! HELP!

 

[Douglas J. Steele]

Try holding down the shift key while you're opening the MDB file.