Search results for query: *

Thanks A! This is working perfectly now... You've been a lot of help! Thank you very much! Mitch

Neither code sample works.... yet - :) The original code deletes all instances of the target text, but then continues to loop until I break. No image is placed anywhere. The second sample of code replaces the first instance of the target text and loops, placing the same image over and over in...

When I debug, the cursor is on a different line every time. So it's replacing the first instance of the Text, then plugging the image into the same cell over and over.

Actually, it's now running but once it replaces one instance of the text it's searching for, it appears to loop indefinitely. Occasoinally I get an Object variable or With block not defined error as well, but only when there are no more instances of the target text found (or so it appears).

Thanks Loomah, when I run this macro it doesn't appear to do anything. It runs and nothing is replaced.

Thanks for the help A! One question, this appears to keep looping, and doesn't stop until I kill the macro. Any ideas?

Hi all, I'm trying to write a macro in Excel that will all instances of a word and replace it with an image. Any ideas? Is this possible? Ideally I'd like the image to be anchored to the cell that the word was in. Thanks, Mitch

I can't find this file anywhere. Can someone tell me where to find it?

Can you tell me what the specific file name is for this Adobe Sams MM file? Or is that literally it? Thanks, Mitch

Hey fstrahberger, that worked (or at least I'm getting results now). Thanks! I'll validate it and let you know.. Thanks again, MitchJP

they are local tables.

That didn't work. I tried something similar and had no luck.

No, I'm not seeing if they are equal. For example, I'm searching for "Australia" within "Once upon a time, I went to Australia". So normally I'd use LIKE "*Australia*". But in this case I don't want to compare it to a string like "Australia" but to a whole list of country names. Does this...

I'm trying to write a query using LIKE. I know how to do this when I'm comparing a field to a string, but how do I do this when comparing a field to another field? So where we do this: WHERE table1.field1 LIKE "*joe*" How do I do this: WHERE table1.field1 LIKE table2.field2 Any ideas...

Nevermind, I've figured it out. Somehow the data source for the form was erased... So I've resolved it. Thanks for the help!

Message: "Database can't find the field 'Current Level' referred to in your expression." It's worked before, but is now bombing once I've added the 2nd page (with other fields, none of them are Current Level)

Hi all, I had a form which consisted of a single page (one 'tab') and now I've added multiple pages. I now get an error for the following code: intCurrentLevel = Me![Current Level] This line of code assigns the value of 'Current Level' to the variable intCurrentLevel. I think the problem is...

I have a linked table that is sourced from another access DB on a different network drive. Under the table properties it is linked using the drive letter that I have mapped. When other users try to access the table, it errors out because they have the network drive mapped using a different...

Also, is it even possible to create a Powerpoint Object from within Access?? It doesn't seem to recognize powerpoint...

Hello, I'm trying to write a module that opens up a template in Powerpoint and inserts data into it (data pulled from an Access table). I've done similar things with MS Word using Form Fields and/or Mail Merges, but was wondering how I would do this with a Powerpoint document instead. I know...