Search results for query: *

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

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

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

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

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

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

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

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

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

Thanks pwise...this does the trick perfectly!

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

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.

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

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

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

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!

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.

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

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.

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