473,327 Members | 1,896 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,327 software developers and data experts.

Access 2000 Report - trouble with data entered in subforms

Hi everyone, basically my problem is this:

I am using an Access 2000 format.

And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the project name, one primary point person for it (1:N list from a separate table), other details, and a manually entered tracking number, which is the primary key.

Now, I also need to put down the legal entities, business managers, financial controllers, and supporting staff, and since these just come from the same pool of people I decided to use subforms for them so I'd only need to type in their names once in the separate table and just select them on the main form if i need them. The subforms are properly working -- they allow me to select one or more entries for the other. Form's working perfectly too.

My problem is that the report I build--no matter how i group or sort!--displays only ONE entry from those four subforms/subtables, and then repeats everything until all the combinations have been entered. Say I have this Project Alpha, with Bob as my point person. For legal entities involved in this Project Alpha I have Entity A, and Entity B, and for business managers I have Manager R and Manager S, (and say we leave the others blank.). I have other details of course but, essentially this is what happens on the report, and where I have problems with using subforms:

Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554


Legal Entities Involved: Legal Entity A
Business Managers Involved: Manager R


Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554


Legal Entities Involved: Legal Entity B

Business Managers Involved: Manager S

Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554


Legal Entities Involved: Legal Entity A
Business Managers Involved: Manager S

Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554


Legal Entities Involved: Legal Entity B
Business Managers Involved: Manager R



.... :confused: The same project has four separate entries on the report just because I had two legal entities and two business managers selected in the subform! Imagine how many repititions I have with having multiple financial controllers and supporting staff... so I don't know what to do since I still want to retain the subform structure in the report. (I could just put multiple fields in the original table but this would defeat the purpose of access).

Anyone out there have this same problem before? I can't use the "view by" mode used in Access 2003 since I am formatting this using Access 2000 for an office that can't upgrade all its computers to '03. Not that that would matter, would it? : (
Aug 19 '06 #1
2 1988
MMcCarthy
14,534 Expert Mod 8TB
Have you tried using sub reports in the same way you used sub forms.
Aug 19 '06 #2
? ooh boy. okay i have never even heard of subreports before. I had a similar project in school where i only had one subform and it worked perfectly. Then I worked from there to create this database, i'm glad i posted here. Thank you so much! I'll look into it but it seems to solve my problem from what I can tell.
Aug 19 '06 #3

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

Similar topics

20
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet...
3
by: pbbriggs | last post by:
I will try to be as descriptive as possible, but this error has me stumped and I am not sure what relevant info to include.... I am running Access XP on a Windows XP machine. I initially began...
5
by: Robert | last post by:
Hello Accessors I have some reports created in Access that are very good for what they do. However, it seems to me that when you are displaying information you don't need to print out that a...
3
by: CSDunn | last post by:
Hello, I have a situation with MS Access 2000 in which I need to display report data in spreadsheet orientation (much like a datasheet view for a form). If you think of the report in terms of what...
22
by: Deano | last post by:
Hi, I have a finished Microsoft Access app that we are distributing using an Access runtime. This works fine (mostly) but I'm sold on the advantages of dot.NET and upgrading to vb.NET seems...
9
by: Fish Womper | last post by:
I am at best a part time developer of Access databases. I use Access 2.0, as this is all my employer has on its computers. Even so, to use this ancient version requires a fairly convoluted...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
1
by: ashkash | last post by:
I have an access database which takes information from a user and then uses the mail merge functionality to merge the data into a word document. I have a lot of subforms in the access database which...
4
by: Henrootje | last post by:
I have a REPORT with in it a subFORM Now I have this label (lblMonth) that I want to change. How should I do this? What would be the proper event to do this? The lblMonth should contain the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
1
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...
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
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.