Search results

  1. A

    Best Way to Reference Subform Data

    Hi, I have a Form_1 which contians Subform_1. Subform_1 appears in datasheet view and displays a the number of actions for each staff member. So the fields are: Staff_Name (text) Action_Count (number) Now suppose Joe.Bloggs had 26 actions and Paul.Smith had 35. If a user clicks on...
  2. A

    Filtering a Query then Exporting to Excel using VB

    Hi, I have a form with some combo boxes / check boxes and a 'generate report' button for the user to generate a report based on the criteria they specify. Using the DoCmd.OpenReport function and a WHERE condition, it successfully opens the report for criteria the user selects. So if the...
  3. A

    Best Way to Create Filters on a Report

    Hi all, Here's my situation. I have a report (Report_1) based on a query (Query_1) which contains the following fields: Staff name (text) Manager name (text) Location (text) Client (text) Key client (yes/no) Date payment due (date) Overdue (yes/no) I want to create some sort of filtering...
  4. A

    Filtering Queries using List Box

    Hi all, I have a query which shows staff members and their campaigns. The 'criteria' part of the query looks up the staff member selected in a report's list box and filters for that staff member's campaigns. So for example, if the user selects 'Joe Bloggs' on the report' list box, the query...
  5. A

    Best way to set employee access levels

    Hi, Here's the situation. I have some VB code (GetUserName) which pulls in the username of the user from the Windows API. I then have a table which contains the desired access levels for each employee. The fields are: * EmployeeName (text) * AllowedAccessToControlA...
Back
Top Bottom