Controlling the Access Window size

  • Thread starter Thread starter Bob Bridges
  • Start date Start date
B

Bob Bridges

Is there a method to maximize the Access window inside VB code? I've found a
workaround to do it from outside the Access objects, but I figure I must be
doing it the hard way. Can anyone tell me?

The workaround, in case it's germane, is a VBScript program. I'm using a
VBS to open Access, do an OpenCurrentDatabase and then open one of the db's
forms. The db has VBA code in it so naturally Access stops to ask me whether
I'm sure I want to open it; I don't suppose there's a way to get around that
(at least I hope there isn't), so I had the main VBS trigger a subordinate
VBS to AppActivate the warning and SendKeys my automated reply. Since that
secondary program was there anyway, I also had it AppActivate and maximize
the Access window. But that's silly; surely there's a way to do it from
within the Access Application? Anyone know?

Since I have a workaround, no need to miss lunch to answer this question;
it'd just be nice to know the answer if you have it off the top of your head.
 
Back
Top