access form as shortcut

  • Thread starter Thread starter amitbadgi
  • Start date Start date
A

amitbadgi

Hi guys, I have created a form in access and attached it to a access
database and everythign is working fine, i want to know how do I create

an icon on teh desktop, so that if a employee clicks on it, teh form
opens up, i tried creating teh short cut method, but it opens the form
in ms access, i dnt want that, if I click teh icon, only the form shld
open seperately, not in access,liek any other software, can we do it?,
any help is appreciated.
 
that is not going to work. A form is an object within Access, not a stand
alone executeable. The closest you can get is to configure your Access
database to open the form on startup.
 
Klatuu said:
that is not going to work. A form is an object within Access, not a
stand alone executeable. The closest you can get is to configure
your Access database to open the form on startup.
Click to expand...

Actually, if I understand the question correctly, it is possible to have
the form hide the Access window when it is opened. Access will still be
open, because Klatuu is right that there is no such thing as a
standalone Access form, but it won't be evident to the user. You can
create a shortcut on the desktop to an Access form, such that
double-clicking it opens Access, the database, and the form. You can
use the code posted here:

http://www.mvps.org/access/api/api0019.htm
API: Manipulate Access Window

to hide the Access window in the form's Open event. Note: although the
article doesn't make it clear, the form must be set as both PopUp and
Modal.

Note also that this technique requires some careful coding, and is
really not much use unless it's just the one form you want to show.
 
liek any other software, can we do it?,
any help is appreciated.
Click to expand...

Actually, ms-access is part of office, and if you look at excel, word, and
most of office, you get a main large windows, and then small windows inside.
So, for word, you get a large window, and all of the documents appear inside
of that window (and, note how the menu bar stays at the top of the
application, not the top of the window). So, for about 10 years now,
virtually the MOST popular software (word, Excel) you been using works
EXACTLY like ms-access. So, not really sure what you mean by "other"
software, as the MOST popular software works just like ms-access.

Having said the above, I do have a sample application that hides ALL of the
ms-access interface (you can accomplish this via using the tools->startup
options).
Note that you DO NOT have to use any code to accomplishing this hiding of
the ms-access interface.

Try downloading, and running the 3rd example here:
http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

(ms-access interface is the one you want)

After you try the application, you can take a look at the startup settings
to see what settings you need, and how this is done.
 
Back
Top