Recent content by Number11

  1. N

    Solved Query to show difference in telephone and email stored in a table

    So i need to have a query to show any customers details that have changed in a master table v a local table Cus_ID Phone_1 Phone_2 Email I have the same fields in both tables i need to have the query look at Master Table (Customer_Master) and Bring Back any records that do not match the Local...
  2. N

    Solved Update Query to Add Missing 0 at the front of a telephone number?

    Is it possible to have an update query to add a missing 0 to a telephone number
  3. N

    Solved Delete Query - Not working

    Worked 100% :)
  4. N

    Solved Delete Query - Not working

    Hello, I am trying to delete all records within a Table greater than the date in another table. I have set the criteria to > [Delete_SetDate].[AppDate] The date in the table is set as 31/03/2022 - i am getting this error if i use this criteria it works >#31/03/2022# But i need to have...
  5. N

    Calling this from Module creates Windows Security to block it from running

    Yeah thats why i have to use the bat file to do that, any other way to call a bat file to run other than SHELL?
  6. N

    Calling this from Module creates Windows Security to block it from running

    it copies the same database and replaces the current one, so has to be done via cmd. seems anything that is called using "SHELL" is now being blocked by windows security
  7. N

    Calling this from Module creates Windows Security to block it from running

    ' runs the batch file shell Test.cmd This is now causing the operation to fail and windows security is blocking it from running. is there another way to run a bat file from VBS/modules
  8. N

    Updating the front end on local server

    LOVING THIS HOW DO I GET IT TO RUN IN X64 BIT ACCESS
  9. N

    Ms Access - backend speed Inprovment

    Thanks we now have many users connected through VPN, so we are experiencing slowness caused by home working and VPS.
  10. N

    Ms Access - backend speed Inprovment

    Hi, I am trying to gain the understanding on how changing these settings can improve the speed..
  11. N

    Solved Exporting to csv file loses number format

    dont understand as then if i open the file in excel and change the format its all correct?
  12. N

    Solved Exporting to csv file loses number format

    I am trying to export a table to a csv file but the numbers are showing up like this Guess i need to have some formatting added to a query?
  13. N

    Solved Send email from ms access vbs from another email address?

    sorted this added code to close outlook and load a different profile
  14. N

    Solved Send email from ms access vbs from another email address?

    Is it possible to have the code changed to send the emails from a different outlook email address. this is my code.. I get this to work by creating a second profile in outlook and select that and it send correct but looking for a way now to have the code do this so the user doent need to do...
Top Bottom