Re: [MS_AccessPros] Preventing data entry error

 

Phucon-

You can trap that error in the Form Error event and substitute you're own, more friendly, message.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 12, 2014, at 9:22 PM, <saigonf7q5@yahoo.com> <saigonf7q5@yahoo.com> wrote:

Thank you very much Mr. Viescas. After making the ProjectID/ emplID as compound key then the code's no longer needed.  Now when I entered a duplicated emplID, the default error will pop up,  but how do I create a custom, friendlier message like the one that I did in my previous post?

Thanks

Phucon

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (4)

Visit Your Group

• New Members 6

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___