Controlling the Access Window size

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top