Search results

OK, when I put the string in the where condition (Left$([FIN],3)="AVE") the report is filtered. Now how do I tell it to look at the macro that set's these filters?

What about the Where Condition on the Browse to action? Is that a possibility?

Maybe this will help..... i have a button for each report and I am using a Browse To action that asks for; Object Type: Report Object Name: rptContactInformation Path to Subform Control: frmNavigationMain.NavigationSubform>frmReportCenter.sfrReprtPage This works but I want the report...

Thanks for all your help but I'm still not seeing the Export/Import wizard...... I created a button to export the data and it works fine. However, it's exporting the entire query and not the filtered information that I have been asking about. The data is filtered on the form that I am exporting...

Hmmm, I don't see any wizards under the External Data Tab....... Do you have any idea about my other thread about filtering my reports via Macros? I've got the filters working but then access keeps asking me for a Subform or Subreport.......

, Left$([FIN],3)="AVE", [Forms]![ParentFormName]![SubFormName].[Form]![SubFormControl] I believe this is the path to the report that I want filtered but I can't seem to get the correct form names in the proper order.

Alan, It appears that my filters are working for the reports but the path to the actual report is broken? How do I figure out the path code?

VBAInet, I don't even see the EXPORT wizard. Where is it located? And it is part of the normal Access program or is it an add on?

These filters work but I want to add the filter to the reports as well.....When I added the mcrFilter to the report button and ran it I received the error message mention above.

' FilterType - 1 = AVE, 2 = SCE-CHA, 3 = EPR, 4 = SCE-INT, 5 = SCI, 6 = VEE, 7 = UCN, 8 = SCI-NSA: Restraints, 9 = SCE-ENG, 10 = SCE-ELE, 11 = SCE-BOD, 12 = ALL, 13 = SCI:, 14 = SCI-ARD, 15 = SCI-BPS, 16 = SCI-CPG, 17 = SCI-DEB, 18 = SCI-MFS, 19 = SCI-NSA If (TempVars!FilterType = 1) Then...

No I have not.

Thanks for the info but I believe there has to be a way to use the same macros that are currently filtering my query. I am getting this error when I run the macro on the report button; The 'Setfilter' action required a valid contol name that correspons to a subform or subreport. Any ideas...

The qselEmployeeInformation is the query for the reports but I want the reports filtered by department which I have macros for. The referenced query has ALL employees in it and I want the reports to be filter by department. So the query is the record souce for the reports :-)

Currently, I have Macros that filter my employee query and I am looking to apply those same filters to the reports. How can I achieve this?

Yes it is. I have a navagation form that is populated when the user picks a Button on the prior form. On this navigation form I have employee list tab, employee change tab, employee add tab, and report center tab. When the initial cmd button is picked the filter runs and the proper records are...

' FilterType - 1 = AVE, 2 = SCE-CHA, 3 = EPR, 4 = SCE-INT, 5 = SCI, 6 = VEE, 7 = UCN, 8 = SCI-NSA: Restraints, 9 = SCE-ENG, 10 = SCE-ELE, 11 = SCE-BOD, 12 = ALL, 13 = SCI:, 14 = SCI-ARD, 15 = SCI-BPS, 16 = SCI-CPG, 17 = SCI-DEB, 18 = SCI-MFS, 19 = SCI-NSA If (TempVars!FilterType = 1) Then...

If (TempVars!FilterType = 1) Then DoCmd.SetFilter "", "Left$([FIN],3)=""AVE""", "NavigationSubform" End if Hopefully this is what your looking for. This is just one of the filter entries that I have in the Macro

Now all I have to do is figure out how to filter the reports.......Uggh. I really wish I knew how to get you the code required to get help on that other thread from yesterday!

That worked wonders..... Thanks....VBAInet

I am trying to count the number of classification types for employees in a report. The types are NBU, SBU, CON, SRA, and HBU. Each employee has a classification and when I run the count code on a report it's counting ALL employees with a classification. I want to count the employees that have...