ACCESS FEED: RE: [MS_AccessPros] Open others forms in their own form size

Jumat, 18 Mei 2012

RE: [MS_AccessPros] Open others forms in their own form size

Hendra-

Note that there's no parameter for the Maximize command. When you Maximize, it
applies to every normal form or report open in the workspace. The only way to
make a form appear on top in a "normal" window is to make it PopUp or Dialog.
Both will float on top of any normal forms until they're closed. A Dialog form
prevents putting the focus on any other form until you close it.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

--------------------------

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Saturday, May 19, 2012 5:50 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Open others forms in their own form size

Hi All...

I opened a form called F_Display with event on open (F_Display On Open)
= DoCmd.Maximize.
How can i open other form (let say F_Employee form) using command
button on F_Display and then the F_Employee form opened with it's size
that we had adjusted in design view ?
I have tried with code :
DoCmd.OpenForm "F_Employee", acNormal, , , , acWindowNormal

but the F_Employee form opened in Maximize mode, and it's the same
condition to all of forms that i try to open.
Hope my words are not confusing, any directions would be appreciated...

Regards
Hendra