if you assume my documents is always c:\My Documents
sPathName = "c:\My Documents\*.*"
sFileName = Dir$(sPathName)
Do While sFileName > ""
'Process sFileName
sFileName = Dir$
Loop
will give each filename individually
Access does not wait on Call Shell to terminate execution before continuing to the next statement. Is there a way to force it to wait, or perhaps time wait for the next statement?
I cannot seem to locate a method to suppress alerts, displayed when either appending to or deleting from tables. Can someone please help with this?
Matt
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.