Recent content by dnelson24

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

I will post over there too! Thanks

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

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.

That tries to open it your web browser.

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

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

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

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

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

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

Could you expound on that please?

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

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

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?