How can I maximized the Access window?

[wheelshot]

I work on an Access database and from it, I open a second Access database in another window. I want, in VBA, it to maximize. Please help me.

P.S. I'm good in Access but make your tips with details

Thanks in advance!

 

[Judith]

Hi,

what you want to do is in fact not quite so easy as it sounds. In order to manipulate the Access window from VBA code, you have to make calls to the Windows application programming interface (API) functions.

If you don't mind to give me your email address, I will send you a example that shows how it works. The code will not only maximize or minimize the Access window. It provides also the possibility to hide it completely, so that you only see your application form.

Hope this helps,
Judith

 

[wheelshot]

My e-mail is: wheelshot@hotmail.com

Thank you Judith!

 

[llyal]

Can't one use the SHELL Function?

In VBA, on can do:

Dim ShellFunction
ShellFunction = Shell("msaccess.exe" & " " & "e:\temp\Test.mdb", vbMaximizedFocus)

this will open a database in full screen mode;

Llyal

 

[min]

llyal,

it will work. But, you open up another access window instead open the *.mdb file with the existing MS Access Application. Right?

 

[chriswc]

I need to maximize the Access Application Window after I run a DOS batch file. Is it possible to get a copy of the previously mentioned Windows API code. My E-mail is chilcott@mnr.org. I will be Greatly appreciative if this is possible.