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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dnelson24

  1. dnelson24

    Excel hyperlink for telnet session

    Works, so how can I get rid of the "hyperlinks are harmful" pop-ups? Thanks
  2. dnelson24

    Open Telnet session from excel hyperlink

    I will post over there too! Thanks
  3. dnelson24

    Excel hyperlink for telnet session

    If I have an IP address in a cell in an excel sheet, is there a way for me to create a hyperlink that would open this IP host in a telnet session? Say using just MS built in telnet.exe? Thanks David
  4. dnelson24

    Open Telnet session from excel hyperlink

    Works but get several pop-ups to have click through... one on hyperlinks can be harmful....and one on a virus warning for the bat/cmd file.
  5. dnelson24

    Open Telnet session from excel hyperlink

    That tries to open it your web browser.
  6. dnelson24

    Open Telnet session from excel hyperlink

    If I have an IP address in a cell in an excel sheet, is there a way for me to create a hyperlink that would open this IP host in a telnet session? Say using just MS built in telnet.exe? Thanks David
  7. dnelson24

    Auto Create Tables

    Perhaps i need a do loop or something...around this current code to start ranking at 10 again after the EMP_CD changes value?
  8. dnelson24

    Auto Create Tables

    This is the code I used in another db.... Function MGWgp() Dim MyDB As Database Dim MySet As Recordset Dim I As Integer Dim R As Integer Set MyDB = DBEngine.Workspaces(0).Databases(0) Set MySet = MyDB.OpenRecordset("select * from [MGW2Store - GP Select]...
  9. dnelson24

    Auto Create Tables

    EMP_CD VSN SALES$ AGS M450 $500 AGS N3098 $300 AGS T785 $165 AGS U58 $50 AGS 323 $964 BKN 4938 $567 BKN O987 $56 BKN 8371 $367 BKN B475 $456 BKN B234 $321 The table has 140 more EMP_CD's just like above...
  10. dnelson24

    Auto Create Tables

    The problem is that we "currently" have 142 salespeople. Our sales has a somehwat high turnover. I am updating the EMP_CD from a table that has a termdate set or not. My table that I am working with has EMP_CD, VSN(Vendor stock number), and SALES. Each employee has multiple VSN's. I need to...
  11. dnelson24

    Auto Create Tables

    First off I know very little about Vb code so please be kind. I have a table called SALESPERSON with a field called EMP_CD in it. There are 142 employee codes. Can someone explain and supply some code that would allow me to auto create a table for each employee, I would like the new tables...
  12. dnelson24

    Comparing a form's text box value to a table field

    I have a form with 2 text boxes in it, one displaying the year(2006) the other displaying the month(June). I also have a table that gets appended after the user runs an update on that table. Thus last month the last record would have a field YEAR (2006) and MONTH(May). They run the data for...
  13. dnelson24

    Calculation Errors

    I checked everything on Cognos except Advisories! Looks like what I may need. Thanks David
  14. dnelson24

    Calculation Errors

    I am using Cognos PowerPlay Web to view reports submitted to the Table of Contents, viewed as PDF's. For some reason when a new cube gets built overnight some totaled rows in the reports are not summing correctly the next day. Any ideas?

Part and Inventory Search

Back
Top