Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Question Unanswered: Interactive Update

    Thank you all in advance for your help.
    MS Access 2000


    My current dataset will look something like this.

    Code Text_Date Location
    1 2004-01-28 Offsite
    2 2004-01-28 Offsite
    3 2004-01-28 Offsite
    4 2004-01-28 Offsite
    ...
    7 2004-03-15 Onsite
    8 2004-03-15 Onsite
    9 2004-03-15 Onsite
    10 2004-03-15 Onsite


    What I want done is to prompt the user for the date and update the Location field.

    What I would like to do is set up an interactive query where the user specifies the constraining date (text box, manual typing?) and chooses to alter the location either typing the Offsite / Onsite text or choosing from a combo box.

    Has anyone done anything similar to this?

    Thanks

  2. #2
    Join Date
    Aug 2004
    Location
    Cary, NC
    Posts
    264
    If you just want to use a query you could put

    =[Enter Date] in the criteria for the date field
    and
    =[Enter Location] in the criteria for the location field

    (the text inside the [ ] is what the user will see)

    However, since you are dealing with dates that will have to be in a specific format I would suggest creating a form for this purpose. Have the user enter the date in a text box with an input mask or with a calendar control.
    You could then have a location combo box so they can't make a typing mistake.

    Set your query up to refer to the form. Easiest way is to use the build function (right click in criteria).

    Use the command button wizard to set up a button to run the query.

    Hope that helps.
    Steve.

Posting Permissions

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