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 Mike Lewis 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: *

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

    Need regular expression to pull out substring from string

    I don't what name should go in textbox2, it could be different each time I download a string from a Web site. But, it should always follow the words:"ContactsManager:
  17. kre1973

    Need regular expression to pull out substring from string

    Basically, I need to pull out the name following the words:"ContactsManager:" which is "BARBARA JOSEPH" I would like to use RegEx just to see how's it done...
  18. kre1973

    Need regular expression to pull out substring from string

    I have the following string below in which I need to pull out the following substring: BARBARA JOSEPH Job Completion, Failure Instructions, and Rerun NotesAppl ID Description:dailyopsEdit Application ContactsManager: BARBARA JOSEPH - Ext: 2612Primary: ISAAC THOMAS - Ext: 2011Secondary: RON...
  19. kre1973

    How to sort a XML file?

    I heard of importing your xml doc into a dataset, then sort the dataset and re-populate your xml, but I'm not sure how to code this.. I'd like to sort it by the 'Name' node. Here is my XML file: <?xml version="1.0"?> <IndividualListing> <Individual> <Name>Aaron, Scott</Name>...
  20. kre1973

    Complete XML into HTML form not working?

    I have a HTML pager site that pulls in data from a XML file using Javascript allowing the user to select an individual and enter info into the textboxes. They would then click the send button and a page would go out to their pager using a Perl program. I can see the data(just the names) in the...

Part and Inventory Search

Back
Top