Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Location
    San Antonio, TX
    Posts
    69

    Unanswered: A97: Subreport question

    Is it not possible to have a subreport (not a subform) on a form?
    "Doing stuff is overrated. Take Hitler for example. He did lots but don't we all wish he'd have just stayed home and gotten stoned?"

  2. #2
    Join Date
    Jan 2003
    Posts
    2

    subreport in a Form

    Yups....its possible.

  3. #3
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    try Microsoft Snapshot Viewer ActiveX Control....

    http://msdn.microsoft.com/library/de...tSnapshots.asp


    jiri

  4. #4
    Join Date
    Feb 2002
    Location
    San Antonio, TX
    Posts
    69
    How is this done in Access 97? Examples?
    "Doing stuff is overrated. Take Hitler for example. He did lots but don't we all wish he'd have just stayed home and gotten stoned?"

  5. #5
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    open new form a place there SNAPSHOT VIEWER activex control9menu insert-activeX control), then you can have under button or when you open the form

    DoCmd.OutputTo acOutputReport, "Report1", acFormatSNP, "C:\myreport.snp"
    Me.SnapshotViewer0.SnapshotPath = "c:\myreport.snp"

    it exports report to SNP and then reads it....

    the problem is that it works only under Access2000 :-(

    in another words... reading works under Access97, exporting report to SNP does not. My Access97 didn't work with it, although Microsoft says that you can SAVE AS Snapshot...

    http://www.microsoft.com/accessdev/a...s/snapshot.htm



    jiri
    Last edited by playernovis; 01-23-03 at 23:46.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •