H habbabub Registered User. Local time Today, 15:14 Joined Jan 24, 2008 Messages 73 Sep 12, 2008 #1 Hi there, how can i manually insert data from a text box into a table using vb? i assume it involes the "insert" command?
Hi there, how can i manually insert data from a text box into a table using vb? i assume it involes the "insert" command?
pbaldy Wino Moderator Staff member Local time Today, 15:14 Joined Aug 30, 2003 Messages 36,272 Sep 12, 2008 #2 Two ways offhand, either executing SQL ("INSERT INTO..."), or using the AddNew method of an ADO or DAO recordset.
Two ways offhand, either executing SQL ("INSERT INTO..."), or using the AddNew method of an ADO or DAO recordset.
H habbabub Registered User. Local time Today, 15:14 Joined Jan 24, 2008 Messages 73 Sep 12, 2008 #3 how can that be done? do you have an example of useing that method? i have tryed a = "insert id ...." a.requery but thats me guessing!
how can that be done? do you have an example of useing that method? i have tryed a = "insert id ...." a.requery but thats me guessing!
pbaldy Wino Moderator Staff member Local time Today, 15:14 Joined Aug 30, 2003 Messages 36,272 Sep 12, 2008 #4 Generally, a = "insert id ...." CurrentDb.Execute a Look in Help for the proper syntax of an append query, and at the Execute method.
Generally, a = "insert id ...." CurrentDb.Execute a Look in Help for the proper syntax of an append query, and at the Execute method.
