Recent content by sbuckingham25

  1. S

    Calculating hours worked.

    Hey Paul and txboy, I am trying to do this too. I have a field right now that the user just types in the hours himself. It is bound to a table field. Do I put this formula in the format of the form field? I tried and nothing happened. Can you talk me through it?
  2. S

    Use Combobox to search for record on different form

    Perfect....thank you thank you!!
  3. S

    When Selecting Org Name it is Adding to table

    I'm sorry. I used the combobox wizard and when I pulled down the combobox, it only showed the dummy jobs I had created to test, not the actual contacts in the contact database. Plus the afterupdate was there before as we do not want the tech to be able to change the org name after he selects...
  4. S

    Use Combobox to search for record on different form

    Awesome!! While on the subject of it going to a new record. How can I have it go to a new record when it is opened by my switchboard button "new job", but not go to a new record with this search? Is that possible?
  5. S

    Use Combobox to search for record on different form

    Still didn't work, now getting that the form is misspelled...hmm.... I attached the db the form the combobox is in is the FrmExistingJob
  6. S

    When Selecting Org Name it is Adding to table

    Thank you! Unfortunetly, when I do this, the name I select isn't store in the query the form is based on. (I had to use a table for the value because it is searching the field not the query). I have attached my db, it is the FrmTime&Materials form.
  7. S

    Use Combobox to search for record on different form

    Sorry, it is: Private Sub CmbExistingJob_AfterUpdate() DoCmd.OpenForm "FrmTime&Materials", , , "JobID = " & Me.CmbExistingJob End Sub
  8. S

    Use Combobox to search for record on different form

    I am sorry Paul for being a pain, but I did realize it was a numeric field. I removed the single quotes but still not working. Now getting a Run time 3075 error: Private Sub CmbExistingJob_AfterUpdate() DoCmd.OpenForm "FrmTime&Materials", , , "JobID = " & Me.CmbExistingJob & "" End Sub I...
  9. S

    Use Combobox to search for record on different form

    Ok I changed that and now have: Private Sub CmbExistingJob_AfterUpdate() DoCmd.OpenForm "FrmTime&Materials", , , "JobID = '" & Me.CmbExistingJob & " '" End Sub And now get a runtime error of '2501'
  10. S

    When Selecting Org Name it is Adding to table

    When I unbound the combobox, I can no longer select anything in any of my comboboxes now....?????
  11. S

    When Selecting Org Name it is Adding to table

    Thanks! How do I filter the recordset?
  12. S

    Use Combobox to search for record on different form

    I am getting a pop-up box asking for the parameter value of "TxtTMJobID" Here is my code: Private Sub CmbExistingJob_AfterUpdate() DoCmd.OpenForm "FrmTime&Materials", , , "TxtTMJobID = '" & Me.CmbExistingJob & " '" End Sub Suggestions?
  13. S

    When Selecting Org Name it is Adding to table

    In my form, when I select a name from a combobox that is attached to a query it adds it as a new record to my contacts. I am only using the combobox to pull what customer I want from the contacts. What am I doing wrong?
  14. S

    Use Combobox to search for record on different form

    Hi, I am basically creating a "menu" form, where the user can find an existing job to continue to update by selecting it in a combobox. I have created a query with the JobID, Orgname, Location and job closed checkbox. The job will only display if the job is still open. I want the Job form...
  15. S

    Error if nothing selected in Combobox

    I have a combo box in a form. If nothing is selected, I get this error: The Micro Jet databse engine cannot find a record int the table "TblParts'with key matching field(s) 'Parts'. Is there a way to have the field null, there will be jobs that Parts won't need to be selected.
See more
Back
Top Bottom