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 wOOdy-Soft 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: *

  1. richardrekos

    how to extract line from text file

    I need to extract a line from a text file and write that line to a new text file. I want to do this for each line that contains the string "AB". Does anyone know how to do this? Thanks, Rich
  2. richardrekos

    How to delete files via scrip

    I need to delete all files in a folder w/ 'qmtext' in the filename. Does anyone know how this can be done? Cheers, Rich
  3. richardrekos

    Query to compare 2 tables

    I have 2 small tables (one column) that contain email addresses. I want to compare the tables to find out which email addresses match up between the 2 tables. Is there a simple way to query for this? Thanks, Rich
  4. richardrekos

    Anyone know how to use Goldbox to delete records?

    I need to delete 16,000 + bogus activities from the activity list. The activity list can only delete in chunks of 500. I'd like to axe all 16,000 at once. Any ideas?
  5. richardrekos

    Script to add additional static ip addresses

    Does anyone know how to script the addition of static ip address (as in the advanced tcp/ip settings tab of the tcp/ip properties)? I can only find examples for adding a single static ip, netmask, gateway... Thanks, Rich
  6. richardrekos

    Set file permissions w/ asp.net

    Does anyone know how to set file permissions via asp.net? I have a page that allows me to upload files, but I want to be able to set the permissions on the file after I upload it. Any ideas? Thanks, Rich
  7. richardrekos

    Send HTML mail from ASP.NET Page

    I cannot figure out how to send messages in HTML format. My code is below, do I need something else besides objMail.BodyFormat = System.Web.Mail.MailFormat.Html? Thanks, Rich <script language="vb" runat="server"> Sub sendmessage_Click(sender as Object, e as EventArgs) Dim objMail as New...
  8. richardrekos

    Select rows where address is not null

    Hi All, I an a newbie to SQL queries and need to select rows from a contact DB where Address, City, State, Zip aren't null. I hope I am using the right lingo. Basically, if any of those fields are blank, I don't want it. I tried using city not is null, zip not is null, etc. but the query...
  9. richardrekos

    Query based on zip code

    I am a newebie that needs to query a database of addresses, using zip code as the criteria. Problem is that there are 700 zip codes in this case. Does anyone have any suggestions on how to do this? It would take for ever to do Select * from table1 where zip = 'xxxxx' or 'xxxxx"... Thanks! Rich
  10. richardrekos

    Script to delete old files

    Does anyone know how to script the deletion of old files? I specifically want to delete files that contain "LPT$VPN" in the file name and are older than 3 days. Thanks in advance. Rich
  11. richardrekos

    Loops to start over?

    Well, thaks to helpful direction, I am just about there. Any ideas on how to start this script from the begining after the user clicks OK on the popup box for Sub rich()? strComputer = InputBox("Enter computer name and click ok. If you don't know the name of your computer, click cancel")...
  12. richardrekos

    Help with If statement

    I am trying to use an If statement for the first time. I want to run a Sub based on if the user clicks OK or Cancel. The Sub "rich" runs regardless of whether I click OK or Cancel. What am I doing wrong?? Also, is there a way to go back to and start the script over after the Sub "rich" is...
  13. richardrekos

    Send attachment via CDO

    I need to send an attachment w/ where the filename is the name of the machine (.xml). Is it possible to use a variable like strMachine and use that in the filename? I don't know the correct syntax... Set objEmail = CreateObject("CDO.Message") objEmail.From = "richard.rekos@questionmark.com"...
  14. richardrekos

    run .exe on multiple computers

    I am trying to run an .exe on several machines using a dictionary file. When I run this script, the .exe only runs locally on my machine. Can anyone tell me where I went wrong? Many thanks Option Explicit Dim objShell, objDictionary, objFSO, objTextFile, i, strNextLine, objItem Const...
  15. richardrekos

    Automtically choose &quot;yes&quot; when prompted

    I have a very simple script that runs an .exe. The problem is that the installation program prompts me w/ a question and I must choose yes to continue. Is there any way to add a line to the scipt so that "yes" is chose automatically? Many Thanks, Rich
  16. richardrekos

    Syntax problem

    I am trying to use an input box to enter a value. I need a username to be entered and then this username (strUser) should be used in line 5 of the script below. I can't get this to work. Can someone show me the correct syntax? Thanks very much. strComputer = "rich" strUser = InputBox("Enter...
  17. richardrekos

    hta front end to a script?

    I am new to scripting and have just seen an example of an hta front end for a script. I cannot figure out how to setup a form on a hta page so I can input the value for "cn" and "ou" (4th line on script below). I am trying to have this script add a user to a security group in AD. I don't want...

Part and Inventory Search

Back
Top