Search results for query: *

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?

I have a form that opens with the workbook. I would like to switch this form with another after the initial workbook does a saveas to another file name and closes itself without saving any changes. I would like the saveas file to have the new form open when it opens up. I need help with the VB...

Skip, I get an error "Run-time error '5': Invalid procedure call or argument" when I don't select a value from the listbox. Sometimes they may not need to select a value from this particular listbox. How can I allow that? Thanks David

oh i see, figured it out! Thanks Again David

Thanks Skip... don't get any errors, which is always good but how do I get this to put values into my cell? I would like the selected items to be placed into cell D45, comma seperated! Thanks Again David

I have a form (Form1) with a listbox on it (ListBox1). The listbox gets it rowsource from Groups(a defined name range with the worksheet). I have the listbox set to SelectMulti. All I want is when I select 2 or more items, and click Button1, for the values selected to be placed in a cell...