Pass-through query for sub-report (Access 2003)

  • Thread starter Thread starter TomT
  • Start date Start date
T

TomT

Is there any workaround to allow using a pass through
query for a subreport, while using link child and master
fields?

All kb's I've found say it can't be done, but I thought
I'd see if anyone has found a way to do this.

thanks
 
Hi Tom,

Thank you for using MSDN Newsgroup! My name is Billy and it's my pleasure to assist you
with your issue.

From your description, I notice that you'd like to use a linked subreport with a SQL pass-
through query as its record source. Have I understood the issue correctly and completely? If
there is anything I misunderstood, please feel free to let me know.

I believe you have read through the following article and make sure that this behavior is not
allowed from Access 97 to 2002.

288633 HOW TO: Base Subforms on SQL Pass-Through Queries in Access 2002
http://support.microsoft.com/?id=288633

209116 HOW TO: Base Subforms on SQL Pass-Through Queries in Access 2000
http://support.microsoft.com/?id=209116

112746 ACC: How to Base Subforms on SQL Pass-Through Queries
http://support.microsoft.com/?id=112746

I'm afraid I need to mention that SQL Pass-Through Queries also cannot use
LinkChildFields/LinkMasterFields in Access 2003. The best way to use server-based data in
a subreport/subform is to link the remote table and then base the subform on the linked table.

Tom, does this answer your question? If there is anything more I can do to assist you, please
feel free to post it in the group


Best regards,

Billy Yao
Microsoft Online Support
 
Billy,

Thanks for your response. Yes, you have understood
correctly, and I had read those articles. I was just
wondering if there was a work around, or, if anything had
changed in Access 2003.

It appears I have no choice but to link the tables to use
the Link Master/Child fields for a subreport.

Thanks for your assistance.
-----Original Message-----
Hi Tom,

Thank you for using MSDN Newsgroup! My name is Billy and it's my pleasure to assist you
with your issue.

From your description, I notice that you'd like to use a
Click to expand...
linked subreport with a SQL pass-
through query as its record source. Have I understood
Click to expand...
the issue correctly and completely? If
there is anything I misunderstood, please feel free to let me know.

I believe you have read through the following article
Click to expand...
and make sure that this behavior is not
allowed from Access 97 to 2002.

288633 HOW TO: Base Subforms on SQL Pass-Through Queries in Access 2002
http://support.microsoft.com/?id=288633

209116 HOW TO: Base Subforms on SQL Pass-Through Queries in Access 2000
http://support.microsoft.com/?id=209116

112746 ACC: How to Base Subforms on SQL Pass-Through Queries
http://support.microsoft.com/?id=112746

I'm afraid I need to mention that SQL Pass-Through Queries also cannot use
LinkChildFields/LinkMasterFields in Access 2003. The
Click to expand...
best way to use server-based data in
a subreport/subform is to link the remote table and then
Click to expand...
base the subform on the linked table.
Tom, does this answer your question? If there is
Click to expand...
anything more I can do to assist you, please
 
Back
Top