hiddlen form question?

[Gary]

Hi,

Is it possible when I open any form other opening forms in access can
hiddlen automatic,

Thank for help!!

Gary

 

[PC Datatsheet]

Gary,

Put the following code in the first form where you are opening the second form:
Me.Visible = False
DoCmd.OpenForm "Form2"

 

[Michael Cheng [MSFT]]

Hi Gary,

I am just checking on your progress regarding the information that
community member provided! I wonder how the testing is going, could you
make it successfully following his steps? If you encounter any difficulty,
please do not hesitate to let me know.

Looking forward to hearing from you soon

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.

 

[Gary]

Hi Michael,

Following the step I can hiddlen the form when open another form,
but my question is, I have many form in my access program,
how can I add same code in all forms open event to let access to hiddlen
any forms is open.

Thank!!

Gary

 

[Mingqing Cheng [MSFT]]

Hi Gary,

From your descriptions, I am not very sure about what your want and what
your concerns are. Would you please show me some scenario? Detailed
information will get us closer to the resolutions

Based on my understanding, I think your concerns maybe the following
1. You could not know which form will be opened next so that you are not
sure where to insert that kind of codes.
If so, you could add the following codes in On Deactivate event in current
from.
Me.Visible = False

2. You want to keep every form as hidden at the startup except one form
If so, you would find a selection in Tools -> Startup..
Deselect 'display database window' and choose the startup form in Display
Form/Page

3. If your concerns is there is so many forms to be added such kind of
codes, I am afraid that I don't think is better method we could provide now
and I am sorry for the inconvenience you may meet.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!

Sincerely yours,

Mingqing Cheng
Microsoft Online Support

 

[Guest]

Hi Mingqing,

From your answer1, did you mean I put this "Me.Visible = False" in On
Deactivate event,
when I open another form, this form will automatic hiddlen.
I have try, but it not work.

Gary

 

[Mingqing Cheng [MSFT]]

Hi Gary

Thanks for your prompt reply!

For my answer 1, I did mean put the codes like tihis

Private Sub Form_Deactivate()
Me.Visible = False
End Sub

You could apply this codes in Form A and when Form B is open, Form A will
automatically hidden. It works fine on my machine and I could send you a
sample mdb file If you need my sample, would you please post your email
here or just sending me an email if you have strong concerns about posting
it public, I could be access by emailing to (e-mail address removed)
(please remove online, it's for SPAM only)


Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Online Support

 

[Gary]

Hi Mingqing,

I know the reson! Why the code for me is no use.
I set it to a popup form.

Thank for help!!

Gary