Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    84

    Unanswered: SuperFilter data during work with forms

    Explanation:

    Access (accounting database) .mdb contains dozen companies accountant has to maintain, and years as accounting periods.

    Is there a possibility to make something like superfilter at the switchboard menu and after that all forms will add its filters to mentioned superfilter (orders for the chosen company and period, order details for chosen order, but everything for the specified company and accounting period).

    I saw few solutions with listbox, combobox.

  2. #2
    Join Date
    Feb 2004
    Posts
    142
    I have sometimes used a table to store application settings, usually named tblApplication_Data. Place in this table the fields that would be used for filtering. Then you can design a small form to call from the switchboard to set the application "filters" and use the table in joins in your SQL statements to limit the rows seen.
    KC

  3. #3
    Join Date
    Mar 2004
    Posts
    84
    Thanks for this answer;

    If I understand it right, that small table would contain something like:

    tbl_companies.IDcompany=tbl_orders.IDcompany

    as the string, in field - something like:

    filtercompany

    which will provide possibility to have it in WHERE clauses (somewhere later):

    .... WHERE filtercompany AND tbl_orders.IDorder=tbl_orderdetails.IDorder;

    I have few questions:
    - How to evaluate filtercompany (filtercompany contains filter for WHERE clause)?
    - How to use it in multiuser environment (if one user changes filtercompany - others will have problem - because they will have his/her chosen company in their filter)?
    - Is there possibility to have the filter in some public variable (did you try this)?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •