When you turn off the warnings nothing triggers an error. It just fails silently. You could use VBA code to trap errors and leave the warnings on. See my respond in msg # 117742.
---In MS_Access_Professionals@yahoogroups.com, <no_reply@yahoogroups.com> wrote :
Hi..
I create an append query to add data from a form to a table. I use setwarning=false to hide the warning message. But I noticed that if I key-in invalid data, the query will not save anything to the table.
What I want is how I can get an alert/message when there is an error. Just a simple message like "Error!! Data will not be transfer to table." will do. Doesn't matter what ever the reason is.
Thank you in advance for any respond.
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPONSORED LINKS
.
__,_._,___
Tidak ada komentar:
Posting Komentar