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 strongm 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 kre1973

  1. kre1973

    Checkbox value & Datagrid

    Interesting problem. I have a datagrid with several columns which are bound to an Access database. Two of the columns are checkboxes. The 1st and 4th columns are checkboxes. Here's the situation...I'm concerned with the 4th column. This is what currently happens... when a user clicks the...
  2. kre1973

    Compare system time to an Access table field

    This is an application to remind someone to do things at a certain time of the day. There are sometimes more than one thing the person has to do at a particular time. So, basically I'm try to alert the user with a popup message box that it's a certain time and to do required things now. I'm...
  3. kre1973

    Delete row in Datagrid using checkboxes

    Basically, in my first column I have checkboxes that are unbound. I would either like to be able to remove the row by checking the checkboxes or clicking a button after a checkbox(s) are checked. thanks
  4. kre1973

    Update a XML file using Korn Shell

    It works, but I need to save the updated XML file.
  5. kre1973

    Update a XML file using Korn Shell

    I guess using AWK or SED would be fine also.
  6. kre1973

    Update a XML file using Korn Shell

    I have the following XML file called: Today.xml in which I want to insert the current time in the node called: <TODAY>. <?xml version="1.0" standalone="yes"?> <MSR> <Info> <TEEFHR /> <TEPP /> <TNC /> <TODAY /> <UPDATE /> <UMZ /> <UMZT /> </Info> </MSR> thanks
  7. kre1973

    Write macro to import many .txt files?

    I actually want ot use Excel VBA code...
  8. kre1973

    Write macro to import many .txt files?

    I have a folder that contains many .txt files that I need to import into Excel. Every .txt file would have it's own indivdual sheet based on the name of the text file. With every .txt file there are records within it that would put imported into rows which are delimited by the pipe symbol "|"...
  9. kre1973

    Need Select formula for selecting records from two different columns?

    I have the following two columns of data: Assignment History Resolve Group {"NSD, Q-3557, WAN SUPPORT", "FIELD NETWORK"} FIELD...
  10. kre1973

    Need to check for substring within string?

    I have the following string data in Excel: {"NSD, Q-3557, WAN SUPPORT", "FIELD NETWORK"} {"ACTUARIAL VALUATION SYSTEMS", "COMPUTER OPERATIONS"} {"MQ", "COMPUTER OPERATIONS", "MQ", "HO CASE MGMT SUPPORT"} {"Q-6996 ESA, PASSWORD SUPPORT", "EIMT-EBSS/WINSIGN/SITEMNDR/LDAP", "Q-5576, THE SERVICE...
  11. kre1973

    I have the following data in the following columns in Excel

    Open Time Resolve Time Mean Date/Time To Resolve 2/1/2008 1:18 2/5/2008 7:14 2/1/2008 1:01 2/1/2008 1:01 2/1/2008 1:02 2/12/2008 11:39 2/1/2008 1:03 2/2/2008 6:58 2/1/2008 1:06 2/1/2008 3:02 2/1/2008 2:01 2/1/2008 2:02 2/1/2008 2:17...
  12. kre1973

    Check for duplicates before inserting into Access

    I'm trying to check for duplicates before I do an INSERT into the Access database table. I basically want to alert the user if the 'ProjectName' and the 'MileStones' are already in the table.. thanks Private Sub btnADD_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
  13. kre1973

    Compare XML string to records in a text file?

    I have the following script below in where I read in certain elements in a XML file and write them to a text file. What I need to do is before I write to the file is to compare the records in the text file to the XML elements read in. If any of the records in the file matches the XML elements...
  14. kre1973

    Convert Excel formula to Perl??

    I'm using the Perl module: Spreadsheet::WriteExcel in which I'm trying to create a Excel spreadsheet. It's seems that the formula below is maybe to complex for the modules to interpet. What the formula is basically trying to say is that, how many time entries in the cell range of E2:E23 are...
  15. kre1973

    How to export a Access dataset to a XML file with a certain format?

    I want to export data from my Access dataset to a XML file with the following format concept. <?xml version="1.0" standalone="yes" ?> - <UMZ> - <ServerID> <Server>PDS_SY1</Server> <PreCS>servconnEmergencyShutdown servconnShutdown</PreCS> <PostCS>servconnStartup</PostCS>...

Part and Inventory Search

Back
Top