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!

Register Log in
  • Congratulations dencom 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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