Search results

Okay, it did it. That's extra work. I am to let it go for now. I have spent way too much time.

Okay, tried it but when I added an image to 23, the paperclip didn't appear.

Nope, tried both--didn't work. I know there were a discussion on images a while back but I can't find the post. I think that's why they had me to use the text box with Winding.

Are you saying like: =IIf([EventAttachment] Is Not Null,".",Null)

Nope, that's not what I want. I'm trying to do display a paperclip image if the record has images attached therefore you won't have to open the image to see if any images are attached.

Yep, that's what happening. So, image control source doesn't work like textbox control source. The textbox is doing it correctly--it's just not the image I want.

It has to have something to do with the image. I even change the form from Continuous to Single and the image operated the same. Now, I went and used a textbox and put this in the ControlSource: =IIf([EventAttachment] Is Not Null,".",Null) It works! I will just stick with the text and use...

No. You know I read somewhere about image control problems or something. When you read so many books and stuff you forget a lot of it or where you saw it. Anyway, attached is an example of what I am trying to do--sort of. I got this from this site.

Well, I wish I could post this db on web, but he said no--the paper clip image is not that important. I guess I have to scrap this and look for a character I can use with a text box to replace the paperclip image. Thanks for your help!

False when no image. True when an image.

Still displaying the paperclip image on all the records.

Nope, not working. When I go to the record that has an attachment, it highlight all the other records until I move off the one that has an attachment. Also, I tried putting zero in as the criteria on a query and get the following error message: Data type mismatch in criteria expression...

See I wouldn't have guess that! Still learning. Anyway, when there are no attachment the message box is blank; where there is an attachment the message box displays the attachment name. And, the icon still displays either way. Thanks!

How does that apply to my code?

No, I do not get an error. It just displays all the images for each record whether the record has an error or not. How do you Msgbox the DLookup()? Thanks!

I am trying to say that if the record has an image attached display the image icon and if not display nothing. The code displays the icon on each record. Here's the code: Private Sub Form_Load() If IsNull(DLookup("EventAttachment", "Event", "EventID = " & Me.txtEventID)) Then...

Hi boblarson, I did this but I am having trouble when I delete a Note it leaves a blank/empty field in the EventNote table. I added a delete button to the EventNote form, but when it deletes it deletes the Event information instead of just deleting the Note. Did I set up the EventNote table...

I am using Access 2007. How do I set up a list box to view attachments? Right now I have it set up where I enter a path and file name. The DisplayImage code I got works great for images, but the problem is Word and PDF documents are too big or it does not recognize it. So, I am playing...

Thanks DCrake, Of the 3,000 records about 1,300 have attachments. Most of the attachments are one document--image or business card. Less than 500 will have many attachments; others have no attachments. Now knowing that, would you create subfolders for each company that has attachments or put...

I have a db that has about 3,000 records. Many of the records will have documents attached (Word, PDF, and images). All the attachments will be saved in a directory called Attachments. The document will be renamed using the ID number—e.g., 0001__bio, 0001__business card and so on. Currently...