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

Sabtu, 19 Mei 2012

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

Thank you very much John,... Now i will post a new thread...
Regards
Hendra

________________________________
Dari: John Viescas <JohnV@msn.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Sabtu, 19 Mei 2012 18:05
Judul: RE: [MS_AccessPros] Open others forms in their own form size

Hendra-

No. But the user won't be able to click anywhere else but the dialog form (within Access).

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 Agestha Hendra
Sent: Saturday, May 19, 2012 12:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Bls: [MS_AccessPros] Open others forms in their own form size

Thank You John,...your explanation really help me...
About Open Dialog, ...is there any effect to application or to computer if we open a form in dialog mode and let it opened for long time (let say about 8 hours) ?
for information, on the form there is an event On Timer.
Regards
Hendra

________________________________
Dari: John Viescas <JohnV@msn.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Sabtu, 19 Mei 2012 13:04
Judul: 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

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]