98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VB Access duplicate record Message
VB Access duplicate record Message
Resolved · Low Priority · Version 2003
Tue 11 Nov 2008, 16:20Delegate Clare said...
Clare has attended:
Access Advanced course
Access VBA course
VB Access duplicate record Message
Hi
I am trying to write code that recognises duplicates in a record and pops up with a MsgBox to let you know that it has already been added..
I have written some myself but can't get anywhere!
The table which hold the data is called tblRecruitmentData and the field is PostCode. The field in the form is called txtPostCode.
Can you help me at all?
Thanks
Clare
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Display current date & time in column of any widthThe worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ### |
