?
Solved

MS Access 2007

Posted on 2011-03-25
3
Medium Priority
?
227 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 1000 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

594 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