Disable or Hide or What?

[pullmyefinger]

2003:

I have a command button that has focus, can I hide it using "visible"?? I already tried .enabled=False and that doesn't work. How do I accomplish this or work around it? LostFocus Won't work..

How do I make variables "Global" so I don't have to keep redefining them in event procs? An Example would help.

Last, can i put an event proc in Declarations and have it be "global" (the results of the procedure; variables, control values, etc.).

 

[vbaInet]

Nope! It must not have focus if you're going to make it invisible.

In a Standard Module (i.e. not a Form or Report Module)

Public myVariable As String

Nope! A procedure does not go in the Declarations section. The Declarations section is meant for declaration of variables.

 

[pullmyefinger]

yeah, i tried the .visible=false coding and it didn't work either.

last idea before I scrap the record navigation cmdbuttons. logic follows:

since i can't hide or disable a control that has focus in access, i was reading about
an event or property called Current or OnCurrent?? which is correct, and is it a property or an event?

it said something about when you change records in a form that event gets activated
every time??

if i can get to a current event or property within the same form and find out the current record in the table serving the form, Then can I say in the Current(event or property) to hide or disable the appropriate command button??

the only way that i can see this not working is if the command button keeps focus AND the aformentioned Current prop or event takes place.

If the above won't work, how to programmers that write apps disable cmd buttons? Where do I find that code (I don't have command button wizards and they are not in as an add-ins. Do I have to dump and reinstall Office 2003??)

If I have to write the code myself and it takes more than 10 lines then it is not worth it.

Where do i find/how do i create a standard module?

 

[vbaInet]

Drop a button on your form, set its Back Style property to Transparent. Set focus to this button before you make the control invisble.

Standard Module:

http://office.microsoft.com/en-us/access-help/database-basics-HA010064450.aspx#BMmodules

 

[pullmyefinger]

Perfect. If I wasn't so new to this I woulda had that idea in my toolbox.

You never called yourself an expert like others have. You proved it with your answers.

Thank You.

 

[vbaInet]

Happy to hear it's resolved!