View Single Post
Old 09-09-2019, 07:33 AM   #8
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,460 Times in 1,441 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Macro problem - Re querying

Quote:
Originally Posted by Ceebee86 View Post
Hi!

Thanks for your replies!

I have 8 hyper links..

Agent, consignee, customer, Haulier, Invoice party, Manufacturer, Shipper, Shipping line, all with a variation of the Filter's seen in this picture.



Macro
https://imgur.com/a/FZ5pN3R"]https://imgur.com/a/FZ5pN3R

Form
https://imgur.com/LpEbnYD"]https://imgur.com/LpEbnYD
Okay, one idea is to check the filter applied, if any, and then replace it with the opposite. For example, pseudo macro code:


1. Check if filter is applied
2. If not, do nothing
3. If there's filter, store the filtername in a temp variable
4. Search the filter name for the word "Not"
5. If exists, delete it, or replace "NotActive" with "Active"
6. If not exists, replace "Active" with "NotActive"
7. Reapply new filter using the temp variable


Hope it helps...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote