Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mlev
  • Order by date
  1. mlev

    Proxy Server blocking Adobe Download Manager

    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...
  2. mlev

    Access 2007 query export - add line feed

    Very cool. I'll have to read up more on the adodb.recordset. :) Ay rites lolcode?
  3. mlev

    Access 2007 query export - add line feed

    tsuji - My apologies -- I completely overlooked the replace line in your file. Yes! Thank you! Ay rites lolcode?
  4. mlev

    Access 2007 query export - add line feed

    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...
  5. mlev

    Access 2007 query export - add line feed

    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...
  6. mlev

    Validation Rule to allow hyphen, exclude other special characters

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

    Can a vbscript be called from an MS Access button or macro?

    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...
  8. mlev

    Can a vbscript be called from an MS Access button or macro?

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

Part and Inventory Search

Back
Top