• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 147
  • Last Modified:

VB and Access

I need to know what code I need to put in that allows the user to enter a new name and phone (the key) on the main form and have the new name and phone number be added to each additional Access table that is used when the user progresses to other forms in the vb program.  I am using ado data controls in the program.

Let me know if I need to go into more detail.
0
jclaire
Asked:
jclaire
1 Solution
 
Richie_SimonettiIT OperationsCommented:
You could save it in global variables and everytime you add, modify a record, add those values in corresponding fields.
Also, avoid usege of data control.
0
 
Mahdi MansourDesign Monitoring & Evaluation ManagerCommented:
just define a new recorde set let say Tmp, and set it to the spicific table and then :

tmp.addnew
tmp("name")=txtname.text
tmp("Phone")=phone.text
tmp.update

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now