I want to improve my MS Access App

[David Langschied]

I am fooling around with making my MS Access 2000 database app look more
professional. I want to set up some menus to guide the user through the app.
I have looked at creating a switchboard and I also have looked at generating
forms to drive the app.

I have run into a couple of things.

If I use the switchboard, I cannot create an effective exit that closes
Acess when the user wants to quit the app.

If I use forms, I cannot find a way to launch my data entry screen in add
mode.

I want to do both of these things. Which way will allow me to do what I
want the easiest.

Also ... I would like to not have the MS Access window visible during the
time that the user is accessing the database. How do I accomplish this?

Thanks!

 

[Douglas J. Steele]

Not sure I understand what you mean by "an effective exit that closes
Access". DoCmd.Quit will shut down Access. Is that what you're looking for?

When you use DoCmd.OpenForm, the fifth argument is DataMode, which can be
set to acFormAdd, acFormEdit, acFormPropertySettings or acFormReadOnly. The
default is acFormPropertySettings.

Rather than:

DoCmd.OpenForm "MyForm"

you can use

DoCmd.OpenForm "MyForm", , , , acFormAdd

or

DoCmd.OpenForm "MyForm", DataMode := acFormAdd

What specifically do you mean by "the MS Access window"? Are you talking
about the database window (that lists the tables, queries, forms, etc.), or
are you talking about the entire window that contains the menu bars? Getting
rid of the former is easy: under Tools | Startup, uncheck "Display Database
Window"

For the latter, take a look at http://www.mvps.org/access/api/api0019.htm at
"The Access Web". Pay special attention to the warning, though. Remember,
you're trying to make Access do something that it really wasn't intended to
do.

 

[David Langschied]

I thank you for your response, though I did not think what I said was
ambiguous, you have indicated in your response exactly what I am looking for.

I think my best route is to create a form that opens the data entry form in
add mode using acFormAdd in the datamode position.

On minimizing (or hiding) Access window, I am looking to simply have my
application the only thing seen by the user. It looks a little more complex
than I had hoped.

I do thank you for your help!