X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Dlookup To Prevent Duplicate Entries In two fields in A Subform, Any Version    
post Jul 8 2017, 06:21 AM

Posts: 103
Joined: 8-July 17

Thanks all for posting this example from 2015 it'help me too but how can I use this code to prevent duplicate for two txt fields and one date field combined together ??(AccountNo text filed, DocumentName text field and DocumentDate date field) by the way my Primary key is: DocID.

Best Regards,

Al Hakeem1977
Go to the top of the page
post Jul 8 2017, 10:21 AM

UA Admin
Posts: 33,488
Joined: 20-June 02
From: Newcastle, WA


First. Welcome to UtterAccess.

Second. It is seldom a good idea to tag a new, different question onto an older discussion. Most people will never even see it. (Being on the admin team, part of my job is to review new posts, but otherwise I would not see it either.)

That said, what you need to do is create a unique index on these three fields in your table.

My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Visit My Blog on Facebook
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    20th September 2018 - 07:10 PM