Replies

RetiredGeek,

I implemented your code and it actually does EXACTLY what I wanted

Thanks so much!

Well that just seems like to much work Thanks for all the help everyone! I appreciate it….

You could try the following which would check for the access value being null as Wendell mentioned and also for the access value having a value but the picture no longer in that location.

Code:

Private Sub Form_AfterUpdate()
On Error Resume Next

if Me.PhotoDropShadow = Null or DIR(Me.PhotoDropShadow) = Null Then
  Me.PhotoDropShadow.Picture = “C:…NoImage.jpg”
‘*** Replace … above with appropriate path info ***
Else
  Me.pPhotoDropShadow.Picture = Me.PhotoDropShadow
Endif

‘*** Repeat If test logic for each of the following ***

Me.pPhotoFramed.Picture = Me.PhotoFramed
Me.pPhotoFramedMatted.Picture = Me.PhotoFramedMatted

Exit Sub

:cheers:

The path will never be null and I don’t want to overwrite what is in the field with the “noImage.jpg” path. I just want it to show the “noimage.jpg” or just have it be blank. Is that possible?

Is your field where the full path is stored “Null” if there is no image? If so, or if it is an empty text string, you could test for that in the code, and set the path to Noimpage.jpg if the result of the IF statement is true. It appears you would need to check each image path based on the code you are using.

No. The full path is in all of the fields whether the picture exists or not.

Hi Patt,

Thanks! I’ve been quite sick, so I apologize for not thanking you for your help earlier.

I’ll see if I can get this to work and then come back and let you know my results..

-Leslie

Hi Patt,

Yes, that sounds exactly like what I am trying to do. I just don’t know how to write the proper code to do it!

Can you help lead me in the proper direction?

So it’s about 3 years later and I found myself working on the same issue! Of course, the first thing I do is check out the Lounge and see how I did it last time.

Steve… I didn’t get notification of your response back in 2006, so I didn’t see your wonderful response.

I just implemented it and THANK YOU I know I am a little late in thanking you, but I really appreciate all your help.

-Leslie

Hans,

Thank you so much for that link to Karen’s page! I came on today looking for a way to create a spreadsheet of the names of the tens of thousands of images I have in a folder and this is perfect!

Uh-oh….

I just hit a variable:

Charlton Heston as Maj. Matt Lewis, Ava Gardner as Baroness Natalie Ivanoff and David Niven as Sir Arthur Robertson in 55 Days at Peking

Hmmmm……
I would like to have
55 Days at Peking
Charlton Heston, Ava Gardner and David Niven
Maj. Matt Lewis,Baroness Natalie Ivanoff and Sir Arthur Robertson

I’m guessing I’m going to have to do these one’s manually… Any other suggestions?

Have I told you lately how much I love you

That is exactly what I needed and it worked beautifully..

So Search & Find do the same thing? Are there any differences?

You guys Rock!!!!

Thank you so much… I would have had to do this manually (ouch) if it wasn’t for your help…

Hans~ You have personally helped me with a lot of VBA in the last few years, I really cannot tell you how much I appreciate your help & skill.

Thanks! I didn’t think of that

(I’ve never been very good at the subject of grammer – so an apostrophe makes a word possesive?)

Thank you! I will try this option!

Hans you are the man!

Thank you so much for all your help, it seems every time I have ever asked a question on WOPR you are right there to help me out.

Thanks for the tip on not selecting the bookmark. I’ll alter my other code for more efficiency….

Thanks Hans! I’ll take a look at those. I never thought of keeping it in Word…

I’ll come back with any questions…