Hello, I have som problem with a temporary recordset I'm creating. I've searched quite a lot and I understand that it is something wrong with my code but I haven't seen a straightforward answer to my problem. Here is the code:
The values for the two rows are unique
Thanks for your considerationPHP Code:With rs_ar
.AddNew
.Fields("X") = Prognosar_t_1
.Fields("Y") = P_t_1_string!P_t_1
.Update
.AddNew
.Fields("X") = Prognosar_t_2
.Fields("Y") = P_t_2_string!P_t_2
.Update
End With
Last edited by Luonas; 03-09-2012 at 10:25 AM. Reason: Solved
Your code above works fine form me in both ADO and DAO inserting into an access database
Try this.....
Please Login or Register to view this content.
How are you testing the values stored in the recordset?
Good luck.
Thanks for the replys, I began suspecting as much. I stored the values in a temporary recordset (so when I try to print them in a table it does work).
The way I test the values is by printing them in an word report-table (I'm doing all of this from word) so the problem is probably this part (because as far as I know a temporary recordset isn't any different from a more permanent one?)
Im using this function to output the values:
PHP Code:txt = rs_ar.GetString(adClipString, 2, ColumnDelimeter:=vbTab, RowDelimeter:=vbCrLf, NullExpr:="<null>")
And you get two rows in your output that are both the same?
Nope, I just get last added row as an ouput. And unfortunently
And that was exactly what was needed. Thanks! A simple solution but I was bogged down in my thinking.Originally Posted by OnErrorGoto0
Glad to help. Please don't forget to mark the thread solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks