Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,
    I have a user who will need to edit 8 query fields on a monthly basis due to the fact that dates will be changing. They use a linked excel spreadsheet containing data they download from their parent company's website. This data is compared to data they have in tables in their local database. This all works fine as long as I reset up the query each month for them with the new dates. The staff DO NOT create or modify queries on their from the design or wizard views not do I anticipate that they will. So, with that being said, is it possible to create a form that allows them to edit query? If this possible, what approach should I take.

    Thanks,
    Leesha

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    [quote name='Leesha' post='762601' date='01-Mar-2009 10:32']Hi,
    I have a user who will need to edit 8 query fields on a monthly basis due to the fact that dates will be changing. They use a linked excel spreadsheet containing data they download from their parent company's website. This data is compared to data they have in tables in their local database. This all works fine as long as I reset up the query each month for them with the new dates. The staff DO NOT create or modify queries on their from the design or wizard views not do I anticipate that they will. So, with that being said, is it possible to create a form that allows them to edit query? If this possible, what approach should I take.

    Thanks,
    Leesha[/quote]

    Personally, I'd build a form that allowed them to enter the dates they wanted, then build the query myself in code once they clicked somethining like a "SAVE" button on the form.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='MarkLiquorman' post='762613' date='01-Mar-2009 12:08']Personally, I'd build a form that allowed them to enter the dates they wanted, then build the query myself in code once they clicked somethining like a "SAVE" button on the form.[/quote]

    Sounds like a good plan. It's what I was thinking of doing but wasn't sure if there was another approach.

    Thanks!
    Leesha

Posting Permissions

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