Recent content by greenfibres

Thanks for the 'clean' idea, I didn't know it existed. Finally resolved my issue with the following code =CLEAN(SUBSTITUTE(cellref,CHAR(13),", ")) :-)

Hi, still no joy with this one.

Thanks for your persistence, but no joy either.

Hi Remou Sorry, it took me a while to get back to this here's my code UPDATE Cust SET Cust.[Billing Address 2] = FindAndReplace([Billing Address 2],(Chr(13)+Chr(10)),", ") Unfortunately I just get the following message:- undefined funtion 'FindAndReplace' in expression Please note I'm using...

Access 97

I changed the BeforeUpdate as suggested, but with the same result. I can't find an OnDirty event in the properties... To recap, I basically want to record the last date a record is modified. The solution given works, unless I exit the current record by using the search option as mentioned...

Hi Robert (& Duane & PH) I have added the BeforeUpdate event and it works fine UNLESS the current record is exited via a search box that sits within the form. Then it gives the following message "Run-time error '3020': Update or CancelUpdate without AddNew or Edit" and if I click debug it takes...

Hi Binnit unfortunately you have missunderstood the scenario. 1 field (called Address_Line_2) has information stored in multiple lines, created by using carriage return - ie looks like this Keepers Cottage Brooklands Lane And I can't import it like that. It needs to be Keepers Cottage...

Hi Duane I can appreciate that close scrutiny is too much to ask. But, I guess there's maybe only one function in the code that trips up the solution that was given above - unfortunately I don't know enough to work that out. Although it does seem possibly related to a Bookmark function that's in...

Hi I have an Access '97 table that has addresses of contacts. Some of the fields have been populated from the Form that is bound to this Table, with second and sometimes third lines of text. I need to export these addresses to a totally different application (probably via Excel) but this new...

Hi I have an Access '97 table that has addresses of contacts. Some of the fields have been populated from the Form that is bound to this Table, with second and sometimes third lines of text. I need to export these addresses to a totally different application (probably via Excel) but this new...

Any one able to help?

That's great thanks. I tried it with a simple form and that works perfectly. I'm now trying to apply it to a much more complex form which doesn't even have a beforeupdate event proceedure! This may be a bridge too far, but I am posting the whole code below, and would appreciate your help in...

Hello all I have a table of contacts which I access through a form. I would like to keep a record of the last time any of the contacts fields (name, address, tel. no., email, etc.) were changed. (I only need 1 field to be changed for the last modified flag to be relevant) Any ideas? Thanks Jim

Hello again Strangely, when I go back to the query as suggested by Leslie, and then cut and paste PH's suggestion in, it works! :-) Thanks PH. The only thing to fix is when in the ContactFirstName the only entry is Mr. or Mrs. and nothing else - then I get an error in the Title field. Here's...