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 Chriss Miller 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: dnelson24
  • Content: Threads
  • Order by date
  1. 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
  2. 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
  3. 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...
  4. 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...
  5. 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?
  6. dnelson24

    Switch Workbook.Open forms

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

    Cell update from listbox selections

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

    cell update with listbox selections

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

    cell updated with listbox selections

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

    Ranking Help

    Given the code below how would I code this so that if the select query "MGW6Store - Acc Select" has no records my macro would just continue on with out stopping with a run=time error box? Thanks David Function MGWacc() Dim MyDB As Database Dim MySet As Recordset Dim I As...
  11. dnelson24

    PCL code for Mutiple Copies Multiple Trays

    I would like to pull 2 copies, first copy from Tray1 and second copy from Tray2? Here is what I have so far... ^&l2X^(s10H^&l1H^&l5H..... ^&l2X=2 copies ^(s10H=10 CPI ^&l1H=Tray 1 input ^&l5H=Tray 2 input how do i construct so that 1st copy is out of tray1 and 2nd copy out of tray2??? Thank...
  12. dnelson24

    Macro Condition Question

    Thank you for your help in advance!!!! I have 2 '.txt' files in C:\temp, well actually at one particular point in time there is either 1 '.txt' or the other '.txt'! I would like to "Autoexec macro" a MS Access database that when the database opens the Autoexec macro runs either macro1 or...
  13. dnelson24

    Adding field from table to a report based on check box

    anyone, I have a form that I added check boxes to. I would like to be able to, based on the check box being checked, include on a report a field from a table? thanks again david
  14. dnelson24

    Update Records in table using combo box as input

    Probably a very basic newby question...here goes... I have a form (form1) that has 4 combo boxes (Combo23, Combo25, Combo27, and Combo29). The row source for each of these 4 boxes is: SELECT [Size Table].[Size] FROM [Size Table]; The Size Table has one field (Size) and 8 records. I would...
  15. dnelson24

    Prompt for Cube

    I have 2 cubes built, 1 for delivered sales data and 1 for written sales data. I have attempted to make the models as identical as possible i.e. I have verified that all categories in both models are all setup the same. I believe this is where the problem might be? Something that the written...
  16. dnelson24

    Table field update

    Can I get some help on how to update an Oracle 7 database table called ITM. I would like to update field SIZ_ID with FULL, TWIN, QUEEN, or KING based on the existence of the word FULL, TWIN, QUEEN, or KING in the DES field? The DES field is Description.....example being GEM FULL MATT! Is...
  17. dnelson24

    Make Table Query Saving Formatting into Table

    How do I get a Table created with a Make Table Query to retain the formatting from the query. I have formatted every field in the query so that when I do a Datasheet view of the query it looks great. As soon as I run the query and make the table the formatting looks raw. Thanks in advance!
  18. dnelson24

    Access Database using touch screen CRT

    Is anyone using an Access database with a touch screen device/driver? Win98/2K?
  19. dnelson24

    Legend

    When I export a report as a PDF it places the Legend on a seperate page! How can I get the Legend to be included on the report page?
  20. dnelson24

    Need non-root user to cancel print job

    I would like to be able to have a non-root user login to the system, cancel a print job or entire queue for that matter, and be logged out after canceling the print job/queue. My thought: is there a way to create a generic login....attach/or run a script within say the .profile that prompts...

Part and Inventory Search

Back
Top