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 gkittelson 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: timely2
  • Order by date
  1. timely2

    Searching inforamtion in a text file.

    Oh, another part that could effect this is multiple lines will come back when I do a serch.
  2. timely2

    Searching inforamtion in a text file.

    Not sure on the perl how to read that but I was messing with the grep and I found that it does not want to see: grep -n "test" file.log | cut -d: f1 as a number. I broke it up into diffrent parts and seemed to work until you tried to use that part to do math. Thanks
  3. timely2

    Searching inforamtion in a text file.

    I tried the script they had but I kept getting a bad number error for the math part. I can get the part that does the grep to work and I could get the tail / head part to work but when I tried to have it look at every instance with the number of lines it would error out with the bad number.
  4. timely2

    Searching inforamtion in a text file.

    I am wanting to do a search for instances of a given string but I want more then just the line its on, but may three entry lines before and after each time I find the string. The file I look through is an over 5,000,000 line log. I only get the line the string is on with a basic grep and doing...
  5. timely2

    Starting a executable remotely

    The executable already exist on the remote server. I just need to start it back up on that remote computer. I do not need to see it on my side except that it was successful. The article may have approached that issue but I do not have a subscription to that site. Thanks
  6. timely2

    Starting a executable remotely

    I am trying to find a way to use a script to remotely start an executable. I can change them out and use taskkill to start it. But when I tried a Call command it gave me an error: "Component 'ipport50.ocx' or one of its dependencies not correctly registered: a file is missing or invalid" I...
  7. timely2

    Access Db w/ pw to excel

    I am able to get code work if a user and password are defined on the access db. pw = ty ud = "Admin" ' Path to Transfers.mdb MyConn = "d:\personal\tely\pickeraccuracy.mdb" Set cnn = New ADODB.Connection With cnn .Provider = "Microsoft.Jet.OLEDB.4.0" .Open...
  8. timely2

    nz problem from access to excel

    Thanks, that worked great! Tim
  9. timely2

    nz problem from access to excel

    I am trying to call data to a excel table from a query in Access but it says it cannot recognize the nz in excel. Is there another way to move the data so it recognizes blanks as a zero from access? This is the query: SELECT test.pickerNum, test.period, test.week, test.year, sum(test.olq) AS...
  10. timely2

    global varible in Excel VBA?

    That was exactly what I was looking for. Thank You
  11. timely2

    global varible in Excel VBA?

    The book I have does not show how to setup global variables and use between multiple forms that will close. I have a string variable that is used to place information in the correct column. Based on a Select Case it will have the column based by date and shift. Example if: date is today and...
  12. timely2

    Passing variables from one form to another

    Okay, I know I was not clear on the last one. But, is this kind of what you meant? The first form will already be closed when the second one runs due to functionality of filling a report on excel. Thanks dim testers as string Private Sub CommandButton1_Click() Dim oWorkBook As...
  13. timely2

    Passing variables from one form to another

    change out code I had previosly with this. Set oComment = Sheets("Sheet1").Range("sCell").AddComment(MyString)
  14. timely2

    Passing variables from one form to another

    I am trying to move sCell in this case not to actually be put in the form but to be used with the placement by the VBA. Here is example of the code sCell is what I am bringing over from UseForm1 and using for part of placing the comment in a location. Private Sub CommandButton1_Click() Dim...
  15. timely2

    Passing variables from one form to another

    I am working with two forms that will feed both a access database and excel spreadsheet. I have one form that obtains information needed for a report on excel and helps my code recognize where to put the information (what cell) based on date and shift. Well I am introducing another form for...
  16. timely2

    Form to Comment

    Thanks, I should be able to put that with other stuff that I found on comments.
  17. timely2

    Form to Comment

    I am trying to get information filled in a form to go both to a database and to one comment for cell for a related day. I already have it going to the database. Not sure how to get several entries into one comment. I am using it for a role of all present at a meeting on a report. Thanks Tim

Part and Inventory Search

Back
Top