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: jpkeller55
  • Order by date
  1. jpkeller55

    Excel 2003 Form Button Rename

    Ok, I finally figured this out. Maybe it can help some other simpleton like me. To change the name of a regular button (not a command button), you right click on the button to enter the design view. A window will pop up (Cut, Copy, Paste etc...). While that window is open, left click on the...
  2. jpkeller55

    Excel 2003 Form Button Rename

    Apparently there are two types of buttons. Command Buttons and just plain buttons. The buttons I am trying to rename are the just plain buttons. It is interesting, when I right click on a command button, I get a properties window that allows the name of that command button to be changed. When I...
  3. jpkeller55

    Excel 2003 Form Button Rename

    This is driving me nuts. For the life of me, I cannot figure out how to rename a form button in Excel. I have a workbook with numerous sheets that all have the same format with different form information. They all have the same buttons that help the user navigate back to a main menu, print the...
  4. jpkeller55

    Access Check Box to Populate Word Check Box

    Thanks RV...I will see if I can figure out how to incorporate what you have suggested. Thanks, JK
  5. jpkeller55

    Access Check Box to Populate Word Check Box

    I have the following code that is populating data to a word document quite nicely. Now I need to have a checkbox from the Access Form populate its value to a checkbox on the Word document. Public Function CreateWordLetter(strDocPath As String) If IsNull(strDocPath) Or strDocPath = "" Then...
  6. jpkeller55

    Delete duplicate lines of email in Outlook 2003

    Thanks WingedTek for your reply. Unfortunately, I cannot upload this add-in on my company laptop which has all the duplicate emails. I really don't need to identify the duplicates as I already have them in a folder. All I really need is some simple code to select every other record in the...
  7. jpkeller55

    Delete duplicate lines of email in Outlook 2003

    I have a folder in Outlook (2003) that contains duplicate emails. Due to a sych process with our network server, somehow a bunch of emails got duplicated. I moved all the duplicate emails into a folder. Does anybody know any code or macro that I can run to delete every other row of email in...
  8. jpkeller55

    Query based on 2 data parameters

    When I run this query I get the following records: 12456 Jones 1 7999 12456 Jones 2 8412 45278 Smith 1 7999 92344 Abbott 1 7999 92344 Abbott 2 8412 33345 Black 1 7999 I only want the records in red to show were each ID has a sequence 1...
  9. jpkeller55

    Query based on 2 data parameters

    I am not sure how to go about this in Access 2003. I want to run a query that will return only those records were sequence 1 = 7999 and sequence 2 = 8412. So with the following data: ID Name Seq Payer 12456 Jones 1 7999 12456 Jones 2 8412 45278 Smith 1 7999 76293 Wilson 1 4568 92344 Abbott 1...
  10. jpkeller55

    Validate data in table is from list in another table

    Thanks pwise...this does the trick perfectly!
  11. jpkeller55

    Validate data in table is from list in another table

    I have data in two tables as listed. CatheterTypes: Lists approved descriptions of catheters ID Description 1 PIV 2 Hickman 3 Groshong PatientData: Contains data on patients including catheter type ID Name CathType 123454 Jones, John PIV 245678...
  12. jpkeller55

    Cross Tab Query - data from columns to rows

    les, I really do not need the headers, just the data grouped by fax number in rows as you have illustrated. I will see if I can figure out 4233. thanks for your help.
  13. jpkeller55

    Cross Tab Query - data from columns to rows

    I could easily concatentate the First and Last name in the table. So, really all I would need to figure out is how to get the data into rows. for example I would have the following data to start in the table Name Fax Smith, John 666-333-2222 Jones, Terry 666-333-2222 House, Ray...
  14. jpkeller55

    Cross Tab Query - data from columns to rows

    Sorry, disregard my first post...this is what I meant to post. Appreciate any help with the following: I have a table (FaxNum) with the following data: LAST FIRST Fax Smith John 666-333-2222 Jones Terry 666-333-2222 House Ray 888-999-1111 Blake...
  15. jpkeller55

    Cross Tab Query - data from columns to rows

    Appreciate any help with the following: I have a table (FaxNum) with the following data: LAST FIRST Fax Smith John 666-333-2222 Jones Terry 666-333-2222 House Ray 888-999-1111 Blake Rob 888-999-1111 Johnson Sam 888-999-1111 White Barry 888-999-1111 Rio...
  16. jpkeller55

    Extract part of text from Access Record

    I ran the script you first supplied to me in an update query to update a field in the table with the 6 characters. It worked fine. First time I was doing a select query with Unique Values set to Yes and that gave me the error message. I will try your code out too. thanks much for your help!
  17. jpkeller55

    Extract part of text from Access Record

    The error message was a result of the fact that I had Unique Values set to Yes on the query properties. By changing it to NO, it works. Thanks Remou! I would like to explore your array solution to this problem too, but wouldn't know where to start.
  18. jpkeller55

    Extract part of text from Access Record

    I get an error message when using this code: Mid(FieldName, InStr(FieldName, "IU") - 4, 6) "Invalid Procedure Call
  19. jpkeller55

    Extract part of text from Access Record

    sometimes the number preceding the IU is only 3 digits. In those cases there is a space in front that I suppose I could then delete.
  20. jpkeller55

    Extract part of text from Access Record

    Does anybody know if a part of text can be extracted from a record? Using Access 2003 For example: With the following records, I only want the portion that contains the number followed by IU. Records: ADVATE 1070IU VIAL (BAXTER) FACTOR VIII RECOM ADVATE 1390IU VIAL (BAXTER) FACTOR VIII RECOM...

Part and Inventory Search

Back
Top