Users Getting An Error Message When Trying To Submit A Form

  • Thread starter Thread starter R Tanner
  • Start date Start date
R

R Tanner

Hi,

I have a database application which is distributed to about 60
people. This morning, 3 people were trying to submit the same form in
their own front ends and they all got the same generic error:

The expression On Click you entered as the event property setting
produced the following error: The opreation on the I object failed.

When the user hits 'OK', the event code does a number of things,
including sending an email, deleting null records from the database
table, etc. Is there any way I can identify specifically what this
error message resulted from?
 
I this Access 2003 and have you loaded the SP3 and the hotfixes available at
Microsoft?
 
I this Access 2003 and have you loaded the SP3 and the hotfixes available at
Microsoft?
Click to expand...

No, this is access 2007. I have service pack 2. What are 'hotfixes'?
Is it really necessary to install service pack 3? And if so, only on
my machine, or on all of my users' machines as well...
 
I this Access 2003 and have you loaded the SP3 and the hotfixes available at
Microsoft?
Click to expand...

The other thing is it does not happen every time and it doesn't happen
to all users. I go over to their desk and try to enter the ticket and
I don't get the error message.

Something else you might need to know is I am using the windows API to
hide the access database application window so the user only sees the
form. I don't think the problem originates from that though...
 
The reason I asked if it was 2003 is because 03 would cause problems similar
to what you described. It sounds like a combo box problem, but on 07 I'm not
sure. Re-post and maybe an 07 expert can help. Sorry
 
The reason I asked if it was 2003 is because 03 would cause problems similar
to what you described. It sounds like a combo box problem, but on 07 I'm not
sure. Re-post and maybe an 07 expert can help. Sorry
Click to expand...

I think it is fine. I think [although I'm not sure] the error
originated from a public function which cycles through my subform to
make sure certain data is entered. I have removed the reference to the
public function in the originating event code and it appears to be
working fine.
 
Back
Top