Adam Caramon
Registered User
- Local time
- Today, 19:27
- Joined
- Jan 23, 2008
- Messages
- 822
I'm currently working on an ADP (Access 2003 - Sql Server 2005). I'm trying to find a way to make filtering easy for non-computer people. So I have a bunch of records that all have a BeginDate field on them (field type smalldatetime).
I'm using a Form that is based on a View to display the records. All of that works fine. However, one complaint I'm hearing from a co-worker is that there are too many records to look through, and she is not familiar enough with Access to use filters.
So what I am trying to do is create checkboxes on the top of the form, with each checkbox equaling a year. If the box next to the year is checked, then records that contain a BeginDate value that's range falls into that year will be included in the displayed records.
So, basically, if 2010 and 2009 checkboxes are checked, then the view changes to filter on records that have the a BeginDate value between 1/1/09 and 12/31/10. I haven't had much success with this.
I seem to be able to change the RecordSource of the form with ease (via an OnClick event using .RecordSource = "v_whatever". So my temporary fix has been to create several views and then change the record source based on what checkboxes are checked.
However, it seems like there must be a far easier way then what I am doing. Any information/suggestions/hyperlinks to good info are appreciated.
I'm using a Form that is based on a View to display the records. All of that works fine. However, one complaint I'm hearing from a co-worker is that there are too many records to look through, and she is not familiar enough with Access to use filters.
So what I am trying to do is create checkboxes on the top of the form, with each checkbox equaling a year. If the box next to the year is checked, then records that contain a BeginDate value that's range falls into that year will be included in the displayed records.
So, basically, if 2010 and 2009 checkboxes are checked, then the view changes to filter on records that have the a BeginDate value between 1/1/09 and 12/31/10. I haven't had much success with this.
I seem to be able to change the RecordSource of the form with ease (via an OnClick event using .RecordSource = "v_whatever". So my temporary fix has been to create several views and then change the record source based on what checkboxes are checked.
However, it seems like there must be a far easier way then what I am doing. Any information/suggestions/hyperlinks to good info are appreciated.