Search results

  1. Y

    What's your best/worst joke?

    There's no smoke without fire!
  2. Y

    Solved Locked DB file, cannot delete; cannot open user file

    Just a suggestion, ensure no other users are using your your FE, Reboot your pc not re-start and open up the folder and locate the locked file and hopefully you should now be able to delete it. Also might be worth checking your task manager to ensure not access programmes are running. I am a...
  3. Y

    SentOnBehalfOfName

    Surely you meant , jumbled. Its an age thing. Regards Ypma
  4. Y

    SentOnBehalfOfName

    Kitty, I posted a similar post some time ago which was solved by members of this forum. You search" How to Make Replies to Emails sent from Ms access 2019 Go to Another Address in Outlook" you should be able to view the replies I received . Regards Ympa
  5. Y

    Solved What is the bar to the left of the form?

    Hello Danjo, if you click the black arrow left top it should reveal all your access object , table, forms etc. From there you open the object in the desired mode. Hope this is clear Ypma
  6. Y

    Solved Extract text from String ,Name and telephone number

    CJ_London . Thanks you for the function , It produced the correct result that I was after and I will retain it for further reference . Regards Ypma
  7. Y

    Solved Extract text from String ,Name and telephone number

    Thank you Galaxiom: The SolicitorName expression you produced gave me exact result I needed . I have learnt something new , I intend to see if i can get CJ_London functions to work, to add to my knowledge , They say " a little knowledge is dangerous" !!
  8. Y

    Solved Extract text from String ,Name and telephone number

    Thank you CJ_London. I will implement you suggestion tomorrow, as I need my beauty sleep. Regards Ypma
  9. Y

    Solved Extract text from String ,Name and telephone number

    Mark k, Is it something like this Legal: split("solictors", " : ")(0) ? as I am not sure where to insert your solution . Regards Ypma Note, I am not a programmer ,but dip my feet in occasionally
  10. Y

    Solved Extract text from String ,Name and telephone number

    Thank you Gasman, the field in the subject query solicitor, is produced from a combo box on the form, this combo box has a lookup table for its source .I fully except plog's comments , but this is the problem I am face with and hope you can tell if its possible to create another field in the...
  11. Y

    Solved Extract text from String ,Name and telephone number

    More guidance is requested . I have a field in Select query solicitors, which produces the name of the solicitor and the telephone number .My requirement is to be able extract only the solicitors name . I have tried various combination using left function and is numeric to remove the numbers...
  12. Y

    Solved Extracting first name if more than one name.

    Perfect thank you and thanks to the other experts who have taken the trouble to give me constructive suggestions. Regards Ypma
  13. Y

    Solved Extracting first name if more than one name.

    You are right , I should have admitted that I could not complete your suggestion in post 6. Can I push my luck and request you complete . KnownAs: IIf(InStr(Nz([FirstName],"")," ")=0,... Regards Ypma
  14. Y

    Solved Extracting first name if more than one name.

    I could not make the solution in post 6 work as i did not know how to complete the expression. and tried other ways to achieve my goal. As stated I require both fields to produce the same result Regards Ypma Within the client table the first applicant has a field , FirstName and the...
  15. Y

    Solved Extracting first name if more than one name.

    Thank you for your interest, yes I have a field name FirstName and for the second client FirstName2 . My end game is to to be able to joint the two and have salvation Dear John and Kate. If there is not a second client then Just dear John.. Regards Ypma
  16. Y

    Solved Extracting first name if more than one name.

    arnelgp: Your solution produce the right result, however when I changed to the following KnownAs2: Left$([FirstName2] & " ",InStr(1,[FirstName2] & " "," ")-1) the result is blank The only change is the addition of the numeral 2. The first name is required for a salutation eg. Dear John...
  17. Y

    Solved Extracting first name if more than one name.

    theDBguy: You answered my question , however I did not consider the possibility of only one name or even none in the first name field . Do I have to add an is null in the expression you provided or a double IFF . Your further input would be appreciated Regards Ypms
  18. Y

    Solved Extracting first name if more than one name.

    theDbGuy, Once again a question has been asked and you have provided the perfect solution. Thank you. Regards Ypma
  19. Y

    Solved Extracting first name if more than one name.

    The database I am working on has a field named Firstname and within that field one or two names can be inputted, I wish to extract only the first of these names. I entered the following into the field of a the query. KnownAs: Left([FirstName],InStr([FirstName]," ")-1) The result as shown below...
  20. Y

    Solved Dcount with criteria of <= date()

    Arnelgp thank you , I was comma blind , when changing the semicolons to a commas problem solved , In my example there was a typo in that an extra i was added at the end of my Dcount . thanks again for your prompt solution . Regards Ypma
Top Bottom