Pman12
Last Activity: Oct 11 '07, 11:22 PM
Joined: Oct 10 '07
Location:
-
Thanks! That did it. -
It happens at the second insert when I am using the variable 'id', which contains the first field of the recordset, in the insert statement....Leave a comment:
-
Inserting recordset value into table
Below is the vba code I am working with. When it gets to the insert part I get an "Enter parameter value" dialog box with the value of the variable "id" above the cursor. I have to type in that value so it is inserted in the table otherwise it insert a blank. What am I doing wrong?
Dim rs As ADODB.Recordset
Dim cmd As ADODB.Command
Dim query As String
Dim id As String
Dim begin_date...
No activity results to display
Leave a comment: