Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Unanswered: How to update a records

    I am an old basic programmer just getting back and starting to use access. Making a database for someone and need a question answered.

    How can I create an update query that would have user entered parameters to get certain records and then have a user enter a date to be posted to those records?

    I would appreciate any advice anyone could give me
    Thanks

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Welcome to the forums

    I would recommend building the string with VBA and then execute it.
    Me.Geek = True

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    An alternative would be to create a form for the user to enter the values on, and an update query which used those values. Then you just execute the saved query.
    Paul

  4. #4
    Join Date
    Jul 2009
    Posts
    2
    Thanks for the quick responses. As I said I am pretty new at this. How would i have the the form go to the query with that data and execute it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •