mde queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anand Vaidya - 30 Apr 2006 15:31 GMT

I have 2 questions concerned to deployment

1. Can I supress the "Security Warning" dialog box when I open an MDE file.I
want my first form (Login form) to be opened directly when ever I open the
exe file.(I selected Display Form/Page as login form (frmLogin) in Tools -
Start up option)

2.Can I supress the default menu while making an MDE file. I don't want any
menu bar,neither do I want the min,max and close button. In a word I don't
want the window(with File,Window,Help menus) that is being displayed at the
back of my login form.I just want my login form to be displayed when I open
the mde. The reason is when a user logs in and logs out, his time is recorded
in the application(the code of which is written in the buttons btnlogin and
btnlogOut).So if a user logs in and closes the application using close button
(which I don't want it to be existing),his log out time would not be
recorded.

-------------
Anand Vaidya
I'm here to know.

Reply to this Message

Albert D.Kallal - 02 May 2006 20:38 GMT

> 1. Can I supress the "Security Warning" dialog box when I open an MDE
> file.I
> want my first form (Login form) to be opened directly when ever I open the
> exe file.(I selected Display Form/Page as login form (frmLogin) in Tools -
> Start up option)

Yes, set the macro-security to low. You can do this via
tools->macro->security.
(this will remove all nags).

> 2.Can I supress the default menu while making an MDE file.

You can suppress the default menu...but you certainly don't do this *while*
making the MDE file. If you plan to hide the ms-access interface, then you
would do so with you mdb file LONG before you create the mde..

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

>In a word I don't

want the window...

Gee, trying to control, and hide features such as those in outlook, or word
is going to be quite difficult. It can be done..but trying to modify, and
control words menus from ms-access will take some good code, and good
knowledge on your part of both ms-access, and the word object model...

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Reply to this Message