Image Handling Problems...

[Matt]

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

[Larry Linson]

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

[Matt]

Thank you Larry.