form to display a preview of reports

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

Hi All

i'm trying to make a "Report Selection Form" that lists the name of the
available reports in a list box - when the user clicks on the report they're
interested in a description is displayed in a text box - all this works
fine,
however, i'ld like to add another field on the form - which contains a
picture of what they report will look like, but i can't seem to get this to
work.
Any ideas?

Regards
JulieD
PS i'm using Access 97
 
You can do it!
STEP 1)
=======
Create new table (EnumReports) with 3 fields:
1) - ReportName (key, text_255)
2) - ReportDescription (text_255)
3) - ReportFilePath (text_255)
Insert data for field 1 and 2.

STEP 2)
=======
For each report in your database make screenshot and save
as *.bmp
Put path and file name for each report into table
EnumReports -> field 3

STEP 3)
=======
Create form with:
- ListBox (ListReports)
- Label (ERepDescription)
- Image (RepPreview)

Set for ListBox:
RowSourceType = Table/Query
RowSource = "EnumReports"
ColumnCount = 3
ColumnBound = 1
ColumnWidths = 5;0;0 cm

Set for Image:
Picture = ""
PictureType = Linked

OnDblClick event on Listbox:
If Me.ListReports.ListIndex > -1 Then
Me.ERepDescription.Caption = Me.ListReports.Column(1,
Me.ListReports.ListIndex)
Me.RepPreview.Picture = Me.ListReports.Column(2,
Me.ListReports.ListIndex)
End If

Save form and test it!
 
Hi losmac

thanks for the info - but i can't get the control type of "image" to work on
the form - when i try it launches the browse window to locate a picture -
i've tried also with the unbound & bound object frames but can't seem to get
them to work either.

Also i need the pictures embedded not linked.

I would be grateful if you could provide further assistance.

Regards
julie
 
Back
Top