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

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___