PDA

View Full Version : which software?


LisaMane
05-06-2004, 02:29 AM
which software can do this?

I get new names or emails and put them into a database. the database program tells me automatically if the name or email already exists

Erik
05-06-2004, 12:16 PM
I don't know anything specifically off hand. But as far as I know if you set a key field in the database to be associated with either name or email then the database will prevent you from using that twice.

So as I understand it you basically just ant a program that will take information from some source and put it into a database automatically? Or are you just looking for a database to hold the information that you will enter manually?

classicsoftware
05-12-2004, 11:37 PM
You will have to do this manually in either FoxPro or Access or another pc database. You will have to write a program or a script within the databse to do this. You need to provide a whole lot more detail.

Paul Komski
05-14-2004, 07:48 PM
You can use a simple table in Access and just set the name and email fields in Design Viewso that they are "Indexed" and "With no Duplicates". Any attempt thereafter to enter a duplicate value will then generate an error message and not allow the entry. Fox Pro would be similar but more elaborate.

Open Office and MySQL are free and would also be able to do this - but not nearly so easy to use.

You could also use a macro in excel (or word) but a pretty messy approach IMHO.

LisaMane
05-14-2004, 07:53 PM
I wish I could but unfortunatly I tried access and found out I was an access klutz!

After just upgrading to office 2003 Im still catching up with the differnces in Outlook.

Do you know of any templates that do this?

thanks

classicsoftware
05-14-2004, 11:53 PM
What OS do you have?

How many names are involved?

How often do you add them?

What do you do with them once you have them?

What is the purpose of this application?

Paul Komski
05-15-2004, 04:19 AM
I tried access and found out I was an access klutz
Attached is a very simple Access 2000 Database. It has an autoexec macro that opens the only table maximised at startup and contains just four fields. The indexed email and name fields and two more just for starters.

There's no need to get more complicated than this (or use queries and forms and reports) unless you want to. To edit the table names etc just open the table in Design view by clicking the blue triangular Design View icon.

Perhaps that's not what you want but it took less than a minute to create.