Hi,
This may or may not be an easy problem to solve as I'm relatively just
average with access.

What I have is a Memo field with html in it. It is a template I use
for selling items.

What I would like to do is run a query that will replace certain text
in the memo field using data stored in another access table but leave
the rest of the text "as is".

Any suggestions or let me know if you need more info...

Use the Replace function in your Update query:

UPDATE MyTable
SET MyField = Replace([MyField], "some old text", "some new text")
WHERE [MyField] LIKE "*some old text*"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"ndt" <(E-Mail Removed)> wrote in message
news:f34dd9a7-9aaa-4531-ad9e-(E-Mail Removed)...
> Hi,
> This may or may not be an easy problem to solve as I'm relatively just
> average with access.
>
> What I have is a Memo field with html in it. It is a template I use
> for selling items.
>
> What I would like to do is run a query that will replace certain text
> in the memo field using data stored in another access table but leave
> the rest of the text "as is".
>
> Any suggestions or let me know if you need more info...

I did this and my memo field has been drastically shortened. what
happened?


On Mar 18, 1:32*pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> Use the Replace function in your Update query:
>
> UPDATE MyTable
> SET MyField = Replace([MyField], "some oldtext", "some newtext")
> WHERE [MyField] LIKE "*some oldtext*"
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "ndt" <tama...@gmail.com> wrote in message
>
> news:f34dd9a7-9aaa-4531-ad9e-(E-Mail Removed)...
>
>
>
> > Hi,
> > This may or may not be an easy problem to solve as I'm relatively just
> > average with access.
>
> > What I have is aMemofieldwith html in it. It is a template I use
> > for selling items.
>
> > What I would like to do is run a query that will replace certaintext
> > in thememofieldusing data stored in another access table but leave
> > the rest of thetext"as is".
>
> > Any suggestions or let me know if you need more info...- Hide quotedtext-
>
> - Show quotedtext-

We aren't there. We can't see what you're looking at.

"Drastically shortened" could mean so many different things. Care to
provide a real world example?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ndt" <(E-Mail Removed)> wrote in message
news:f81883a3-6bec-4ca2-8165-(E-Mail Removed)...
I did this and my memo field has been drastically shortened. what
happened?


On Mar 18, 1:32 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> Use the Replace function in your Update query:
>
> UPDATE MyTable
> SET MyField = Replace([MyField], "some oldtext", "some newtext")
> WHERE [MyField] LIKE "*some oldtext*"
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "ndt" <tama...@gmail.com> wrote in message
>
> news:f34dd9a7-9aaa-4531-ad9e-(E-Mail Removed)...
>
>
>
> > Hi,
> > This may or may not be an easy problem to solve as I'm relatively just
> > average with access.
>
> > What I have is aMemofieldwith html in it. It is a template I use
> > for selling items.
>
> > What I would like to do is run a query that will replace certaintext
> > in thememofieldusing data stored in another access table but leave
> > the rest of thetext"as is".
>
> > Any suggestions or let me know if you need more info...- Hide
> > quotedtext-
>
> - Show quotedtext-

Originally it was truncated to a little over 300 characters but now
i'm seeing the whole thing, its working like a charm. Thanks so much,
this has literally saved me thousands of hours of work manually doing
it

On Mar 18, 2:44*pm, "Jeff Boyce" <nonse...@nonsense.com> wrote:
> We aren't there. *We can't see what you're looking at.
>
> "Drastically shortened" could mean so many different things. *Care to
> provide a real world example?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "ndt" <tama...@gmail.com> wrote in message
>
> news:f81883a3-6bec-4ca2-8165-(E-Mail Removed)...
> I did this and my memo field has been drastically shortened. what
> happened?
>
> On Mar 18, 1:32 pm, "Douglas J. Steele"
>
>
>
> <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> > Use the Replace function in your Update query:
>
> > UPDATE MyTable
> > SET MyField = Replace([MyField], "some oldtext", "some newtext")
> > WHERE [MyField] LIKE "*some oldtext*"
>
> > --
> > Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> > (no e-mails, please!)
>
> > "ndt" <tama...@gmail.com> wrote in message
>
> >news:f34dd9a7-9aaa-4531-ad9e-(E-Mail Removed)...
>
> > > Hi,
> > > This may or may not be an easy problem to solve as I'm relatively just
> > > average with access.
>
> > > What I have is aMemofieldwith html in it. It is a template I use
> > > for selling items.
>
> > > What I would like to do is run a query that will replace certaintext
> > > in thememofieldusing data stored in another access table but leave
> > > the rest of thetext"as is".
>
> > > Any suggestions or let me know if you need more info...- Hide
> > > quotedtext-
>
> > - Show quotedtext-- Hide quoted text -
>
> - Show quoted text -