Re: irrational minimize, restore,maximize behavior-how to control

Tech-Archive recommends: Fix windows errors by optimizing your registry



OK. Two things. You realize that it IS opening up the query already maximized? It is certainly easy enough to add that command, and I will try it...
As far as hitting F11: I will try that. Do you know why this is happening though? There is nothing in the code that opens it up that would be responsible, and it is being opened in "normal" window mode. Is this some special feature being activated because it is being opened from AutoExec?

Thanx





Jerry Whittle wrote:
Make your code that opens the query look something like this:
Dim stDocName As String

stDocName = "Keensie_Crosstab"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.Maximize

The DoCmd.Maximize is the trick.

As far as the database window, try pressing the F11 key. Unless someone locked up the database window, the F11 key should bring it to the forefront.
.



Relevant Pages

  • Re: Access to Tables
    ... directly into the query and edit the data there still ... I've implemented a switchboard startup form ... for them to use, disabled the database window so they can't find the tables, ... disabled the F11 key and the shift-bypass key, created a custom file menu, ...
    (microsoft.public.access.security)
  • RE: records that are in one table but do not have matches in another t
    ... Assuming that you have a version of Access older than 2007, press the F11 key ... to bring up the Database Window. ... Next go to the Queries button/tab. ... Keith Bontrager - Bicycle Builder. ...
    (microsoft.public.access.queries)
  • Re: queries
    ... you can always show the database window using code. ... Graham Mandeno ... if username is equal to admin, then allow for F11 key to be ... If i disable F11 all together then even the admin can't have access to the ...
    (microsoft.public.access.formscoding)
  • Re: queries
    ... Do you know if i can control the disable of F11 key via code? ... If i disable F11 all together then even the admin can't have access to the ... If you really want to hide individual objects but show the database window, ... Graham Mandeno ...
    (microsoft.public.access.formscoding)
  • Re: queries
    ... disable the F11 key. ... If you really want to hide individual objects but show the database window, ... Learning ...
    (microsoft.public.access.formscoding)