Recent content by mnepic

  1. M

    Using VBA to call a function within a module.

    For anyone reading this in future that wishes to replicate the code. The trick is to pass the sub the keyascii value. So. special_chars keyascii. Should work nicely! Have a nice day!
  2. M

    Using VBA to call a function within a module.

    I am sure there are numerous ways of accomplishing this to be honest. It is just that the code I presented works if tied directly to an event. It was more of a curiousity/learning thing for me to work out why it wouldn't work as part of a module. I will give it a try in work in the morning. I...
  3. M

    Using VBA to call a function within a module.

    And using Special_char 123 would work? Baring in mind that this functionality needs to ideally be built into the "on_key_Press" event. So that every time the user presses a key it is checked.
  4. M

    Connect to SQL server.

    Probably slightly late but I will post this regardless. When you download SQL Server 2008, look for the download that says "with tools". This gives you access to the management studio. As for connecting to SQL server via access, set up your odbc connections with the server address to be...
  5. M

    Using VBA to call a function within a module.

    Ok so situation is that, i have a CSV export written based of numerous text boxes. Due to CSV's being broken by characters such as "" and it being imperative that the outputted data is correct I need to ensure that special characters are not allowed. The is relatively simple to do by adding the...
See more
Back
Top Bottom