473,322 Members | 1,644 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Creating a report from a subform

I have created a report from a subform. However, there is one nuance I have not been able to formulate. To give a little background. I have a table (Managers) and table (Staff). The main form information is related to the managers table. While the sub form is related to the staff reporting to that manager. It all works fine, except that I would like to create individual reports for each manager, rather than one continuous report that includes all the managers in the organization. Can anyone offer any suggestions on how to make this happen? Thanks.
Oct 26 '12 #1
6 2979
TheSmileyCoder
2,322 Expert Mod 2GB
One approach could be to create first a report of managers, and have the staff as a subreport.

Finally open the manager report while applying a filter to select only one manager.
Oct 26 '12 #2
Rabbit
12,516 Expert Mod 8TB
Group by manager and use a page break.
Oct 26 '12 #3
Thanks to both The SmileyCoder and Rabbit. I'll try your suggestions and report back.
Nov 4 '12 #4
Would someone be so kind as to provide an example of how to filter from the example I cited with the manager report and staff report , so that only, one, not all the managers appear on the report.

What would be great is if I could put a combo or listbox on the form and have the person select the manager and have only his / her report and subreport appear and ready to print. Or even a pop-up criteria box would suffice. I tried to filter the report by using this code:=([Manager Last Name]) in the "Filter" property in the data tab. However, I just keep getting a syntex error. I also tried just including one name in the query grid criteria. This did indeed limited the query to pull only one record. However, the report continues to list all the records. Any guidance on this matter would be greatly appreciated.
Nov 6 '12 #5
NeoPa
32,556 Expert Mod 16PB
Asking for specific code is not really allowed, but hopefully you'll find enough concept information in Example Filtering on a Form to help you on your way. We can comment on your existing code for you, but simply doing it for you isn't what we do (generally). Hopefully though, the examples and explanation in the linked article will be exactly what you need.
Nov 6 '12 #6
NeoPa Thanks for the info. Will let you know how it turns out.
Nov 11 '12 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Matthew Clubb | last post by:
Hi, I need help developing an expanding form I've decided that a use of PHP, Mysql and Javascript is the best platform for creating a selection of database interfaces which I'm trying to build...
2
by: Andrea | last post by:
I'm having some difficulty creating a report in Access and I need some suggestions. My company issues "Return Authorizations" when customers need to return products. A customer calls in and we...
1
by: Evets Htims | last post by:
This is Access 2003. Have a report that includes three subreports stacked on top of one another (they display order items). In the report On Open I build a recordset (to get a value from a foreign...
4
by: godsent | last post by:
hello all. plz help me wid this simple yet complicated prob: how to create a subform form in Ms Access( Visual BAsic)..am not able to start this wizard.. thanks
4
by: jmarr02s | last post by:
I am using Access 2003 and am having difficulty creating a subform that will save records associated with a particular parent record.... The error message I receive pertains to indexes,...
3
by: cassey14 | last post by:
Hi I hope someone help me on this.. I need to attach any files in my form like word,excel etc and save it on database..and also I need to open it at the same time..please help me... and also im...
3
by: T | last post by:
I'm trying to determine the useage of varioius reports I have. I need the following to occur when a report is opened, get the name of the report, datetime, username. I created a tblLog...
2
by: Craig | last post by:
I am trying to create a form that shows quote info, but also has a subform that lists all keywords and allows you to select multiple keywords to associate with that quote. I have never done a...
1
by: MikeMikerson | last post by:
Hello, I am need to create a subform (no problem) of a form based query (a problem). I need a form that will prompt the user to enter in a name, and the form will then display a query of the...
3
by: mulamootil | last post by:
Hi friends, I am new to access and I need to create a report. Please pardon me for such a long post.Appreciate your patience. I have a table in Access (MyTable) with data about products...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.