how i can display only the form without the MS Access window?

[Guest]

Hi,
I want my database to display only the form window when users open it,
without showing the user the Microsoft Access window in the background or the
database window?

 

[Rick Brandt]

Hi,
I want my database to display only the form window when users open it,
without showing the user the Microsoft Access window in the background or the
database window?

Code at link below can do this.

http://www.mvps.org/access/api/api0019.htm

However, this imposes severe restrictions on what you can do in your app.
Imagine using Excel with just the grid of one file showing and no Excel window
or Word with just the doc on the screen.

I have used this once or twice for small utility programs that contained exactly
one form. For a "normal" Access app it is just not practical. For example you
have to do a lot of work to preview a report because you have to re-display the
Access window to do that and then re-hide it when the report is closed.
Handling errors or any other dialogs is a problem also.

Access is not VB. Trying to make it look like VB is seldom a good idea.

 

[Guest]

Hi

I thank you for you'r cooperation i used the codes but i think that there
is some thing wrong in my steps wish is that i get messd in puting the codes
in the open form event or in new module?or in both? and do i name the module
with "basSetAccessWindow" or live it ..... i realy get lost!!!!

can you wake with me from the begning?

 

[Rick Brandt]

Hi

I thank you for you'r cooperation i used the codes but i think that there
is some thing wrong in my steps wish is that i get messd in puting the codes
in the open form event or in new module?or in both? and do i name the module
with "basSetAccessWindow" or live it ..... i realy get lost!!!!

can you wake with me from the begning?

The code goes into a new module and you CALL it from the open event of the
form.