Edit a Query From a Form

Topic

New Reply

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

Reply | Quote

Replies

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

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.

Reply | 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.

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

Thanks!
Leesha

Reply | Quote