Weird simple code not working

[mvorous]

Hello, first post..., I have installed, and now have re-installed the MS Office 2007 Suite Professional onto my Vista OS, due to this problem. I am simply trying to use VBA to make a textbox invisable when a button is clicked.

Option Compare Database
Private Sub cmdMakeTxtInvisible_Click()
Text62.Visible = False
End Sub

Any help here? I don't have any "Missing" references.
Thank you, mvorous

 

[chris davies]

I'm not 100% sure here, but looking at the properties for testbox/visible, all I see is a Yes or No option. Have you tried the word No instead of False?

 

[pbaldy]

Make sure the first thing listed here isn't the problem:

http://allenbrowne.com/Access2007.html#Configuration

You may see something under the ribbon about code being disabled.

 

[Banana]

In Visual Basic Editor, go Tool -> References.

See if there's any checkbox next to MISSING:....

 

[mvorous]

Yes I have, True/False, Yes/No & -1/0, but the intellesense (if I got that right, offers the True/False...
Thx

 

[Anthony George]

Try This

Hi

Have you tried:

Me!Text62.Visible = False

or

Forms![name_of_your_form]![Text62].Visible = False

I have not got 2007 or vista but maybe the syntax required is a bit less forgiving

All the best

Tony

 

[mvorous]

No indication of anything disabled.
Thx

 

[mvorous]

Tried this...

Option Compare Database
Private Sub cmdMakeTxtInvisible_Click()
Me.Text62.Visible = False
Me.Text62.Visible = No
Me.Text62.Visible = 0
End Sub

Thx

 

[mvorous]

Nothing "Missing" as posted

 

[pbaldy]

Is the database in a trusted location?

 

[mvorous]

Oh boy, how do I find out plz?
Thx

 

[mvorous]

I just quickly created a new DB with a few new fields in a new table, the code worked as it should. Here is the difference in the other situation,
The Tables are all imported as I need it to be a Front-end/Back-end relationship.
Does this help?
Thx

 

[RuralGuy]

Oh boy, how do I find out plz?
Thx

This link may help here: http://www.btabdevelopment.com/main/QuickTutorials/A2K7Howtoenablecodeandmacros/tabid/57/Default.aspx

 

[pbaldy]

Oh boy, how do I find out plz?
Thx

Did you read the link?

 

[Banana]

If a new DB worked, then it may be due to a corruption. Just re-do the import and see if it work still.

 

[mvorous]

Yes, that was it. A non-secure or rather non-trusted issue, thank you very much.

 

[mvorous]

Problem solved, thank you all very much, exp. pbaldy & RuralGuy(http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx). It was a non-trusted issue.
Thx all...

 

[RuralGuy]

Just glad we could help.