Search results

  1. L

    VBA Coding Error - Runtime Error

    Hi all, I am having some trouble with my VBA code attached below. It is coming up with a runtime error (3464 - data type mismatch). I am unsure of what I have done wrong and any assistance would be greatly appreciated. Private Sub cmdAdd_Click() Dim strInsert As String If...
  2. L

    Run Time Error '3134' - Syntax Assistance Required

    That's fantastic Colin thankyou for you help!
  3. L

    Run Time Error '3134' - Syntax Assistance Required

    The error is showing up as the line that says DoCmd.RunSQL Further to your point, all fields should be text as this solution is a simple workaround at this stage and has potential variations in the format data will be entered.
  4. L

    Run Time Error '3134' - Syntax Assistance Required

    I have tried with the space and unfortunately it still does not work. This code adds to a table which then is appended to a master table the user has inputted all the different vehicles. I am unsure of how to do a query prior to this step.
  5. L

    Run Time Error '3134' - Syntax Assistance Required

    Hi all, I am building a basic form that requires several text boxes to be captured and inserted into a table appropriately, however as I have added the final textbox into my VBA code I get a 3134 error and cannot seem to find where I have gone wrong. The code is as follows: Private Sub...
  6. L

    Hi all

    Hi all, I am here to expand my knowledge of access and seek answers that i may need when I am doing work :)
Top Bottom