Recent content by captainlove

  1. C

    Error On VBA code

    Hello bob, Thanks for your response. I get the first error. The second error " & me.txtUser&. Should that read "& Me.txtUser &_ Thank you Bob, you the best
  2. C

    Error On VBA code

    error on vba code hello bob, here is the database the form is frmqcplist1, to get to that, its the first button on the switchboard. Once in form, select a user/qcp combination and click display. I am trying to make the revision and revision date specific to combination thanks a lot...
  3. C

    Error On VBA code

    Am still getting the error. Can I share my database
  4. C

    Error On VBA code

    I get an error after the group by statement in my VBA code saying expected: line number or label or statement or end of statement My VBA is greyed out, after the group by clause. I suspect the error is before that. I have spent six hours on this. Can anyone out there help Sql = "INSERT INTO...
  5. C

    Filter Problem on a subform

    I am getting an click when I click the command button saying you cancelled the previous operation Private Sub cmdDisplay_Click() On Error GoTo Err_cmdDisplay_Click Dim strSQL As String Dim Sql As String ' <-------- 'Declarations DoCmd.SetWarnings off 'Delete data from...
  6. C

    Filter Problem on a subform

    The controls I want to filter from are txtuser and txtqcp from the main form. This filters into the subform that has two controls txtrevision and txtrevison date. My code look like this and I am getting an error on the third and fourth line 'Build SQl String If Me("txtuser" &...
  7. C

    Filter Problem on a subform

    Me.SubFormControlName.FORM.Filter = strSQL Me.SubFormControlName.FORM.FilterOn = True would go Me.txtrevisiondate.sfrmhistory.filter=strSQl Me.txtrevision.sfrmhistory.filterOn=True Would this go on the main form or subform
  8. C

    Filter Problem on a subform

    Rural guy, What should the sql statement look like
  9. C

    Filter Problem on a subform

    I have a main form that has two combo boxes, txtuser and txtqcp. My subform has revision date and revision text controls I want to filter revision date and revision based on the selection I make for a txtuser and txtqcp(i.e user BP and qcp 10000) so that on my sub form it would have the...
  10. C

    After update event

    Hello Bob My textbox is unbound, using either of those still inserts blank rows into the subform
  11. C

    After update event

    Another thing is that, when I use these two codes in the lost focus event of the textbox control, it insert a blank row in my subform Me.txtresponsibilities.Text = "" Me.txtresponsibilities.Value = ""
  12. C

    After update event

    The problem with that code is that A textbox control does not have a current event
  13. C

    After update event

    This code makes the data in the subform null as well as making the textbox blank. How can I make only the textbox blank after update
  14. C

    After update event

    I have a main form with a combo box, containing a list of qcps(numeric values) on that main form is a text box to add to my subform data like references or responsibilities for each qcp i.e 10000 The problem is that when I add data to the text box and I click accept, which insert the value...
  15. C

    Error on VBA Code

    so what should it look like Adam
See more
Back
Top Bottom