Search results

  1. J

    Updating reocrd in table/query

    I am trying to edit an existing record in my database.It goes to the correct record to update but will not update if "RecordUpdate" is specified as auto numbered. If the "RecordUpdate" is just specified as a number in the query it is fine. CurrentDb.Execute "UPDATE QryIssueData " & _...
  2. J

    Deleting record from Table or Query

    I am trying to delete a record from a table and when I pass the variable as a text value it works but when I pass as a number I am getting a mismatch error. I have to use it as a number as I am doing other update code in my database and it is a number. Code: DoCmd.RunSQL "DELETE * FROM...
  3. J

    Taking data from form and placing into table

    I have a form that I am inputting data into. I have been able to Clear the form. I have created an edit script and it brings the data from the table to populate the form. When I try to change the data in the form and run a VBA update to push the data down to the table I am having no luck. I can...
  4. J

    Planner and Scheduler

    Hello all, I am presently employed in Fort McMurray AB Canada and I am a novice, self-taught user. Most of my exposure to access and VBA has come from manuals and YouTube. I have learned many interesting things from this forum and look forward to participating as I grow with the community. VBA...
Back
Top Bottom