Visual Basic Forum for Visual Basic Programmers VB - Interactive Visual Basic Forum .NET Programming & Help

Mitesh2004 · Freshman Joined: 26 Jan 2004 Posts: 43

Hi,

I am using ADO to connect to my database. I have a form that allows the users to enter in details of events into a database. I want to make it so that the same EventName is not duplicated in any of the records.

I am guessing that i will have to do a search in my database to make sure that none of the other events have the same EventName. Am i right? If so, how would I do this sort of search in the database?

Your help will be greatly appreciated, Cheers!

Avis · Posted: Feb 17th, 2004 07:58 AM Post subject:

Which database are you using ? If you're using MS Access then just do the following:

1. Open the database in MS Access.
2. Open the table in Design View.
3. Select the Field you want to be unique..
4. After selecting the field check the Indexed property and set it to Yes (No Duplicates).
5. Save and Close!

This will solve your problem.

Thanks!
_________________
Code Snippets, Tutorials, Utilities, Controls

Low cost Web Hosting
Hosting starts at as low as $4 per year!

Always follow posting guidelines
Put your VB code in [vb ] your code [ /vb] tags!

Mitesh2004 · Freshman Joined: 26 Jan 2004 Posts: 43

Thanks for that Avis,

I have just tried that and it works from the database point of view. However, when a record of the same EventName as an existing record is attempted to be added, my VB program crashes with an error.

How do i prevent this from happening? Is there any code that i can write for when the 'Add' button is clicked?

Avis · Posted: Feb 17th, 2004 08:26 AM Post subject:

Hi!

Use this just replace the error number you get with the error number in this one:

Mitesh2004 · Freshman Joined: 26 Jan 2004 Posts: 43

Thanks for this Avis,

But i have been told that it is bad coding practice to use 'GoTo'. Am i correct? or do you think it is ok to use GoTo in this case?

Avis · Posted: Feb 17th, 2004 08:34 AM Post subject:

Its okay to use Goto in this case as there's no other alternative. On the other hand you can also use On Error Resume Next ...but i don't know then how to trap the errors. This will only keep on ignoring the errors and you won't get any message.

But On Error Goto you can trap errors and control the behaviour and other stuff as we're doing in here. Using too many Goto's in a program is a bad practice but one Goto does'nt hurts! :p
_________________
Code Snippets, Tutorials, Utilities, Controls

Low cost Web Hosting
Hosting starts at as low as $4 per year!

Always follow posting guidelines
Put your VB code in [vb ] your code [ /vb] tags!