Hi Jim,
To my knowledge only those two variables need manual modificaction.
The Microsoft Knowledge Base Article - 247868 "HOWTO: Manufacture an ADO Recordset Based on Another Recordset" shows an example, similar to the example i posted, but they fail to explain why those variables are not...
Here is a sample code(rstSource = Source Recordset, rstTarget = Target Recordset , manually created).
For Each objField In rstSource.fields
rstTarget.fields.Append objField.Name, objField.Type, objField.DefinedSize, objField.Attributes...
When Creating the recordset "on the fly" using the Fields.append method , it will set up everything except for two properties. Precision and Numericscale. These have to be entered seperately right after appending the Field.
This can be a problem in the case of working with adNumeric fields. You...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.