• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

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

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
midIT
Asked:
midIT
  • 5
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Yes ... man, this is coming up a lot lately.

See this:

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

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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
 
midITAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
midITAuthor Commented:
I could see how it would work, but i couldnt get it to work
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now