weird error message

  • Thread starter Thread starter CA
  • Start date Start date
C

CA

have opened an access 2003 db in access 2007...opens fine, but when adding
records I am getting an error as follows:

Microsoft Office Access

-2147352567 Method ‘Nz’ of object ‘_Application’ Failed

When I perform the exact same actions on the dB in 2003, I do not get ANY
error...I am wondering if the NZ method in conjuction with data on an sql
server is invalid...all fields involved in the equation are number fields
(as controls on the form, or fields from a table)...

when I debug the code and try to list the value of one of the fields (that
has been defined on a form as numeric) in the IMMEDIATE window, I get a type
mismatch error...

again, I have run the exact same dB in accesss 2003 without incident...no
'method nz invalid', no type mismatch....I am entering the exact same data
(after deleting the records) the exact same way...no errors in 2003,
confusing errors in 2007...

I feel as if this particular dB is getting corrupted when
being used in Access 2007...I have been unable to convert this dB to
2007....the error message is that the dB is already opened exclusively by
another user...which is me...the dB size is growing incrementally during
usage; again, I'm wondering if there is some corruption going on...

fyi this dB uses both local access tables and sql server tables via ODBC.
any
suggestions would be GREATLY appreciated. TIA
 
Yes, Jeff...I've checked the references and made sure I had all necessary
references checked.

CA
 
Hi Jeff,

Yes, I did check that...no references were missing...I did fix my
problem...what I learned was that the problem was limited to a text box on a
form that referenced a text box on a subform...I made sure that all my
numeric SQL table fields, and unbounded text boxes, were defaulted to either
1 or 0 (as appropriate), then I created a new text box and removed the text
box that had been causing the problem...I removed the NZ() syntax from the
event code, and the code ran fine...every step prior to this action resulted
in an error...it presented as if there was corruption in the text box, but
only in Access 2007, not Access 2003...I'm not sure I totally understand why
this error occurred, but I am happy to have fixed it.

thank you so much for your input

CA
 
Back
Top