Solved Determine AllowBypassKey is On or Off

[Kha]

Hi, I have a button to set AllowBypassKey to False,
I am trying to type a code to determine if AllowBypassKey is On or Off, but I got error message
please help me to make it works

 

[theDBguy]

but I got error message

What was the error message?

 

[Gasman]

And you cannot say what that error message is?
Would that be because to set currentdb to a variant?
Why not Dim your variables correctly?

 

[MajP]

You need to test for the existence of the property. The error is that the property does not exist.

 

[isladogs]

Error 3270 - property not found
You need to create the property before you can use it

Microsoft Access tips: DAO Programming Code Examples

VBA code using the DAO library in Microsoft Access.

allenbrowne.com

 

[Kha]

What was the error message?

 

[Kha]

 

[Kha]

 

[theDBguy]

View attachment 103544

As the others have said, that property is not automatically created by Access. So, when you check for it, it may not be there yet. Just add an error handler to your code. If you get that error, then you know the setting is not set.

 

[Kha]

As the others have said, that property is not automatically created by Access. So, when you check for it, it may not be there yet. Just add an error handler to your code. If you get that error, then you know the setting is not set.

 

[bastanu]

a string (txtbox) does not have a backcolor property....

 

[Kha]

a string (txtbox) does not have a backcolor property....

 

[theDBguy]

View attachment 103547

With all due respect, using Resume Next does not really handle the error, does it?

When you get an error, you can check the error number and then react accordingly.

Just my 2 cents...

 

[Kha]

With all due respect, using Resume Next does not really handle the error, does it?

When you get an error, you can check the error number and then react accordingly.

Just my 2 cents...

 

[theDBguy]

View attachment 103549

What's the question? @bastanu already said, since txtbox was declared as a Property, it doesn't have a member called BackColor.

If you're trying to change the color of a textbox, then use Textbox or Control, instead of Property.

 

[Kha]

What's the question? @bastanu already said, since txtbox was declared as a Property, it doesn't have a member called BackColor.

If you're trying to change the color of a textbox, then use Textbox or Control, instead of Property.

Sorry, I do not understand can you give more hint please?

 

[theDBguy]

Sorry, I do not understand can you give more hint please?

You have this in your code.

Dim txtbox As Property

You can use either one of these instead.

Dim txtbox As Access.Textbox
or
Dim txtbox As Access.Control

However, you'll have to Set it first before you can change the BackColor property.
Is this function behind a Form? If so, you don't even need the Dim statements. You should be able to simply use.

Me.TextboxName.BackColor = vbRed

 

[Kha]

You have this in your code.

Dim txtbox As Property

You can use either one of these instead.

Dim txtbox As Access.Textbox
or
Dim txtbox As Access.Control

However, you'll have to Set it first before you can change the BackColor property.
Is this function behind a Form? If so, you don't even need the Dim statements. You should be able to simply use.

Me.TextboxName.BackColor = vbRed

 

[theDBguy]

View attachment 103551

Now, what is your question? Why can't you use words? Just curious...

The error message says you haven't defined the variable strErrMsg, because you haven't defined it yet before you used it.

 

[Kha]

Now, what is your question? Why can't you use words? Just curious...

The error message says you haven't defined the variable strErrMsg, because you haven't defined it yet before you used it.