Solved

How can i open an access form from the desktop without it opening up in access?

Posted on 2011-02-14
8
315 Views
Last Modified: 2012-05-11
Ive got a access form with a few buttons that i can use to either input data or open reports, im wanting to know if its possible to open this form up from the desktop in its own window without it opening up in access?

0
Comment
Question by:midIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
8 Comments
 
LVL 75
ID: 34894204
Yes ... man, this is coming up a lot lately.

See this:

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

mx
0
 
LVL 75
ID: 34894211
Also download this little app (free):

http://www.peterssoftware.com/fsd.htm

Has the exact example of doing this ...  as well as forcing that form (optionally) on top of all other windows.

mx
0
 
LVL 75
ID: 34894218
Oh ... and yes, you can drag a Form from the database window onto the Desktop.  It will create a shortcut that will ... open the mdb, and then that form.   So, if you use the code above, you will just see the Form - after a brief flash of the Access app window.

mx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 75
ID: 34894254
"without it opening up in access?"
Technically of course, it's still opening up inside of Access, you just don't see the Access app window.

mx
0
 

Author Comment

by:midIT
ID: 34894270
thanks im just having a look through the code you sent me trying to get it to work, im not very familiar with access at all, i do realise its still opening access but i want the access app window closed so all i can see is a form and when im finished i can click on a close button.

are you able to tell me how to insert the code so i could open a form called menu?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 34894290
"but i want the access app window closed "
No can do. Access app window will be hidden only.

The code in the first post needs to be in your start up code.

Your button code to close would look like this:

Private Sub btnClose_Click()
    Application.Quit
End Sub

mx
0
 
LVL 84
ID: 34895569
In addition to what MX said (and please not points for me, since mx answered your question):

Access forms MUST be run in the Access environment. They cannot exist outside of that environment. The trick suuplied by mx at his first link is the only method available to even partially hide the fact that you're working in Access, however be warned that it often doesn't work well on newer operating systems, and can be quite hit-or-miss (i.e. it will work on MachineA but not MachineB). It also requires all forms to be launched in Popup mode, which means that users are working in a Single Document Interface model (i.e. you interact with only 1 form, then must close thta form to move to the next, etc etc).

In the end, if you don't want users to know that you've done this in Access ... then don't do it in Access. Use VB.NET or some other langauge that allows you to build a fully stand-alone product.
0
 

Author Closing Comment

by:midIT
ID: 35010771
I could see how it would work, but i couldnt get it to work
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question