DoCmd.Echo True/False

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jac Tremblay - 07 Dec 2005 15:47 GMT

Hi,
I have tried this option but it does not work in my case.
What I'm tring to do is hide the database window when I display my own
forms. But I can see it appearing and disappearing in the background which is
not very professional.
Here is some simple code on a form_Load event.
' ************************************
Private Sub Form_Load()
DoCmd.Echo False
DoCmd.SelectObject acForm, "frmReports", True
RunCommand acCmdWindowHide
DoCmd.Echo True
End Sub
' ************************************
What's wrong with my way of doing?
Thanks.

Signature

Jac Tremblay

Reply to this Message

Douglas J Steele - 07 Dec 2005 16:17 GMT

Use DoCmd.OpenForm instead.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
> I have tried this option but it does not work in my case.
[quoted text clipped - 12 lines]
> What's wrong with my way of doing?
> Thanks.

Reply to this Message

Jac Tremblay - 08 Dec 2005 00:43 GMT

Hi Douglas,
There are two problems in my post (4 line of code). I first need to hide the
database window from the user's view and the only way I found is to select a
form in it and then use the "RunCommand acCmdWindowHide" instruction. It
works all right but the flickering of the screen is visible and I would like
to run it in the background. I know that "Application.ScreenUpdating = False"
is the VB way of doing so I searched the newsgroup and found the "DoCmd.Echo
False" command. I tried it but it does not do the job (in my case).

If there is another easier way to hide the database window, please let me
know. It should be something like :
DatebaseWindow.Visible = False

If there is a way to hide the screen updating while this is happening,
again, please say so.

I do not understand why you say : "Use DoCmd.OpenForm instead". Could you
explain a bit, please?

Thank you for your comment.

Signature

Jac Tremblay

> Use DoCmd.OpenForm instead.
>
[quoted text clipped - 15 lines]
> > What's wrong with my way of doing?
> > Thanks.

Reply to this Message

Ofer - 07 Dec 2005 16:29 GMT

Try and move the RunCommand acCmdWindowHide to the start of the code.
Or even better, when the application start running

Signature

Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck

> Hi,
> I have tried this option but it does not work in my case.
[quoted text clipped - 12 lines]
> What's wrong with my way of doing?
> Thanks.

Reply to this Message

Jac Tremblay - 08 Dec 2005 00:47 GMT

Hi Ofer,
The command "RunCommand acCmdWindowHide" is in the Form_Load event and is
the only thing I do there. I just want to hide the window display from the
user's eyes. Why can I not just write:
DatabaseWindow.Visible = False?

Thanks for your comment.

Signature

Jac Tremblay

> Try and move the RunCommand acCmdWindowHide to the start of the code.
> Or even better, when the application start running
[quoted text clipped - 15 lines]
> > What's wrong with my way of doing?
> > Thanks.

Reply to this Message