I'm using a third party card-writer package called CardFive which comes bundled with Zebra card printers - it allows me to use ODBC to pull user name records from a table in an existing MSAccess 2002 database (.mdb). Cardfive can then merge this data to print onto plastic ID cards designed in its own interface.
At present I'm using a file dsn, with ODBC pointed to the .mdb.dsn file. This works okay - but I get the whole table (all records) appearing for printing. I want to restrict this to just a selection of records, based on a boolean field in the table. I think this is an ODBC issue, rather than a limitation of Cardfive which appears to just use whatever it sees in the data source field.
I could create a select query which generates the required recordset, but (here's the question) how do I get ODBC to look at that query (rather than the table)? Or is there some other better way to do list just the records I need, instead of the whole table?
I'm hoping this can be done without too much trouble or additional coding.
Not urgent, but any help would be appreciated.
Start Free Trial
