Openning a form

R

Rick

Is there a way to click on a desktop icon and open a database form without
openning the access program window behind it?
 
A

Albert D. Kallal

You can do this, however it usually causes a number of problems.

Remember, word, or excel has always had a menu bar up at top..and a grey
background (if you don't max the document).

Since excel, and word been that way for years...it not much of a deal.

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
 
D

Damian S

Hi Rick,

If you are asking if you can open an Access database without the Access
application being open, then no.

If you want to display an Access database form without the database window
showing, set the startup properties of the database to open the form, and
untick the "show database window" checkbox.

If you want just a simple form to open without Access at all, you will need
to use another language, such as Visual Basic.

Hope this helps.

Damian.
 
Top