WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Find And Replace text in a memo field

 
Goto page Previous  1, 2
   Home -> Office other -> General Discussions RSS
Next:  Table  
Author Message
TraciAnn via AccessMonste

External


Since: Jun 19, 2009
Posts: 8



(Msg. 9) Posted: Mon Oct 19, 2009 4:05 pm
Post subject: Re: Find And Replace text in a memo field [Login to view extended thread Info.]
Archived from groups: microsoft>public>access (more info?)

Hans,
>Could be a display issue if your Note field starts with a blank line
>before the actual text.

You were right again! Every Note for this project has a blank line at the top.


--
---
TraciAnn

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200910/1
Back to top
Login to vote
Hans Up

External


Since: Apr 20, 2009
Posts: 17



(Msg. 10) Posted: Mon Oct 19, 2009 4:05 pm
Post subject: Re: Find And Replace text in a memo field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

TraciAnn via AccessMonster.com wrote:
> Hans,
>> Could be a display issue if your Note field starts with a blank line
>> before the actual text.
>
> You were right again! Every Note for this project has a blank line at the top.

That was just an afterthought, TraciAnn. I happened to recall trying to
help a lady figure out why her form open failed without throwing an
error message. Turned out the form did open, but outside her monitor's
display area.

Perhaps you know that lady?

Nyuck, nyuck, nyuck.
Back to top
Login to vote
TraciAnn via AccessMonste

External


Since: Jun 19, 2009
Posts: 8



(Msg. 11) Posted: Mon Oct 19, 2009 6:05 pm
Post subject: Re: Find And Replace text in a memo field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks John!

>UPDATE (RequestNote INNER JOIN Request
>ON RequestNOte.RequestID = Request.RequestID)
>INNER JOIN LocationBridge
>ON Request.Location =LocationBridge.Location
>SET RequestNote.Note =
>Replace([RequestNote].[Note],"555-555-5555",[LocationBridge].[DDPhone])
>WHERE Request.ProjectTaskID In (98,99,100)
>AND RequestNote.Note Like "*555-555-5555*"

It worked PERFECTLY!

--
---
TraciAnn

Message posted via http://www.accessmonster.com
Back to top
Login to vote
TraciAnn via AccessMonste

External


Since: Jun 19, 2009
Posts: 8



(Msg. 12) Posted: Mon Oct 19, 2009 7:05 pm
Post subject: Re: Find And Replace text in a memo field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hans Up wrote:

>Perhaps you know that lady?

LOL.....Yes, I deserve that.....

The sad thing is..... I know it wont be the last time.

The good thing is.... The ribbing is a small price to pay for the wonderful
help you guys give.

Thank you so much!!!!

--
---
TraciAnn

Message posted via http://www.accessmonster.com
Back to top
Login to vote
Hans Up

External


Since: Apr 20, 2009
Posts: 17



(Msg. 13) Posted: Tue Oct 20, 2009 9:37 am
Post subject: Re: Find And Replace text in a memo field [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

TraciAnn via AccessMonster.com wrote:
> Hans Up wrote:
>
>> Perhaps you know that lady?
>
> LOL.....Yes, I deserve that.....
>
> The sad thing is..... I know it wont be the last time.
>
> The good thing is.... The ribbing is a small price to pay for the wonderful
> help you guys give.
>
> Thank you so much!!!!

You're welcome, TraciAnn. In the future, I'll see if I can offer you
help without yanking your chain. Smile

Cheers,
Hans
Back to top
Login to vote
Display posts from previous:   
       Home -> Office other -> General Discussions All times are: Eastern Time (US & Canada) (change)
Goto page Previous  1, 2
Page 2 of 2

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
 Office
  Office Other
 Security
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET |
  • IT Support