Search results

  1. A

    Conditional Function

    Nice one. I think I can slot that in somewhere!
  2. A

    Conditional Function

    I'm using the function below to send email messages internally, and it works really well. However, I don't know the syntax to add into this which would operate like; IF Query12345 is empty THEN don't send the email ELSE send the email. How would I amend this? Public Function SendEmailAWALKE()...
  3. A

    Find and Replace on Multiple Matches

    Yes, long text field. I got even more creative this morning by invoking the function twice. Once to do an initial pass which amended the allergens, and a second which then got rid of any duplicate words introduced by the first process!
  4. A

    Find and Replace on Multiple Matches

    Excellent, I've made that amendment and it works like a charm - thank you!
  5. A

    Find and Replace on Multiple Matches

    I'm hitting a bit of an unusual problem... The function works, but not all the time, and I can't figure out why! In this screengrab I've highlighted the word 'egg', showing where it's been successfully capitalised, but then where it hasn't...
  6. A

    Find and Replace on Multiple Matches

    Yes, the penny dropped after my initial confusion. That works brilliantly. Thanks to all who have contributed.
  7. A

    Find and Replace on Multiple Matches

    Don't worry, solved!
  8. A

    Find and Replace on Multiple Matches

    Sorry, you'll have to be more explicit - I'm not quite with you!
  9. A

    Find and Replace on Multiple Matches

    Yes, ideal. Especially as it's inevitably not as easy as I first thought... How would it be done in the function?
  10. A

    Find and Replace on Multiple Matches

    Ok, makes sense. I can strip these out higher up the chain, so to speak which will then mean it runs properly.
  11. A

    Find and Replace on Multiple Matches

    Getting there; it seems to work, but then hits this error: https://alexfwalker.tinytake.com/tt/NDYxNTc1NV8xNDYzMDU5OA I wonder if there's some kind of character in that ingredients list which is causing an issue?
  12. A

    Find and Replace on Multiple Matches

    Inevitably, I've just changed what I'd like to do, but can't figure out the syntax in the function to do it. I now have two columns in the tblAlllergenWords; AllergenWord and AllergenWordReplacement. This is so that I can do clever things like find the word 'shrimp', matching on AllergenWord...
  13. A

    Find and Replace on Multiple Matches

    I've just tried this in my database and it works perfectly - thank you!
  14. A

    Find and Replace on Multiple Matches

    Correct, the string is essentially the long bit of text that you'd see on the back of literally any packet of food, listing the ingredients.
  15. A

    Find and Replace on Multiple Matches

    This is exactly what I'm after! How did you do it?
  16. A

    Find and Replace on Multiple Matches

    Yes, but I don't know how to tell the Replace() function to go and look at a list of values in a query or table. Theoretically speaking, I could have a query with a column for every possible allergen, each with an individual Replace(), it's just not every elegant!
  17. A

    Find and Replace on Multiple Matches

    I am working with allergen information, based on submissions from manufacturers. Believe it or not, manufacturers are sloppy and they don't do what they ought to, which is to bold, capitalise or underline allergens. So, I'd like to be able to (in layman's terms) look at the Long Text field which...
  18. A

    Instr too complex!

    Working like a charm!
  19. A

    Instr too complex!

    Problem... I went to set this up and had the message 'Cannot join on Memo, OLE, or Hyperlink Object', as of course, [ingredients] is a Long Text field. Back to the drawing board?
  20. A

    Instr too complex!

    Yes, the allergens are a distinct list in a table. How would I do a non-equi join?
Back
Top Bottom