poss a silly question, but basically i have a database where its properties mean when it is opened (enter / double click) the actual database, and options (file/edit/...etc) are hidden and only the 'start up' form is shown, from where people can navigate the database through forms etc. by pressing shift enter (at home) will allow me 'fully' access. however, at work where the database is used, the shift key is dissabled. is there a way i can put a button on the start up form which when pressed/clicked, i could get into the full database as like pressing shift enter?? a back door as such
cheers
9 3518 NeoPa 32,556
Expert Mod 16PB
Normally a double-click or such other event on a particular area of your main form is used as a trigger for getting in.
I don't have menus disabled in mine, but I use ... - Call DoCmd.SelectObject(Objecttype:=acForm, _
-
Objectname:="frmMainMenu", _
-
InDatabaseWindow:=True)
... to get access to the database window. frmMainMenu is the name of my startup form. You'd need to replace this with your own one.
NeoPa 32,556
Expert Mod 16PB
I did a little more digging and found another line that could be even more helpful. - Call DoCmd.RunCommand(Command:=acCmdStartupProperties)
many thanks for your help, will give it a try. cheers
NeoPa 32,556
Expert Mod 16PB
No problems. Let us know how you get on :)
interesting, using the last code, works fine at home (access 2007), but when save as a 2002 format, and opened at work doesnt.
I've put the code on so when you doible click a label, it opens the databases attributes/properties box, i can then set 'show database' etc, but it doesnt work at work?? any ideas
cheers
NeoPa 32,556
Expert Mod 16PB
I'm afraid I don't know much about differences between versions. It works on my home system (under Access 2003). Have you looked in the help system when you're on your work system to see what it says about it?
hi works computers are so limited, that they even block that function. but cheers for all your help, i'll see if i can get around it.
thanks
NeoPa 32,556
Expert Mod 16PB
In what way is it blocked?
Is it simply that a reference is not set?
its a big company i work for, they block access to lots of things. loads of 'red tape' to go through to get access to stuff. but cheers anyway
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Mariusz |
last post by:
Hi,
I would like to use shift button to select multiple rows in table but there
seems to be problem with it. I have table rows inside the <a> tag so I can
drag them and drop like in windows...
|
by: Susan Bricker |
last post by:
I know that I saw some information concerning the <shift>+<enter>
combination use to bypass launching an Access mdb application and enter
the Access design workspace. Would someone please direct...
|
by: Paul T. RONG |
last post by:
Dear All,
I add two new tables to the database and then the disable shift key codes
don't work. These two new tables are actually created by two queries, and
only these two are in the front end,...
|
by: Vazz |
last post by:
I am trying to capture the key combination "Control + Shift + Enter"
in a KeyDown event. I am able capture "Control + Enter" using
(e.KeyCode == Keys.Enter && e.Modifiers == Keys.Control). How do I...
|
by: Csaba Gabor |
last post by:
I'd like to detect the shift key when a button is "clicked" in
Firefox/Mozilla. If the button is clicked with the mouse, no problem.
However, if the onclick event is keyboard originated, then my...
|
by: pemigh |
last post by:
Client's fingers have been well trained on another application to wrap
lines by hitting shift-enter, and wants the same in Access application.
Changing "enter key behavior" for controls is not...
|
by: dotnetnoob |
last post by:
when the user log into my application, there is a dialog pop up with some
paramereters that need to set.
a radio button is default to checked and a textbox is right next to it. i
want the cursor...
|
by: Sunfire |
last post by:
I was wondering if there was a way to hit enter to insert blank lines while
in the designer? I tried this but all it seems to want to do is insert code
that really shouldn't be there. For example,...
|
by: buddyr |
last post by:
can I use VB to work in microsoft excel to cause the enter button to shift to the right instead of down. I only want one worksheet to have this in.
Trying to get code in Private Sub...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |