Can I import a print screen into an OLE Object table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Task: Providing suplies to nurses within our school system. Problem: 1/2
supplies ordered through district database, 1/2 supplies ordered through me
and sent by bag mail. I created an Access database to track supplies sent by
bag mail. Sending e-mails to nurses so they know how supplies are being
delivered. Problem: Pulling data from two databases to send e-mail to
several different nurses. Solution idea: Use Access to send e-mails reports
to each nurse using a print screen of district's database imported into an
Object file combined with bag mail data created on Access. Question is: Can
I use a print screen in an OLE Object table?
 
hi,
i've never done a print screen but i have put pics in a
access report.
I would guess you would have to paste the print screen
into paint and save it as a bit map.
then create a report in access with a image control. set
your image control's picture property to the file path of
your print screen's bit map. if you use the same name for
the bit map, you would never have to change the file path
in the image control. if you needed a record you could
save the print screen in paint twice, once with a date and
again with a standard name for the image control.
once you have the image control on the report in design
mode and situated like you want, put this code in the
report detail section in the on format event.

Private Sub Detail_Format(Cancel As Integer, FormatCount
As Integer)

Me![ImageControlName].Picture = Me![filepath]

End Sub

untested. theory only. should work.
post back if you need help.
good luck
 
Back
Top