Re: Halting a Repeating Macro on Not Found

Hi Steve,
Yummy, its a lovely thing, and it works great! Thanks for all your help,
and for teaching me a new technique...the replace function in a query!
Kathy

"Steve Schapel" <schapel@xxxxxxxxxxx> wrote in message
news:Oe6PV2%233FHA.2196@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Kathy,
>
> It was the Update Query using the Replace() function that I was referring
> to. As I said, I tried it exactly as the syntax of your earlier message.
> I can't understand where the type conversion failure is coming into it.
> What version of Access are you using? Just as an experiment, on a backup
> copy, can you try replacing the ^ with a standard character rather than
> the carriage return, for example put this in the Update To row of the
> query...
> Replace([DESCRIPTION],"^","x")
> Also, can you please select SQL from the View menu in design view of the
> query, and copy/paste the SQL of the query into your reply. Thanks.
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> Kathy Webster wrote:
>> Hi Steve,
>>
>> What I would love help with is your alternate solution of the REPLACE
>> QUERY. That is what I got excited about in your reply, but I was unable
>> to make it work. Can you help me with that? I've never done one of them,
>> but it sounds fantastic!
>>
>> No, I am not trying to update any other fields at the same time.
>> The field is named DESCRIPTION, the data type is MEMO. The data in it
>> looks like this:
>>
>> A line of text^a second line of text^a third line of text^^a fourth line
>> of text.
>>
>> There may be one or more carets within the text OR NONE. That part is
>> inconsistent.
>>
>> Therefore, I feel this repeating macro solution is not the way to go,
>> especially since:
>> 1. it dies if there are NO carets, and
>> 2. it has to be executed repeatedly because of the 20 repetitions
>> limitation of the repeating macro.
>>
>> Thank you,
>> Kathy


.

Relevant Pages

  • Re: query for multiple results
    ... SELECT yourFields from yourTable WHERE ... Steve D ... "Tom Ellison" wrote: ... When i run the query, the parameter query dialog box opens. ...
    (microsoft.public.access.queries)
  • Re: on input form showing error message for duplicate entry.
    ... Steve, If you know so much, why don't just help her?? ... check for duplicates. ... proceed with your insert query. ... form to have any sql statement on one line (my opinion). ...
    (alt.php)
  • Re: filtering by month
    ... Steve S ... (I came; I saw; I stuck around.) ... Would you post the SQL of the query? ... you suggestion along with the criteria. ...
    (microsoft.public.access.queries)
  • Re: Check Box Question in Query
    ... I'll try to explain this a little better Steve. ... I have a query based on the ledger table that figures the last paid thru ... > "Joe Cilinceon" wrote in message ... I would like to have a will pay check box added that will exclude ...
    (microsoft.public.access.queries)
  • Re: RE-Post
    ... >I think you could try to use a query such as ... >Kathy wrote: ... wat i need is how to tell if that ... six month and annual increments. ...
    (microsoft.public.access.queries)