Triggering an OnClick in adp

  • Thread starter Thread starter Darrell Cyphers
  • Start date Start date
D

Darrell Cyphers

I have just begun to create a database in adp and have
successfully connected with the server and created tables.
Now, I have created a form for one of the tables which
includes an OnClick event attempting to execute code with
turns on or off the visible property for a text box based on
the value of the control clicked. I get a message on
clicking the control reading:
"VBA encountered a problem while attempting to access a
property or method. The problem may be one of the following:
*A reference is missing
*An Expression is misspelled
*Security in Access is set to High and Microsoft Jet 4.0 SP8
is not installed."
I have installed SP8 and still get this message. AND, I get
this message EVEN WITH A BREAK SET ON THE 1ST LINE OF CODE;
the message pops up before even hitting the break. Can
someone suggest an explanation?

Thanks!
Darrell
 
Here is the code, though, as I mentioned, I got the message
even before it hit a break set on the line naming the
procedure, and I got it even with all the code except
procedure name and "End Sub" commented out.

Anyway, I hope this helps:

Public Sub Employee_Click()
If Me!Employee.Value = -1 Then
Me!txtEESSN.Visible = True
Me!txtEESSN.Visible = False
End If
End Sub
 
I'd try two things.

First, check your references. In the VBA screen, click on Tools >
References. See if there are any marked as having a problem. Make sure
that the latest version of ADO is selected. Try deselecting and reselecting
your libraries.

Second, try changing Me! to Me. in each of your statements.
 
Back
Top