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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.