doran_doran
Registered User.
- Local time
- Today, 06:36
- Joined
- Aug 15, 2002
- Messages
- 349
Hi everyone,
Download the database:
http://www.utteraccess.com/forums/download.php?Number=459885
I have an export data form. Data gets loaded from a query. I was wondering if I can put additional filtering system. You can open the form "frmLocalAuthorityQuery" and select the query from the combo box, then highlight fields in the box and export.
> Field moving from box to box is not working
> Filter by is not working (dept gives the whole data)
(mgr gives data by manager, a combo for mgr pops up, cbotl hides)
(Team gives data by team_leader, mgr combo hides and cbotl pops up)
> I would like to filter the data by year (like 2000, 2001)
look at the query and you will know what i am talking about.
Any suggesstions or help will be appreciated. By the way, I dont have upper version of Access. If you have to post a database please put it in Access 97 version.
Download the database:
http://www.utteraccess.com/forums/download.php?Number=459885
I have an export data form. Data gets loaded from a query. I was wondering if I can put additional filtering system. You can open the form "frmLocalAuthorityQuery" and select the query from the combo box, then highlight fields in the box and export.
> Field moving from box to box is not working
> Filter by is not working (dept gives the whole data)
(mgr gives data by manager, a combo for mgr pops up, cbotl hides)
(Team gives data by team_leader, mgr combo hides and cbotl pops up)
> I would like to filter the data by year (like 2000, 2001)
look at the query and you will know what i am talking about.
Any suggesstions or help will be appreciated. By the way, I dont have upper version of Access. If you have to post a database please put it in Access 97 version.
