Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vb access duplicate record

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VB Access duplicate record Message

VB Access duplicate record Message

ResolvedVersion 2003

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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.