SweetingA
asked on
Filtering / Conditional Formatting Forms
I am using two date pickers as filters for a range of dates
The dates listed in the form are conditionally formatted in colours
When i select the range of dates using the date pickers i have two problems....
1. I need to press tab or return after using the date picker to register the date (i don't want to do this).
2. I need to click back on the date picker text box for the conditional formats to update (i don't want to do this).
Any simple ways to solve this?
The dates listed in the form are conditionally formatted in colours
When i select the range of dates using the date pickers i have two problems....
1. I need to press tab or return after using the date picker to register the date (i don't want to do this).
2. I need to click back on the date picker text box for the conditional formats to update (i don't want to do this).
Any simple ways to solve this?
What version of Access- and therefore, which datepicker- built-in or ActiveX or what?
ASKER
Access 2007 - built in
Does this have to be done dynamically in a form?
You can use a report fired from a form and all your issues go away...
You can use a report fired from a form and all your issues go away...
ASKER
I like the idea but i always though reports can only be triggered from queries and tables?
It seems that we have a Terminology issue here...
I never used the word "Trigger"
You can "Fire" (open via code) a report from a form.
So Clicking a button with this code:
Docmd.OpenReport "YourReport", acViewPreview"
..Will "Fire" the Report
What you are considering "Triggering" is really the "Recordsource"
A Report can have a "RecordSource" of a Table, Query, or SQL
This all being said, where do we stand with this issue?
JeffCoachnman
I never used the word "Trigger"
You can "Fire" (open via code) a report from a form.
So Clicking a button with this code:
Docmd.OpenReport "YourReport", acViewPreview"
..Will "Fire" the Report
What you are considering "Triggering" is really the "Recordsource"
A Report can have a "RecordSource" of a Table, Query, or SQL
This all being said, where do we stand with this issue?
JeffCoachnman
ASKER
The problem Jeff is that i want to filter the form which i have done with some drop downs but then what i really want is a report of the final form after it has been filtered.
My understanding is that a report can only be generated from tables or queries not from forms, is that correct?
My understanding is that a report can only be generated from tables or queries not from forms, is that correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.