Search results

I've got 2003 and the Format of the textbox does not include text as an option. The problem is that I am having to enter an ID number (digits only) to match a table that has that number formatted as text. I get a data mismatch error when I try to run a query/VBA. Any suggestions?

I have a form that has Start Date, End date, Employee ID and a "password". I have a table that has each ID and "password". How can I get the macro to run IF and only IF the Employee ID and "password" entered are correct (and not just both ON the table, but as a pair). I would prefer the simplest...

I have multiple queries, one for each auditor. Is is possible to password protect each query so that each auditor could only view their own query? I will have to hide the thingy (yup, I have no idea of the technical name or I would have used it.) and have them use a switchboard and macros to run...

I have a make table query whose destination is another database. It was working until I was asked to put a password on the destination database. I adjusted the make table query to include the password. (It actually asked for it the first time I went into the setup.) Now when I try to run the...