Making Forms Invisible 3

[alexbel]

Hi,

I use the following code to open a form and make it invisible:

    stDocName = "Formname"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    
    Form_Formname.Visible = False

However, with this code, when the form opens, it is visible for a few seconds before it becomes invisible.

My question is how can I make the form not show before it becomes invisible?


Thank you

 

[PHV]

Have you tried to play with the Application.Echo method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

Have you tried to play with Application.Echo method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[FancyPrairie]

Try this:

DoCmd.OpenForm stDocName,,,stLinkCriteria,,acHidden

 

[alexbel]

PHV,

I am not sure how to use Application.Echo method. I tried Access help but it didn't help me.


FancyPrairie,

I tried that code but when the form opened, it did not become invisible at all, it just stayed visible in the background!


What might the problem be?


Thank you

 

[PHV]

Take a look here:

http://msdn.microsoft.com/library/en-us/vbaac11/html/acmthEcho.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[alexbel]

I have another question:

Using this code:

    Application.Echo False
    DoCmd.Hourglass True
    DoCmd.OpenForm "Formname", acNormal
    DoCmd.Minimize
    Application.Echo True
    DoCmd.Hourglass False

How can I alter it to make the form be invisible instead of minimize? I tried changing acNormal to acHidden but it gave me an error.


Thank you

 

[PHV]

Have you tried something like this ?
Forms("Formname").Visible = False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[FancyPrairie]

I don't know what you did wrong, but check your syntax. I just issued this command and it worked fine (note 5 commas).

DoCmd.OpenForm "form1", , , , , acHidden

I just realized, you put the acHidden argument in the acNormal position.

 

[TheAceMan1]

How are ya alexbel . . . . .

[blue]FancyPrairie[/blue] is correct! Should be:

[blue]   stDocName = "Formname"
   DoCmd.OpenForm "stDocName", acNormal, , , , [purple][b]acHidden[/b][/purple]
[/blue]

See Ya! . . . . . .

 

[alexbel]

Thank you PHV!

I didn't think of that for some reason.


FancyPrairie,

It still didn't work! I don't know what's wrong.


Thank you all

 

[alexbel]

Oh, TheAceMan1

That is what I was doing wrong! Thank you for clarifying!