compiler error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This about an existing database to which I was asked to add a form.
I just tried to compile an Access2000 database (on Access2002), and a form I
did not work on, came up with an variable not defined error, on a textbox
that was programmatically set to have its Locked property set to Yes.
Another person (the database's original creator) and I could not see anything
different about that control, or the way the name of the textbox was typed,
that would cause this. What else should we look at? Thanks in advance.
 
Hi.
came up with an variable not defined error, on a textbox
that was programmatically set to have its Locked property set to Yes.
Click to expand...

The property should be set to True, a legitimate Boolean value, not Yes.
Try the following syntax:

Me!txtApprovedBy.Locked = True

.... where txtApprovedBy is the name of the text box that should be locked.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
 
Back
Top