Solved

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

Posted on 2011-02-14
8
325 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

636 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