I have a problem getting non-numeric data from a filtered recordset.
Iím running MS Access 2003, this is a front-end, back-end type application, and the entire connection is done with VBA and ADO.
I am attempting to have people enter a serial number into the control txtConID on the form, and use that serial number to filter the recordset.
with conConnect being the currently open connection to the data source.
The code works fine and gives me all the correct records...so long as the serial number contains no letters. Numbers and symbols are fine, but the moment I try to put in a letter, I get the error message:
ďArguments are of the wrong type, are out of acceptable range, or are in conflict with one another.Ē
I have checked, and not only is the field set to text, I have alpha-numeric data in most of the records, so I know itís not that Iím trying to look at letters in a numeric field.
I've been bashing my brain out over this one for a week now. It seems like such a little error, but it's messing up my entire search feature.