Solved

How to launch visual basic in access with hotkey?

Posted on 2012-03-14
9
396 Views
Last Modified: 2012-03-14
I'm trying to put in a back door to get into visual basic from a form in access. On the forms KeyDown event I want to put in code to say when Ctrl+Shift+Q is pressed it will launch Visual Basic, which is also password protected. Any idea if that can be done?

Thanks for the help!
0
Comment
Question by:SeyerIT
[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
9 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 37720128
I'm not sure about applying the password programatically, but this will open the VB Editor:

VBE.MainWindow.Visible = True
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 37720181
Any Idea on the hotkey setup?

I tried the following and couldn't get the VBE to come up;

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)

     'checks to see if m is capitalized
    If KeyCode = vbKeyM And Shift = 1 Then
       
        VBE.MainWindow.Visible = True
       
    End If

End Sub


Ultimately I would like to use Ctrl+Shift+Q to open it.. Just don't know that code quite yet. Found this code above on another page.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37720199
are you trying to modify codes while the form is in "Form" view?
i suggest not to, because this might lead to form corruption.

while form in design view, just hit  Alt + F11
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 2

Author Comment

by:SeyerIT
ID: 37720223
Actually trying to create a backdoor to a module that prevents the database from being opened in Shift mode. I have to be able to get to that module to enable shift mode so that I can get back into design view for the database.

Here is a link where I started this process;

http://www.dbforums.com/microsoft-access/1008303-disable-shift-open.html
0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 500 total points
ID: 37720249
Just use a commandbutton, hidden, disguised, or password protected to run that function to toggle that property.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37720259
Some of our applications here have tiny password protected labels that blend in with the background of the form that the dba's use to bring up an 'admin' form, which has enable/disable shift key bypass buttons and other things.

It's not 100% secure of course, but it is okay for our environment.
0
 
LVL 2

Author Closing Comment

by:SeyerIT
ID: 37720274
That will work!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37720351
FWIW.

My guess is what mbizup posted is the most straightforward technique...

Just as an FYI, You can create an AutoKeys Macro that open the VBE using a hot key.

See this sample...
Open the DB, and at any point if you press Ctrl+Shift+Q, the VBE will open.
Database1001.mdb
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 37720405
Thanks Boag. Also a good method!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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 …

717 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