Search results

the varable projectID is being populated and retains the vaule becasue the dimensioning of the varable is: Public projectID As Long in a seprate module

___________reply Yes numeric projectID is dimensioned in a seprate module as: Public projectID As Long Project_ID is the field in the tbl_separationKeyInputs My goal is for the user to open/view a subset of tbl_separationKeyInputs for all records where Project_ID (keyIndexed) that match...

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...

Cleaning Date Variables-0 represents December 30, 1899 This is the work around that I came up with for this situation, pretty simple but thought maybe someone could benefit & for future ref. Dim StrucStartD As Date Form_frmMain.ToStrucDate.SetFocus If IsNull(Form_frmMain.ToStrucDate) Then...

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...

Thanks Ken - that did work, however....continuing ....now that I have either nothing or a data in the var HitD, when I try and upload to e new dataset, (in which I have no control over) I am getting a “Data type Conversion Error”

Ken, thanks for the quick reply, however Still the same problem, works fine when there is a date in the field, but when the field contains no data, I get a error Dim HitD As Date Form_frmMain.HitDate.SetFocus HitD = nz(Form_frmMain.HitDate.Text,"") any advice is much appreciated

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 =...

closing a db instance Thanks John, acc.Quit worked, acc.Close did not work for some reason.

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...

thanks....the following code works if anyone is interested: _______________________ 'now open the instance to the cost db and upload the data Dim acc As Access.Application Dim db As DAO.Database Dim strDbName As String Dim rst As DAO.Recordset strDbName =...

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...

lagbolt - your right, I should have said - I am incapable to do what I want to do. Unfortuantly I do not write code everyday, more like once a year. However I did try the acDialog and Hide method but still had problems. I have to finish up another project, but want to keep this post going and...

It is apparent that there is no way to pause code to allow user input in VBA like using a Input Box in VB. If I break the code manually and pick a selection from the combo and manually re- start the code it works perfectly. I am going to write an executable class module in VB and port it over...

Yes the client is not allowing the main form to be altered. This database is used to collect data of products at the factory floor by factory workers, that means that the data entry process has to be very straight forward. A seprate client wants addition information about one particular product...

Let me explain a little better on what I am trying to accomplish. I am adding a module to a database that is in use, the business need is to monitor user input based on products selected. If a particular product combination is selected the user in interrupted and asked to enter additional...

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...