?
Solved

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

Posted on 2011-02-14
8
Medium Priority
?
335 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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 1000 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 85
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

This is an article on how to answer questions, earn points and become an expert.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

600 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