Patrick O'Dea
asked on
Converting My filters into a text string
Hi,
A slightly different question.
I have a continuous form.
I will apply some standard Access filters to this form.
E.g. Show all records where Product = "Widget"
I want to write a log to a one field audit table in the format ;
"28/02/2011 17:22:20 Filter Applied : Product = Widget"
How do I capture the "Product = Widget" as a piece of text. It does not have to be exactly in this format - I merely want to record the details of the filter applied.
I am hoping that there is a simple solution for this. If it is very complex than it might not be worth my while.
A slightly different question.
I have a continuous form.
I will apply some standard Access filters to this form.
E.g. Show all records where Product = "Widget"
I want to write a log to a one field audit table in the format ;
"28/02/2011 17:22:20 Filter Applied : Product = Widget"
How do I capture the "Product = Widget" as a piece of text. It does not have to be exactly in this format - I merely want to record the details of the filter applied.
I am hoping that there is a simple solution for this. If it is very complex than it might not be worth my while.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nice and easy