Isn't so in my 1-st code example?
Up to line 10 the fields are appended,
Then in line 10 the recordset is opened and only then the field values are added from line 16.
janeks
Last Activity: Jan 24 '08, 02:18 PM
Joined: Jan 4 '08
Location:
-
That is not only yes/no (boolean) fields (the same problem persists with f.ex. numeric fields if there is no boolean field) and the case in link was about query, but in this case it in code created recordset....Leave a comment:
-
It should be not a problem.
When I am testing what I appended by using Debug.Print or MsgBox, then all works fine.
Interesting behaviour I observer when I clicked in check box of boolean field, than the value in size field suddenly appears in place of #Error....Leave a comment:
-
Values shown only in string fields of forms with fabricated ADO recordset
I faced with problem in the subject.
I need to dinamicaly create the recordset and show the results in a small subform.
To construct and test the form I made following test code for form load event:
...Code:Private Sub Form_Load() Dim rst As New ADODB.Recordset With rst With .fields .Append "FullName", adLongVarChar, 260 .Append
No activity results to display
Leave a comment: