When no images exist (1 Viewer)

BillyMac · May 27, 2004

I have looked through 18 pages of forums and have not found an example of what I want to do. The help I have received from this forum has been tremendous so far. I have a form with a subform that displays an image and everything works fine. The problem I have is that not all of the records on the main form have images related to them. Where there are no images for that record I want to display a message "there are no images related to this record" in the image field or somewhere like a pop-up message box or something like that. It is probably quite simple for you guys out there but I just can't get my head around it. Any help would be appreciated.

WayneRyan · May 27, 2004

Billy,

You could use the form's OnCurrent Event to do
something like:

Code:

If IsNull(Me.PictureField) Then
   Me.PictureField = "C:\SomeFolder\SomePicture.jpg"
   Me.Refresh
End If

"SomePicture" could be whatever image you desire.

I don't have any databases with pictures so this is
just an idea. Maybe this response will bring some
attention from others.

Wayne

BillyMac · Jun 1, 2004

Wayne,

Thanks for that. I will give it a try.

Billy

Oldsoftboss · Jun 1, 2004

What i have done is to place a label on the form where the image is and set it behind the image. That way, when there is no image, the label is visible.

See attachment for more

Dave

Oldsoftboss · Jun 1, 2004

Or you could have looked here:
http://www.access-programmers.co.uk/forums/showthread.php?p=258792#post258792

BillyMac · Jun 1, 2004

Dave,

Tried that but the label is visible when there is an image. I don't have any images embedded in the form they are linked via an image path to a folder on the harddrive. Is there something I have missed

Billy

IanMilly · Jun 1, 2004

BillyMac said:
I have looked through 18 pages of forums and have not found an example of what I want to do. The help I have received from this forum has been tremendous so far. I have a form with a subform that displays an image and everything works fine. The problem I have is that not all of the records on the main form have images related to them. Where there are no images for that record I want to display a message "there are no images related to this record" in the image field or somewhere like a pop-up message box or something like that. It is probably quite simple for you guys out there but I just can't get my head around it. Any help would be appreciated.

you could always just create an image the same size as the other images with the message displayed in it, crude but effective.

BillyMac · Jun 1, 2004

Dave,

Ignore my last message - I forgot about the bring forward send back function on the format menu.

Billy

Oldsoftboss · Jun 3, 2004

Good to see you worked it out

Dave

qootea · Sep 16, 2006

Hi. I am also attempting to display the picture by linking the file like in the example database. What I really want to do is like the Change picture button in the sample database, I would like to have a button which when clicked will open the file window. But when I put the code into my own database the compiler tells me that 'Dim OFN As OPENFILENAME' is user-defined type not defined. What does this mean? How can I fix this problem?

Thank you.

Oldsoftboss · Sep 19, 2006

Have you copied the module from the sample database?

When no images exist (1 Viewer)

BillyMac

Registered User.

WayneRyan

AWF VIP

BillyMac

Registered User.

Oldsoftboss

AWF VIP

Attachments

Oldsoftboss

AWF VIP

BillyMac

Registered User.

IanMilly

Registered User.

BillyMac

Registered User.

Oldsoftboss

AWF VIP

qootea

New member

Oldsoftboss

AWF VIP

Similar threads

Users who are viewing this thread