Simple problem with setfocus in forms....

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi

I have been coding these things for years and have never
come across this. I have a simple data entry form with a
number of fields - I have a field on the form called
[ApplicantSurname] and want the cursor to move there on
load or activiation. Like I say, don't it many times
before but whatever I do, access is generating the
following error:

"The expression On Load you entered as the event property
setting produced the following error: A problem occurred
while Microsoft Access was communicating with the OLE
server or Active X control."

I've checked everything and things seem to be okay but I
can't figure the problem. I have tried using other field
names and checked spellings, etc, but to no avail, I
still get the same error but then the form opens and puts
the cursor in the first field on the form.

Any advice, gratefully received. Thank you in advance
for any responses.

Peter
 
In my experience, this usually indicates corruption. You can usually fix it
by creating a new, empty MDB and importing everything from the old one. If
that doesn't work, you can try decompiling.

I had this problem frequently in Access 2000, much less so in Access 2002 or
Access 2003. If you're using Access 2000, make sure you have all the service
releases and patches installed.
 
Thank you Brendan, the import into an empty db fixed it.
-----Original Message-----

In my experience, this usually indicates corruption. You can usually fix it
by creating a new, empty MDB and importing everything from the old one. If
that doesn't work, you can try decompiling.

I had this problem frequently in Access 2000, much less so in Access 2002 or
Access 2003. If you're using Access 2000, make sure you have all the service
releases and patches installed.

--
Brendan Reynolds (MVP)


Hi

I have been coding these things for years and have never
come across this. I have a simple data entry form with a
number of fields - I have a field on the form called
[ApplicantSurname] and want the cursor to move there on
load or activiation. Like I say, don't it many times
before but whatever I do, access is generating the
following error:

"The expression On Load you entered as the event property
setting produced the following error: A problem occurred
while Microsoft Access was communicating with the OLE
server or Active X control."

I've checked everything and things seem to be okay but I
can't figure the problem. I have tried using other field
names and checked spellings, etc, but to no avail, I
still get the same error but then the form opens and puts
the cursor in the first field on the form.

Any advice, gratefully received. Thank you in advance
for any responses.

Peter
Click to expand...


.
Click to expand...
 
Back
Top