Dose anyone have any coding that would check a database, check to see if the SSN is there, if it is then update the information with the new information. And also check to see if the SSN is not there to add the information, or if specified to delete that SSN completly. If so could you please help me.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating, Adding and Deleting
- Thread starter Shirley
- Start date
Hmmm.<br>
<br>
What's an SSN? (probably a stupid question)<br>
<br>
Mike<br>
<p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href= Cargill's Corporate Web Site</a><br>
<br>
What's an SSN? (probably a stupid question)<br>
<br>
Mike<br>
<p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href= Cargill's Corporate Web Site</a><br>
- Thread starter
- #3
tusconpapa
MIS
Shirley, I have some tested code that might be your answer<br>
Long reply @12/28 7:00 AM est.. Xmas is early this year !
Long reply @12/28 7:00 AM est.. Xmas is early this year !
tusconpapa
MIS
P.S. Send Email Address <A HREF="mailto:Coconus@his.com">Coconus@his.com</A>
Shirley,<br>
<br>
That's quite a wide question. I'm going to echo Tusconpapa here and invite you to continue this discussion via email.<br>
<br>
Drop me a note with some more details of what you're trying to do (what database, what version of VB, do you have an existing system - all that stuff) and I'm sure Tusconpapa and I can get you going.<br>
<br>
Obviously we'll post any technical stuff coming out of this to tek-tips.<br>
<br>
Regards<br>
<br>
Mike <p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href= Cargill's Corporate Web Site</a><br>
<br>
That's quite a wide question. I'm going to echo Tusconpapa here and invite you to continue this discussion via email.<br>
<br>
Drop me a note with some more details of what you're trying to do (what database, what version of VB, do you have an existing system - all that stuff) and I'm sure Tusconpapa and I can get you going.<br>
<br>
Obviously we'll post any technical stuff coming out of this to tek-tips.<br>
<br>
Regards<br>
<br>
Mike <p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href= Cargill's Corporate Web Site</a><br>
- Thread starter
- #7
You have an idea of the VB code that will check what is already in the database and add new one and update old one with the new information, and also delete those records that needs to be deleted. If so please email me at <A HREF="mailto:shirleysanders@sbcusd.k12.ca.us">shirleysanders@sbcusd.k12.ca.us</A>. I will greatly appreciate your help. I tried to e-mail but it set the server is not set up or something like that. So just e-mail me.
tusconpapa
MIS
Shirley, I tried to Email but received **Invalid Address **<br>
Inform the net-work supervisor that your address DOESN'T<br>
work. THEN send the details requested by Mike (this time <br>
the details are IMPORTANT !!) to either Mike at his address OR ME at <A HREF="mailto:Coconus@his.com">Coconus@his.com</A> the answer to your question(s) willbe a lot more than one line on one reply.<br>
T.<br>
Inform the net-work supervisor that your address DOESN'T<br>
work. THEN send the details requested by Mike (this time <br>
the details are IMPORTANT !!) to either Mike at his address OR ME at <A HREF="mailto:Coconus@his.com">Coconus@his.com</A> the answer to your question(s) willbe a lot more than one line on one reply.<br>
T.<br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question