Solved

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

Posted on 2011-02-14
8
299 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
  • 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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 - Access MVP) 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

785 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