Prevent Duplicate Products or Services in an Order in Microsoft Access with a Composite Key

[@joncue0304]

In the orderdetail design view, you can also just select multiple fields and select primary key from the ribbon. It then adds the new index value for you.

[@deniskakendo910]

How do you run no duplicates in a query criteria?

[@nicemedia1]

Hi Mr Richard Rost I'm looking for a method to sum the quantity of duplicate items instead of picking new record in my Order form . I will be great full if show me. thanks .

[@599CD]

That's on my list

[@sujayghosh3540]

Sir can you please make a video on access (query) that between 80 marks to 90 marks. Please I need your help.

[@599CD]

I have no idea what that means.

[@mjmbferrer9364]

Sir I would like to ask if it is possible in a Query to hide the duplicate values

[@599CD]

Aggregate query: 599cd.com/aggregate

[@stephenbeswick2163]

Great video again steve

[@599CD]

Thanks again!

[@niktsol]

What if someone wants to use composite key and traps errors on Form OnError event? I believe that this option might no be good for complex applications with multiple tables. What is your opinion about that?

[@599CD]

Sure... if it works for you, gopher it. :)

[@599CD]

It's funny that you mention this because it's actually on my list for an upcoming video. :)

[@niktsol]

@@599CD So i guessed one of your upcoming videos. Look, to be honest, from my point of view i believe that this stands for simple tasks , for example if i have one field with unique values in my table, then i can manipulate the onError event in form. But if for example, my table has 2 or 3 or 4 fields that have to be unique then if the OnError event rises, i have to perform several Dlookups in the form's OnError event sub to see which of the unique value fields have the duplicate values so user gets an appropriate prompt . In this case this might causes delays in response (index maintenance plus dlookups if error) in case of large amount of data especially in a multi user environment I am looking forward for this video. Thanks again!!!

[@thomaswesonga3868]

How do use codes to prevent Dublicates

[@599CD]

Huh?

[@santdnyaneshwar9920]

Sir, I am getting issue in Invoice Number field... I when I am using AutoNumber field format... When if I cancel after generates invoice number (using AutoNumber) then that generated invoice number skipped and there getting gap in INV Number.... So what field/ function should be used? Sir, nobody on KZbin can give solution on it. I hope definitely you will solve it. So Sir, please make a example video on this issue on priority please.. Thanks!

[@599CD]

AutoNumbers are not for YOU. They're for Access to make relationships. It doesn't matter if there is a gap in them. If you want sequential numbers, DON'T use AutoNumbers. 599cd.com/Counter

[@dbdata9836]

10

[@599CD]

out of....??? :)