Solved

How to launch visual basic in access with hotkey?

Posted on 2012-03-14
9
335 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
9 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
Comment Utility
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
Comment Utility
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 119

Expert Comment

by:Rey Obrero
Comment Utility
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
 
LVL 2

Author Comment

by:SeyerIT
Comment Utility
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 61

Assisted Solution

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

Expert Comment

by:mbizup
Comment Utility
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
Comment Utility
That will work!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
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
Comment Utility
Thanks Boag. Also a good method!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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…

763 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

12 Experts available now in Live!

Get 1:1 Help Now