Solved

Show IDE window from form

Posted on 2012-04-11
3
295 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
ID: 37835206
Try this:

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

Author Comment

by:Howiee22
ID: 37835372
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 - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 37835392
Here you go:


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


mx
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
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…

830 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