Search results

I want to view a dynaset of a tbl recordset. However in the code below I get a run time 3011 .. "make sure the object exists and that you spelled….etc" Hours of varifing spelling is correct I am stumped. thanks in advance '_______ Private Sub cmd_Go_Click() ‘ dialog frm with combo ' get...

Advice I could use, my problem, I am trying to clear variables Dimensioned as Date My module code is updating a access db from another access db. I have many date fields that are sometimes empty in the From db. However when the update is done I am getting erroneous data in the To db in the...

In the following code snap shot I am trying to put the Date data in the variable HitD. It works fine when there is date data in the field, but does not work when the field in null and I receive a type mismatch error. Dim HitD As Date Form_frmMain.HitDate.SetFocus HitD =...

My company just switched from Access 97 to Access 2003. In the following code of one db is a task that opens a new instance of access, opens another db, adds a recordset and then closes the new instance db. This worked fine in Access 97 but in Access 2003 the new instance does not close...

I have a db open and the form in which data is entered, I added a button to accomplish the following: 1. open another database instance 2. addnew record set 3. add data to field in new recordset 4. update & close the other database instance I am getting the error that the Jet can not find the...

Please Help How do I get user input from a combo box pick into a dimensioned variable. My problem is; in my code for a On_Click event I want a combo box to become visible, (code) stop and allow the user to pick from the combo, fill the variable with the pick data then move on to the next lines...