We want users to be allowed to download Adobe Reader and Flash, and we have added adobe.com to the proxy allow list. However, they are still getting a server error from Adobe Download Manager and the connection is never completed to start the download. I ran a packet capture and all the IP...
Sorry, I wasn't quite clear. The variable "rs.GetString" provides the full text output of the query, which is a list of websites. That list is output from Access and written to the textfile. It shows up in that file as a string of text divided only by carriage returns. In VI, the character...
I have a vbscript that connects to an Access 2007 database, exports data from a query, and writes it to a text file. The text file is then downloaded onto our web proxy device, which is Linux-based.
Access adds a carriage return (cr) at the end of each record returned by the query. But the...
I'm a bit confused on how to properly format a validation rule for an Access form. The rule I've been using to exclude special character is:
Is Null Or Not Like "*[!((a-z) or (0-9) or (.))]*"
I copied that from a site online and I'm not sure why the double-negative is necessary, but it...
Found it:
Function Runfile()
Application.FollowHyperlink "C:\database\dataexport.vbs"
End Function
Unfortunately, it doesn't work because the VBscript needs access to the database that it can't get when the database is open. So, basically, I can't call that script from within the database. I...
I have written a vbscript to take data from an MS Access database and export it to a text file. The script runs several queries and divides the output with headers. No problem with the script, but I had planned to have it run as a scheduled task.
My manager would prefer it run by the Help Desk...
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.