-
Mar 22nd, 2005, 02:05 PM
#1
Thread Starter
Addicted Member
Prevent duplicates using a data control
Is there a way to prevent a duplicate record from being saved using the MS Data control? If not is it possible to do it using ADODB and how?
The only way I've seen is using DAO and im not really sure how to do that.
-----MY SITES-----
BayRidgeNights.Com - NYC Nightlife Forums
Fight Communism - Rate Posts!
-
Mar 22nd, 2005, 02:24 PM
#2
Re: Prevent duplicates using a data control
Since you are using the data control you will run into many issues using this bound control.
I suggest using ADO. Here is a good ADO Tutorial.
If your getting duplicates then you need to set properties in your table design to dis-allow this. Then you can error trap.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it!
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
-
Mar 22nd, 2005, 02:26 PM
#3
Thread Starter
Addicted Member
Re: Prevent duplicates using a data control
Originally Posted by RobDog888
If your getting duplicates then you need to set properties in your table design to dis-allow this. Then you can error trap.
ill try that. thanks
-----MY SITES-----
BayRidgeNights.Com - NYC Nightlife Forums
Fight Communism - Rate Posts!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|