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.

You can copy the code from this site into a standard module:

http://www.mvps.org/access/api/api0019.htm
--
Dave Hargis, Microsoft Access MVP


"Bob Bridges" wrote:

> 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.