Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reports and OLE Fields (2002)

    I have a subform with an OLE field which I would like to embed reports in. I have a list box on the side and want to quickly view reports by just scrolling down the list box and selecting a report..
    I have exported and copy/paste to MS Word and then inserted this into an OLE and it works. But this is kind of sloppy and I can't be certain my clients have MS Word.
    Frank Hoeffer

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports and OLE Fields (2002)

    Use a snapshot file instead of a word document.
    Francois

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports and OLE Fields (2002)

    Thanks for responding Francois,
    I'm not sure how to do this in code.
    I'd like to have a way to insert the snapshot of the report in the OLE field when a new report is made.
    Probally a form that makes the snap shop, names the report for the list box and and then inserts the snapshot into the OLE field.
    Frank Hoeffer

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports and OLE Fields (2002)

    To output a report in snapshot format use the command:
    <pre>DoCmd.OutputTo acOutputReport, "YourReportName", acFormatSNP, "YourFileName.snp"</pre>

    To display the snapshot report, you can use the Snapshot viewer control.
    Francois

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports and OLE Fields (2002)

    How then, to AUTOMATICALLy with code, insert in to an OLE field?
    Frank

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports and OLE Fields (2002)

    Don't use an OLE field, but use a snapshot viewer control.
    On your form, in design view, use Insert, ActiveX Control and select SnapShot Viewer Control 10.0
    In code, use :
    <pre>Me.SnapshotViewer.SnapshotPath = "YourFileNameWithPath"</pre>

    Francois

  7. #7
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports and OLE Fields (2002)

    Two things: I can only have one rpt at a time. There seems to be no record source.
    My client uses MS2000 will he have that control?
    Frank

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports and OLE Fields (2002)

    You don't need a recordsource.
    You can download the viewer at Microsoft Snapshot Viewer Available in Download Center.
    This is version 9. I don't know if version 10 is already available for download.
    Francois

  9. #9
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports and OLE Fields (2002)

    The snapshot viewer seems to hold only on report at a time but there is a record selector on the bottom.
    Frank

Posting Permissions

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