Search results for query: *

Hi everyone, I know how to set conditional formatting to change the appearance of new emails when a certain word is in the subject. What I want to do is change the appearance if a certain word BEGINS the subject, but not when it is merely contained in the subject. Example: If the word...

Hi all, I have an Excel worksheet that has color-coded text to represent certain phases of a project, i.e., red, green, blue text. When I linked this Excel worksheet as a Linked Table, it lost the color coding. The whole reason for trying to link rather than import was to be able to view the...

Hello everyone, I created a database to keep client data, including helping me keep track of various letters sent to clients. Each record has an Attachment field that can contain 1 to 3 attachments (Letters). I quickly outgrew the 2gb limit, so I split my data into separate tables...

Good day and Happy Holidays! I know about using the Ctrl + ' shortcut to copy from the field above. So I am trying to use this shortcut in a field with an attachment data type to save me the trouble of attaching each letter separately when the same letter applies to several rows. The .pdf...

Hi all, Is there a way to change font color in individual fields in an Access 2010 table. When I've tried the formatting tools, it changes the entire contents of the table. I would like to be able to change font color by individual records or individual fields. Thanks in advance for your...

Hi, I appreciate any help with an IIF formula. I have a date in the [dtmOrdDate] field. I want to produce a report that displays today's date if today is [dtmOrdDate] plus 30 days. Otherwise, "" (blank). Here's what I've tried but it isn't working...

Good morning all, In Word 2010, I've tried recording a font formatting macro that includes changing the font color. When I run the macro, it performs all actions except the font color change. Is this new in 2010? Is there something different I need to do to make the font color change become...

Hi everyone, In an Access table, I want to be able to enter hours and minutes so I can sum them. This is one way the entries could be entered: 1:30 (representing 1 hr/30 min), 1:45 (representing 1 hr/45 min), 2:45, 4:30, etc. The total/sum could appear as: 10:30 (representing 10 hr/30 min)...

Good day all! I'm working with a date entered in cell A1. Here's what I need to have happen: As soon as a date is entered in A1, B1 turns green to show its status. At 9 months from the date in A1, I need B1 to turn yellow. At 1 year plus 1 day in A1, I need B1 to turn red. Do-able...

Hi all! Through tutorials on the web, I found how to add a dependent combo box to a field on my frmMASTER form built from my tblMASTER. The field on frmMASTER [strCHC] points to a different table [tblDependentCombo] for the dependent choices which will be shown in [strCHC_SubType]. Here's my...

Hi all, Outlook 2010 on Exchange Server. A co-worker was given access to someone else's mailbox. Now she no longer supports that person and wants to remove the mailbox. She has tried everything to remove/delete the mailbox. Even the other person who gave her access has removed the...

Hi all, I've created several Word templates with fillin fields so users can enter text via popup boxes, i.e., To:, From:, Date:, etc. After users finish the last popup, I'd like the cursor to be a certain position in the body of the document for them to start typing the body of text. Any way...

Hi all, I need to create a Word template with fill-in fields (I know how to do this part) that, when the text moves to page 2, the margins will automatically change. For example, the left margin in Page 1 is 1.875" to accommodate letterhead on the left side of the page. If the letter needs a...

Hi all, I have a workbook with two worksheets. Worksheet1 shows a number in Col A, i.e., 1, 2, 3, 4 Worksheet1 shows a text name in Col B, i.e., Washington, Lincoln, It can look like this: Col A Col B 1 Washington 2 Lincoln 3 Grant 3 Washington 2 Grant 1...

Hi all, I created a query that returned the following information. Part# Year Make Model 7133138 2000 Malarky SSP-R750 7133138 2001 Malarky SSP-R750 7133138 2002 Malarky SSP-R750 7133138 2003 Malarky SSP-R750 7343243 1978 Wuzzits BP250 7343243 1979 Wuzzits BP250 7343243 1979 Wuzzits...

Hi and thanks in advance for any help! I have Col. 1 in Excel with dates, i.e., 11/25/2011 2/29/2012 4/16/2012 2/9/2012 8/7/2011 9/14/2011 9/23/2011 12/17/2011 4/22/2012 10/1/2011 10/4/2011 10/24/2011 12/3/2011 1/25/2013 9/24/2011 12/28/2011 4/21/2012 I want to create 3 columns: Col. 2: shows...

Hi, So I've searched and cannot find a way to do this: If I've added fields from different tables to a form, how can I identify which table the field came from? I couldn't find it in the Properties sheet and don't know where else I might look... TIA, Best, Blue Horizon [2thumbsup]

Hi all, Thanks in advance!! I have a split database (backend on server and frontend on PCs). How can individual users create queries on the frontend copies? Thanks! Best, Blue Horizon [2thumbsup]

Hi all, Thanks in advance!! I have a split database (backend on server and frontend on PCs). Can I create queries on the frontend copies? Thanks! Best, Blue Horizon [2thumbsup]

Hi everyone, I have the following in Excel: StartDate 1/21/2011 1/27/2011 2/1/2011 2/5/2011 2/15/2011 2/21/2011 3/2/2011 3/5/2011 3/11/2011 etc. What formula would count the number of dates by month? I tried CountIF using "1/*" as the criteria but I can't get it work. Any help is greatly...