Search results

  1. A

    Best Way to Reference Subform Data

    Thanks Paul - works a treat!
  2. A

    Best Way to Reference Subform Data

    I tried using the syntax on that link to reference Staff_Name, but keep getting syntax errors. For the OnClick property of Action_Count in Subform_1 I have: DoCmd.OpenQuery "Query_1", acViewNormal, acEdit DoCmd.ApplyFilter , "[Staff_Name]= Forms!Form_1!Subform_1.Form!Staff_Name" DoCmd.OutputTo...
  3. A

    Best Way to Reference Subform Data

    Thanks Paul, The reason I want to open a query is so I can export it to Excel. I don't believe this is possible with a report. Thanks for the link, but my problem is the bit in bold: How would I reference "Me.ControlName" in a subform? Cheers, Alan
  4. 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...
  5. 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...
  6. A

    Best Way to Create Filters on a Report

    Thanks Alan, A few questions though: 1. When some of the fields are left blank, it doesn't filter for those fields. If the default value is "", how does it show all records? Why does it show records which contain data and not ones that are null? 2. Would this method work with combo boxes...
  7. 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...
  8. A

    Filtering Queries using List Box

    Pbaldy - thanks it worked well, just what I was after. Datagopher - that would have worked but my problem was more with how to set the filter rather than how to check if the list box is blank. Cheers, Alan
  9. 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...
  10. A

    Best way to set employee access levels

    Thanks David.
  11. 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