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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ODBC.. call failed on parameter, but works in criteria field
I've set up the DNS in ODBC.. that's how you get to the database. The problem is that while I can set up a parameter in the criteria field for a numeric data type, the 3 character text field errors out if I try to use a parameter. I can enter the text in the criteria box (including a wild...- TheKval
- Post #3
- Forum: Microsoft: Access Other topics
-
ODBC.. call failed on parameter, but works in criteria field
Hopefully somebody can show me the errors of my ways!! I'm using Access 2000 linkd to Macola data files using Pervasive 2000 database manager. The records I'm trying to pull have a 3-character text field named Ship_Via_Cd. If I enter a value in the criteria field on the query form, i.e., D...- TheKval
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
