Re: Subreports and SQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 07:02:57 -0800

Gillian

Terminology...

Subreports and subforms are not the same.

This is a tables-oriented newsgroup, relevant to neither forms nor reports.

You "migrate" data (i.e., tables) to SQL-Server (or other back-ends), but
forms and reports (and their subs-) don't migrate.

Access (front-end) is a VERY useful way to build user interfaces (i.e.,
forms, reports), regardless of the back-end that stores the data.

I'm not clear on what you are asking about... 

-- 
More info, please ...
Jeff Boyce
<Access MVP>
"GillianHG" <gillianhennessey@hotmail.com> wrote in message
news:D4B9BED7-F3FD-4E88-B755-556B494223CD@microsoft.com...
> Hi,
>
> Can someone tell me if there is any known difficulty between subreports
and
> SQL. I saw a post on this board (can't remember where but I saw it) about
> difficulties with having subforms in an Access database and then migrating
> the db to an SQL platform. Apparently the subforms don't translate well...
> Anyway, I need to know if this is true for subreports also. I teach Access
in
> an environment where people use Access for databases serving <8 people. If
> more people use the db it gets migrated to SQL, so I don't want to teach a
> concept that they should avoid in the event their database does get moved
> over.
>
> Thanks for the help.
> Gillian

Relevant Pages

  • Re: Huge database weighs heavily on small brain
    ... And also the subforms... ... > gave you a little better description of my database. ... All the Queries and Reports are ... > will display information from multiple subsets of Tables organized by Review ...
    (microsoft.public.access.forms)
  • Re: Subreports and SQL
    ... subforms on your forms will impact functionality. ... subreports) on objects or just with subforms? ... > This is a tables-oriented newsgroup, relevant to neither forms nor reports. ... >> difficulties with having subforms in an Access database and then migrating ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Huge database weighs heavily on small brain
    ... And also the subforms... ... >> accountable for the proper design and function of the database. ... All the Queries and Reports ... >> month review period. ...
    (microsoft.public.access.forms)
  • Re: Subreports and SQL
    ... > continuing to use Access as a front end for forms, reports, etc) that ... > subforms on your forms will impact functionality. ... > subreports) on objects or just with subforms? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Group Header Splits When Spanning Multiple Pages
    ... had this happen once and drove me crazy until I figured out it was the ... printer not the database. ... three reports (one main report and two to be included as subreports). ...
    (microsoft.public.access.reports)