Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / March 2006

Tip: Looking for answers? Try searching our database.

Can anyone tell me how to enable F-11 database window view in mde?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MLH - 21 Mar 2006 17:05 GMT
Some sites I've rolled out mde's to allow user to press
F-11 & bring up database window. Others do not. Anybody
know what setting controls this? Strange is that the app
is the same in each location - compiled to mde using same
source mdb.
fredg - 21 Mar 2006 17:55 GMT
> Some sites I've rolled out mde's to allow user to press
> F-11 & bring up database window. Others do not. Anybody
> know what setting controls this? Strange is that the app
> is the same in each location - compiled to mde using same
> source mdb.

Hold down the shift key when you open the database.
Then:
Tools + StartUp + place a check in "Use Special Access Keys" check
box.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

MLH - 21 Mar 2006 21:30 GMT
>> Some sites I've rolled out mde's to allow user to press
>> F-11 & bring up database window. Others do not. Anybody
[quoted text clipped - 6 lines]
>Tools + StartUp + place a check in "Use Special Access Keys" check
>box.
Many thx, Fred. Is this something I should have each user do at their
remote sites? Or, would you recommend I do this here - to the mdb -
prior to compiling their mde file?
MLH - 21 Mar 2006 21:55 GMT
Let me explain why I ask:

In my development copy of the mdb, I built the application
with the Tools, Startup, Advanced, Use Access Special Keys
setting checked - pretty much from the very beginning.

When I compile any user's mde file, I use the same source mdb
file to feed the mde creation process. Afterward, I do nothing to
the mde, as a rule. From installation to installation, the
applications differ only in minor content of certain tables, label
control content on the main menu form and maybe some other
very minor differences. Most definitely, I've never monkeyed
with the setting of the above decribed menuitems.

Finished installations in the runtime environment seem to vary in
their behavior. Some allow the F-11 keystroke to open the dbase
window - others do not.

I've wondered if its due to versioning. Perhaps I did something
different in preparing the original installation fileset at some
sites. I can't recall. Each time I do a new revision rollout and a
data migration, I find myself crossing my fingers hoping that the
behavior will change from site to site. Apparently it is not going to.
Maybe this setting is to the runtime executable itself and not data-
base file-specific. Sound right?

Anyway... The F-11 key is quite handy, actually. But if I'm unable
to improve the reliability of its use in my runtime rollouts, I'll use
the following work-around in code...

        DoCmd.SelectObject acTable, "tblAdmin", True

The line has always worked for me.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.