Number11's latest activity
-
NNumber11 reacted to Pat Hartman's post in the thread Solved Query to show difference in telephone and email stored in a table with
Like.
Create a query that joins the two tables on Cust_ID. Select the four fields from each table Then in the criteria lines, compare each... -
NNumber11 posted the thread Solved Query to show difference in telephone and email stored in a table in Queries.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...
-
NNumber11 replied to the thread Solved Update Query to Add Missing 0 at the front of a telephone number?.Did the job thanks
-
NNumber11 reacted to jdraw's post in the thread Solved Update Query to Add Missing 0 at the front of a telephone number? with Like.
I'm sure it's possible, but how do you determine that 0 is missing? This may apply '...
-
NNumber11 posted the thread Solved Update Query to Add Missing 0 at the front of a telephone number? in Queries.Is it possible to have an update query to add a missing 0 to a telephone number
-
NNumber11 replied to the thread Solved Delete Query - Not working.Worked 100% :)
-
NUse DlookUp() function ...
-
Ndelete yourTable.* from yourTable where [Product Name] Like "TTmaxDataServ" And dateField > (select top 1 appDate from delete_setDate)
-
NHello, I am trying to delete all records within a Table greater than the date in another table. I have set the criteria to >...
-
-
NNumber11 reacted to Pat Hartman's post in the thread Calling this from Module creates Windows Security to block it from running with Like.
Have you tried FollowHyperlink? I don't know if it works for .exe or .bat files.
-
NNumber11 reacted to The_Doc_Man's post in the thread Calling this from Module creates Windows Security to block it from running with Like.
Don't know if you can manage this, but consider using the Shell command on a file in a trusted location.
-
NNumber11 replied to the thread 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?
-
NNumber11 reacted to arnelgp's post in the thread Calling this from Module creates Windows Security to block it from running with Like.
can yo use VBA.FileCopy? /// be warned that you cannot Replace the running db (the one that has this code)
-
NNumber11 replied to the thread 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...
-
NNumber11 posted the thread Calling this from Module creates Windows Security to block it from running in Modules & VBA.' runs the batch file shell Test.cmd This is now causing the operation to fail and windows security is blocking it from running. is...
-
