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!

Search results for query: *

  • Users: kre1973
  • Content: Threads
  • Order by date
  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

    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
  5. 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 "|"...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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>...
  13. 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...
  14. 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>...
  15. 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...
  16. kre1973

    Delete duplicates from text file

    I have the following text file below thats has duplicates records in it, in which I need the duplicates removed thus creating a new text file.... "8002220365archwireless.net"|Baker, Scott "8002220365archwireless.net"|Baker, Scott "8002257514archwireless.net"|Boston, Jeff...
  17. kre1973

    Make updates(Edit, Delete, Add) and save text file????

    I basically have a ListBox1 in which I list records from a file splitting on a "|" delimiter. When the entry in the Listbox1 is double-clicked it displays the second part of the record array in textbox1. I'm using a class: Individual.vb to display the data in textbox1. The file is read using...
  18. kre1973

    Double click item from Listbox to textbox not working???

    I'm loading a Listbox with a textfile and splitting the record into array, only adding the "Grp_elements(1)" into the listbox. That part works ok, but when I doubleclick an item in the Listbox I want to add the "Grp_elements(0)" to a textbox this part doesn't work... It says that...
  19. kre1973

    How to use a CGI program to call a Perl program?

    I have the following CGI program below that has a form with embedded Javascript. I'm trying to read a textfile and putting it in a dropdown "Select" statement for the user to pick from. I then need to pass the variables to a Perl program that sends a page to a pager. I'm not sure how to pass...
  20. kre1973

    How to display the Outlook Address book?

    Currently I'm using the following VB 6.0 code to bring up the Outlook Address book where I can select names from it and put them in a textbox on my form. How would I do this in VB .Net?? Here is the VB 6.0 code which works great: Private Sub cmdAddressBook_Click() Dim arrName As Variant...

Part and Inventory Search

Back
Top