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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple table insertion question

Status
Not open for further replies.
Netooi

Netooi

Programmer
May 15, 2002
29
0
0
US
I have a string called "MyStr" that has a name in it.
I want to be able to insert that name into a table in my Access database called tblData that has a field called Name.
Could someone hook me up with the VB to do this?
Thanks,
Netooi
 
Sort by date Sort by votes
After you have connect to the database, use this:

RS.AddNew
RS.fields("Name").value = MyStr
RS.update



 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
TWO table with the same classname 1
Replies
3
Views
89
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
get data from iframe and table
Replies
0
Views
34
sal21
sal21
sal21
  • Locked
  • Question
WHY! ie dont show the table of result 1
Replies
8
Views
73
sal21
sal21
sal21
  • Locked
  • Question
DRAG AND DROP question. 1
Replies
5
Views
81
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
how to write value in a word table
Replies
5
Views
75
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top