Recent content by malex0012

Thank you very much spikepl. You've been most helpful to a newbie in ACCESS.

Thank you spikepl for the reply. I need to isolate the query where the error is originating from. Currently, the error handler code is this: Error_Handler: MsgBox Err.Number & " " & Err.Description Can I update it so it will display the query name and table name where the error message is...

I would like to add that the macro I was running does not have any calculations in it. It simply inserts and updates SQL server tables. I was browsing some of the queries posted on the forum for similar issues and I found that Overflow error results from mathematical calculation errors. So my...

I have a MS ACCESS macro that executes over 30 queries which updates a specific database table on the MS SQL server. The macro was developed by somebody who is no longer with the company. It has been running smoothly for several months now, but today it spit out an error message "6 Overflow". I...

Hello Everyone, I'm a new user to ACCESS database and inherited forms to run and update our company database. It has been running smoothly for several months now, but all of a sudden spit an error that I do not recognize. So I went snooping around looking for help and I found this site...