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.
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 .
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 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!!!
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 RUclips 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!
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
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Great video again steve
Thanks again!
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.
How do use codes to prevent Dublicates
Huh?
How do you run no duplicates in a query criteria?
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 .
That's on my list
Sir I would like to ask if it is possible in a Query to hide the duplicate values
Aggregate query: 599cd.com/aggregate
Sir can you please make a video on access (query) that between 80 marks to 90 marks. Please I need your help.
I have no idea what that means.
10
out of....??? :)
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?
Sure... if it works for you, gopher it. :)
It's funny that you mention this because it's actually on my list for an upcoming video. :)
@@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!!!
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 RUclips 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!
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