Hi Duane, yes, but we have noticed some inconsistency. That is the filtering asks for specific input instead of a selection if a previous filter has been selected. For example, if one wants to select by work order, they can pick that work order, and then if they want to select a stock type or something, rather than providing which options to select by tic marks, it gives a prompt “text filters” with an arrow and you have to actually type something in. My colleague doesn’t believe the user base would be happy with something like that.
However, since then, the requirements have changed and rather than do the specific filtering, they want to provide me with scenarios in which each scenario produces a set of prescribed filters. So now this isn’t even an issue any more.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 25, 2017 4:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: filtering datasheet form
Hi Liz,
Are you looking for the same functionality as Excel data filtering? If so, that is standard functionality with Access datasheet view.
Regards,
Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, September 25, 2017 4:13 PM
To: MS_Access_Professionals@yahoogroups.com
Cc: Soufiane Mdaghri
Subject: [MS_AccessPros] filtering datasheet form
Pros, Have you experienced when you use the managed code filter on a data sheet and then can’t on subsequent fields?
I need to allow easy filtering of a form in datasheet view.
My proposed solution is to have a set of combo boxes at the bop that are populated by the filter options and perform the filtering with the after update event of the controls and base the drop down values with what is available by what is left by the existing filter.
Can you think of anything better?
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar