Search results for query: *

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...

Hi PH Here's the code SELECT Left([ContactFirstName],InStr([ContactFirstName]," ")-1) AS Title, Mid([ContactFirstName],InStr([ContactFirstName]," ")+1) AS JustName FROM Customers WHERE (((Customers.ContactFirstName) Like "miss *" Or (Customers.ContactFirstName) Like "ms *" Or...

Hi PH Unfortunately I just get the message 'The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.' Can you check that again? Thanks Jim

Hi leslie Thanks for the reply 1. I tried the select query but the JustName field comes out as an error. Also the Title field will take the first initial from a multiple initial name like J R Hartley, so I ended up using the Where function This is the code I finished up with, but as I said...

Hello I have an Access table with separate fields for Title Firstname and Surname. Unfortunately many of the Firstname cells include a Title, so the Title is empty and the Firstname reads Mr Robert and the Surname reads Burns. How can I remove the Mr from the Firstname and place it in the...

I can't copy or do anything (other than delete the whole record) The record has a number of cascading relationships, so deleting is not the preferred option...... but one that looks increasingly like the most likely!