Search results for query: *

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

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

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

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

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

I am using expressions below to capture values of certain data in cells of an excel spreadsheet and exporting to an Access database. What is the syntax for capturing the value of a checkbox? (e.g. checkBox1 = 1 if checked or 0 if not checked) .Fields("Date") = Range("b" & 3).Value...

I have the following very simple code on a button in Excel for a user to click on to Email the excel (2003) file in Outlook. This works fine. I would like to have Outlook open with the file attached as it does now but with a specific email address populated in the TO: field of Outlook (2003). Is...

Does anybody know how to capture the "Last Saved By" info from and excel spreadsheet using a macro? We have users in the field who send in reports on an excel spreadsheet and I am consolidating the data that is sent in on these excel forms into an Access database using the following code: Sub...

I have a form with continuous records that are shown. I would like to put a command button in the detail section of the form to only be visible if the value of one of the fields is a certain value (Me!Text54 = 12).This is what I have on Form Open: If Me!Text54 = 12 Then Me.CSinfo.Visible = True...

I have a table that has patient names (ptTbl) and demographic information. I have another table (commentTbl) that holds comments for each patient by date. The tables are linked by patient ID number (ptID). (Referencial integrity is checked on table relationships). I have a form that has the...

I have data from a query (NRqry) that looks like this: ClientName ServiceDate NetRevenue GrossMargin Jones 3/12/07 5,000 1,800 Jones 3/27/07 6,000 2,300 Jones 4/01/07 3,500...

I have a form that has a command button that when clicked will open a specific Word document. The code below is the event procedure On Click. I have about 10 different documents based on the last name of an account and instead of writing this code 10 times for different documents and have ten...

I have a table that stores spanish verbs wordsAll.tbl. I am trying to make a query that will delete the last two letters of the word leaving the "root". For example: Word Remove Root caminar -ar camin hablar -ar...

I am using the following code on an Access 2002 form that opens an excel file (FLNcalculator.xls) - works fine. Is there a way to make the button open the folder so the user could select any of the excel files stored in that folder? Private Sub Command16_Click() Set Sh =...

I am using the following code to make a record BOLD based on the value of another field on a report in Access 2000. How can I modify this code to make it BOLD and ITALIC? Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If MedcoPt <> 0 Then PatientName.FontBold = True...

Clearly I am a novice at this and need help. I am trying to utilize the code listed in faq702-2379 to populate data from an Access form to a Word document. I am using 2002 version of Access and Word. Code so far:Public Function CreateWordLetter(strDocPath As String) If IsNull(strDocPath)...

Does anybody know if there a way to suppress the message "Do you want to save the changes you have made to FILENAME" in Excel when you exit the file? Thanks...Jim

I am sure this is a simple question. I have the following query written and I would like to return only records where the ID number is repeated more than once SELECT [21_Status_Project].ID, [21_Status_Project].LAST, [21_Status_Project].FIRST, [21_Status_Project].THERAPY_TYPE FROM...