Search results

Hmmmm Never condidered that. Thank you! It never dawned on me to try that. I've always used a series of code in the "Afterupdate" of the form <with a Command Button with the label "Process"> to check of isnull values before the values were to be saved, but never thought of using Beforeupdate...

Thank you. Found another path Thanks very much for the post :) Actually I gave that a try earlier and what happens is that the tab or click occurs immediately following the msgbox. What I discovered, however, was cancel=true to my delight. by using the msgbox then in the next line below...

I'm wondering if someone can assist me. When someone neglects to enter information into a field, I would like my form to message that person that they need to enter information into that field and bring the person back to that field until information has been entered. I know that I can use...

Hi all, I did figure out how to get my table of errors, however, the actual message I'm trying to find isn't on the list. I'm looking to disable just the message I receive when I run an action query append through code that states "Microsoft Access Can't append all records....# not appended...

Pat, I need to revise my last question. I was able to print out the table, but now I have another question on the same subject. One of my goals was to be able to customize an error message, but the one I'm looking for doesn't appear on the code list. Are there other codes? The one I'm...

Thanks for answering my question. Actually I did use the exact same code but to no avail. I think I might be missing a step. This is what I did. I used the code that you demonstrated and pasted it into a new module. Then I ran it through the debug option and the error message returns...

As a somewhat new member of the VBA arena I am having problems producing the error list table that the Access Help offers to be able to identify error codes and their descriptions. I copy and paste, per the help, and continue to receive a "User Defined Type - Not Defined" message. I have...