Recent content by alistercruickshanks

  1. A

    VBA to check if textbox only contains A-Z, a-z, hyphen and spaces

    Thank you so much. This is exactly what I was looking for. I was very close at one point, but had the Not in the wrong place and why i was struggling. This works perfect!
  2. A

    VBA to check if textbox only contains A-Z, a-z, hyphen and spaces

    Thank you very much everyone this is great and gives me a lot of direction to go on. Really appreciate the advice.
  3. A

    VBA to check if textbox only contains A-Z, a-z, hyphen and spaces

    I may need to test those, a good point. I think from memory standard quotes are ok, so can add in, but smart quotes I may need to use replace for
  4. A

    VBA to check if textbox only contains A-Z, a-z, hyphen and spaces

    Hi, I am struggling trying to check if a textbox contains characters that are Not A-Z, or a-z or a Hyphen or a Space Our access system exports names to an accounts system that breaks if a foreign character is in the name, like accents. The solution would be to warn users with a msgbox...
  5. A

    Adding a line to DoCmd.TransferText

    It works, thank you so much. But this has now generated a new question! The addresses contain new line characters which are splitting the rows. But actually only the first line is probably needed as it looks like Royal Mail auto fills the town. Will a loop and using left work between these...
  6. A

    Adding a line to DoCmd.TransferText

    Hi, I am hoping someone can help as I am struggling with this and my knowledge of VB is limited! We are using the new Royal Mail DMO system that basically imports tab delimited text files for auto printing tables. Our database has the data, and indeed I can easily export the data in the right...
See more
Back
Top Bottom