Search results

That looks great, now what if I wanted to use a query called "qselChassisEmployeeInformation" The query retrieves the correct data and I'd rather sue the query because there are about 20 to 30 department numbers for each group.

1250-0850 is the department number but I think you're telling me to replace that with the query.

What if I wanted to use a query in that expression? I've already created all the queries for each department. Is that possible?

So the string would look like this? DoCMD.openForm "frmNavagationMain", , ,"FinancialDepartment = '1250-0850" & Me.ControlName & " ' "

The records are for people tracking. HR has their own system and won't let anybody access it. There are no confidential records to worry about. The link you sent me seems to have the right idea but I'm not sure what would go into the VBA code for my use.

No, the first form is where I'd like the users to specify which group they work with by clicking that button which would bring them to the MAIN form only showing the records that apply.

http://www.access-programmers.co.uk/forums/showthread.php?p=1117399#post1117399 Here is the url

I have created an employee database for many different groups (departments) to use and I'd like to create a button that restricts or filters the data from the employee table for particular departments. Exampe: I have a form with all of the different groups labeled with cmd buttons and upon...

I have another issue, can you help?

I was able to fix the subform control. Thanks...:D

This part is fixed. I finally figured it out. THANKS:D

Sorry..... It's hard to do this without pictures. However, I figured it out with trial and error.....and it actually works... frmNavagationMain.NavigationSubform>frmReportCenter.sfrReportPage Now I need to know how to filter or query employees with a button that filters by department number...

frmNavagationMain.NavagationSubform10>frmReportCenter.sfrReportPage I'm not sure how to answer your question? But this is the latest argument that I treid and it doesn't work either

frmNavagationMain.NavagationControl10>frmReportCenter.NavagationControl10 Can anyone help with my path on the subform control? The above argument isn't working. :mad:

I have a Report Center form and I want the reports to show up on that form as you pick the report from the cmd button on the side. The reports show up on the form and from there you can open them up in a separate window or just view the report right on the form. I copied the design from an...

Savy in Access, no VBA Backgroud

I've been using access for a while now but only as a user not a programmer or designer. I have ZERO vba knowledge. I understand it but don't know the language. I have had no problems copying others VBA code and using it as my own, but I cannot write my own code.

I am trying to use the browse to action and I keep getting an error with my path? Can anyone help me?

Ok, so I created queries for each group/department but then I would need a form for each group too and I don't really want to do that. I tried filters but I can never get them to save. I am also having trouble wiht the Browse To command. The Path to Subform Control is giving me an error...

Does anyone know how to create the Report Center From from the 2010 Access Sample database. It's the Northwind Traders database. The report center form has command buttons on the right that disply the report in the form, not a separate report, but the report shows up on the form.