Preview a subdatasheet

[Sergey]

Hi all.
I have a small database with two tables: Clients and
Orders. Relationship is one-to-many. I open the Clients
table, select one client, expand a subdatasheet - his
orders. It's OK. But a preview the Clients table with
expanded Orders table is wrong. It doesnt show expanded
subdatasheets. Why?

I work with MS Access 2000 (Russian) on Windows 2000
(English) with SP4. I have installed SR1 and SP3 for MS
Office.

 

[Tim Ferguson]

I open the Clients
table, select one client, expand a subdatasheet - his
orders. It's OK. But a preview the Clients table with
expanded Orders table is wrong. It doesnt show expanded
subdatasheets. Why?

Because you are trying to use table datasheets and that's not what they are
for.

Use forms for interacting with data: you get far more control over
validation and presentation

Use reports for printing to paper: you get far more control over sorting
and grouping and presentation.


Access is not a spreadsheet program...


Tim F

 

[Alick [MSFT]]

Hi Sergey,

The original release of Access could suffer from problems printing
subdatasheets as outlined in this article:
ACC2000: Subdatasheets Print or Preview Incorrect Data
http://support.microsoft.com/?id=252742

The problem was corrected in SR-1 by automatically collapsing all
subdatasheets so that none of them could suffer from the problem. The
recommended approach is to use a report with a subreport to display the
data from the subdatasheets. The report and the subreport will allow you to
see all of the related data in all of the subdatasheets. If you only want
to display a single subdatasheet you will have to either restrict the
criteria upon which the subreport is built or use Visual Basic code to hide
the unwanted copies of the subreport.

Please feel free to reply to the thread if you have any concerns or
questions.




Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.







--------------------
| Content-Class: urn:content-classes:message
| From: "Sergey" <[email protected]>
| Sender: "Sergey" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Hi all.
| I have a small database with two tables: Clients and
| Orders. Relationship is one-to-many. I open the Clients
| table, select one client, expand a subdatasheet - his
| orders. It's OK. But a preview the Clients table with
| expanded Orders table is wrong. It doesnt show expanded
| subdatasheets. Why?
|
| I work with MS Access 2000 (Russian) on Windows 2000
| (English) with SP4. I have installed SR1 and SP3 for MS
| Office.
|