By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Image Handling Problems...

P: n/a
Thank you for trying to help.

I am a newbie trying to learn access. I am creating a database in
access97 with few picture fields in it. After some research I decided
to use the famous "External File" type suggested by Larry Linson.

I decided to go into datasheetview of the table and manually fill up
the directory root for the files. Everything works fine. My problem
here is there are some records which don't have a picture to it. So
when i view the records in a form, those records that don't have a
picture on it are not blank but still hold the previous records
picture. Is there any way i can refresh the form or something. I know
zero coding :(

Also, when i try to view the records in a report usin the On Format
event, the code gives me an error message that it doesn't recognize
the field name.

Any help is appreciated.

Thanks again, Matt
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The generally used method is, for those empty pictures, use code similar to
the code (e.g., copy and modify only slightly) that is used to set the
Picture property, but instead set it to the path and filename of a one-pixel
white image. It'd be something like this (untested aircode):

If IsNull(Me!yourimagefield) Then
Me!imgControlname.Picture = <pathandfileofonepixelimage>
Else
Me!imgControname.Picture = Me!yourimagefield
End If

"Matt" <yo*******@yahoo.com> wrote in message
news:fe**************************@posting.google.c om...
Thank you for trying to help.

I am a newbie trying to learn access. I am creating a database in
access97 with few picture fields in it. After some research I decided
to use the famous "External File" type suggested by Larry Linson.

I decided to go into datasheetview of the table and manually fill up
the directory root for the files. Everything works fine. My problem
here is there are some records which don't have a picture to it. So
when i view the records in a form, those records that don't have a
picture on it are not blank but still hold the previous records
picture. Is there any way i can refresh the form or something. I know
zero coding :(

Also, when i try to view the records in a report usin the On Format
event, the code gives me an error message that it doesn't recognize
the field name.

Any help is appreciated.

Thanks again, Matt

Nov 12 '05 #2

P: n/a
Thank you Larry.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.