Search results

I think I got it I changed the statement from: Dim rs AS DAO.Recordset to Dim rs AS Object This took care of the problem

tried it, Access hates DAO Scott, I decided that the user will hae to give just a little on this project. So I incorporated the form and the code into the project. When testing this, it stops at the line: Dim rs AS DAO.Recordset Access 2000 apparently hates DAO. How can I recode this or...

check for existing record Scott, Thanks for the reply. This would work except I am needing for the user to be able to enter the phone number in the phone number field in the form, then check for an existing record and bring up the record if it exists. If it doesn't then allow the user to add...

I am working on an Access 2000 database in which I need to be able to verify that a record exists when the user enters the phone number (this is the first field and the Key). If it does exist, I need the record to be the current record for the user to view. If it doesn't exist I need it to...

When I select the first option button and check the properties I have no option of "on click". If I select the page tab there is one. I need to enter the coding on the option button, correct?

I have a main form that contains an option box that has eight options. There are 9 page tabs that are subforms within this main form. The options are labled to correspond to the 9 page tabs in the subform. My goal is to allow the user to select one of the options and the corresponding page be...

I have a Main form that includes a couple of subforms. When the user enters a specific key number I would like the description of the key to automatically be filled in. I have a separate table created that holds the information of the key number and the description to the specific key number...