Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    UPDATE Query - UPDATE fields through INPUT Prompt (2000)

    I'm creating a database where I need operators to update a single field (SETTLE_DATE) in a large number of records each month.

    I'd like to automate this process using an update query; however, I'd prefer to lock the database down and not have the operator make the change directly in the query. I'd rather have the operator input the change in an input dialog box, similar to parameter input query dialog box, e.g. Between [Enter Start Date, MM/DD/YY] And [Enter End Date, MM/DD/YY] resulting in the operator inputting a start date and an end date for the records to be returned

    The field to be updated is SETTLE_DATE (from DATAtbl) and the update value will be a single date, e.g. 05/19/2005

    I'd appreciate any help provided.

    Scott

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: UPDATE Query - UPDATE fields through INPUT Prompt (2000)

    You can use a parameter prompt in an update query too: enter [Enter new date MM/DD/YY] in the Update to line for the SETTLE_DATE field.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: UPDATE Query - UPDATE fields through INPUT Prompt (2000)

    Simply create a form that has 3 textbox controls: Starting Date, Ending Date, and Settle Date. Add a command button that says "Process".

    Your query will reference the controls on this form. I assume there is some date field other than SETTLE_DATE that is the date you are pulling records against. In the UpdateQuery, its SelectionCriteria would be:

    Between Forms!myInputForm!txtStartingDAte and Forms!myInputForm!txtEndingDate

    For the SETTLE_DATE field, the "UpdateTo" property would be set to Forms!myInputForm!txtSettleDate

    (Of course, I'm guessing at the form, fieldnames, and control names)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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