.Visable help needed 1

[dgirl1010]

I have a form to detect idle time and close a db after a certain amount of time has been reached. It is launched at startup and hidden from the user. In order to close the form the user must enter a password.

If the user hits cancel on the password prompt, I want to close the password prompt and rehide the detect idle time form, but I'm getting an error that says, "Application-defined or object-defined error"

This is my code, line two is where I get the error when I debug:

Private Sub cmd_Cancel_Click()
[COLOR=red]Forms!DetectIdleTime.Visable = False[/color]
DoCmd.Close acForm, "PasswordPrompt"

 

[SkipVought]

Hi,

Try Vis[red]i[/red]ble

Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

Also try using Debug/Compile...

Skip,
[sub]
[red][/red]
[/sub]

 

[dgirl1010]

Hmmm, weeeelll, that does work better...

 

[dgirl1010]

Thanks Skip, I did a debug/compile and it didn't catch it. :?

 

[SkipVought]

Shows you ALL the alligators in the swamp!

Skip,
[sub]
[red][/red]
[/sub]

 

[ZmrAbdulla]

Some thing I noticed when typing in the code window to use only lowercase for properties like .enabled, .visible, docmd, acform etc..

It will automatically change them to proper style (.Enabled, .Visible.DoCmd, acForm ). Not changing means typed is not correct.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Take the first step in faith. You don't have to see the whole staircase, just take the first step.
(Dr. Martin Luther King Jr.)

 

[JoeAtWork]

Yes, that's why I always use mixed case for my variable names. I usually catch misspellings as soon as I hit ENTER.

 

[eAlchemist]

You might consider Option Explicit, then the debug will catch these sort of misspellings.

Chris