Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error 3075
Probably either fldVintage or fldSize is a text field. If so, then surround the value with quotes, like fldVintage = '1953' e.g. strsql = "select fldsize, fldtype, fldvintage, unitcost from qryCheckCost where fldvintage='" & Me.fldVintage & "' AND fldSize = " & Me.fldSize I...- mcneillrh
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using a temporary ADO recordset as recordsource for a report
The other way around this which might be faster is to create a temporary table with one field (call it whatever you want), go through the ADO recordset and add a blank record for each record in the ADO recordset. Then, set the report recordsource to the name of this table. (in other words, you...- mcneillrh
- Post #10
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using a temporary ADO recordset as recordsource for a report
I'm having the exact same problem. Did you find a solution to this ADO/report problem?- mcneillrh
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
