Same Table Different Reports

[Trudye]

I have what might be termed a novice queston. My User has requested the same report 10 differnt ways. The basic information is the same for all reports. There are 2 subforms for each report, and because of the way the data is structured that means 3 different tables.

Is it possible to use the same table(s) for all reports?


Thanx
Trudye

 

[Trudye]

I guess I should state my concern is contention if they run multiple reports at the same time.

Trudye

 

[dhookom]

It is still unclear (at least to me). Users can run multiple reports at the same time. Also, I would not place subforms on reports. I always use reports as subreports.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[Trudye]

sorry I meant subreports.

I guess the question is can they run multi reports that use the same table. If report "A" and report "B" both use General_Report_table. Can they both run at the same time?

Sorry for the lack of clarity.

Thanx
Trudye

 

[dhookom]

Yes, you can open multiple reports at the same time that are based on the same table(s).

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[Trudye]

Ok, Ok, this is starting to become clear as Mud.

I have a question (before this is over with rest assured I will have many more). This is my first time so be gentle in your explanations.

What is a Custom database property?

Also if I am understand FancyPrarie correctly (and me thinks I yam), a PC can be several version in arrears. When that PC opens a database all changes are applied to bring it up to date. Now for the dumb question. Are the changes applied individually? Say I added a line of code to On_open event, is that line of code added or is the whole database replaced?

What happens if it is discovered that a change is causing problems? Do you keep the previous versions to facilitate a quick recovery process and get your Users back up and running quickly with the old/previous version?

I must admit I have never heard of an .MDA file before except for System.MDA (which I have never used either). Of course what I've never heard of could make a whole New World. I already have a database that contains tables only. So I would rename that database and add and customize Checking's code?

OBTW Chrisbee thanks so much for the input but I better learn how to do this a'natural it's usually better in the long run.

Thanks again,
Trudye

 

[dhookom]

I think your reply was posted to the wrong thread. I don't see anything that pertains to the original question. New questions that are not related to the first question deserve their own threads.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[Trudye]

You are right sorry about that

Trudye