Solved

Show IDE window from form

Posted on 2012-04-11
3
291 Views
Last Modified: 2012-04-17
Is there a way to display the ide in MS Access using code? I would like to have a database form that if the user puts in the correct password the ide is displayed.
0
Comment
Question by:Howiee22
3 Comments
 
LVL 15

Expert Comment

by:David L. Hansen
Comment Utility
Try this:

Application.SendKeys("%{F11}")
0
 

Author Comment

by:Howiee22
Comment Utility
Sorry, I didn't add one item (important). I am disabling the special keys on startup so the send key functionality does not work. Sorry, I should have included that. I was able to solve the problem using DoCmd.RunCommand acCmdDebugWindow
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
Comment Utility
Here you go:


Private Sub Command1_Click()
   VBE.MainWindow.Visible = True
End Sub


mx
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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 …
Outlook Free & Paid Tools
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

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

16 Experts available now in Live!

Get 1:1 Help Now