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...
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...
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
' 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
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...