Solved

MS Access 2007

Posted on 2011-03-25
3
216 Views
Last Modified: 2012-06-27
We have created a database with a form that populates the database. Currently when we open Access the form opens immediately. However the Access program opens behind the form. We would like to know how to have only the form open with out the having the program open behind the form.  
0
Comment
Question by:superguyent1
  • 2
3 Comments
 
LVL 75
ID: 35219152
Here you go.  Be *sure* to read the warnings ...

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

mx
0
 
LVL 44

Accepted Solution

by:
GRayL earned 250 total points
ID: 35220249
IOW,  you can't.  The application has to open before it creates one of its objects.  You can be 'sneaky' and hide the opeing screen, but nevertheless, the app has to be opened before the object can be created.
0
 
LVL 75
ID: 35418005
"We would like to know how to have only the form open with out the having the program open behind the form"

superguyent1:
The code I posted allows you to do that.  Did you try that approach ?

mx
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now