Search results for query: *

Thanks, strongm! I'll give this a try ! Best, Blue Horizon [2thumbsup]

Here's a suggestion for getting started using Microsoft.com: Link Best, Blue Horizon [2thumbsup]

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

Thank you! I was thinking that was true but wanted to ask an expert. Best, KV Best, Blue Horizon [2thumbsup]

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

You Rock!! Worked like a charm..... Thanks so much! Best, Blue Horizon [2thumbsup]

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

Thank you - from your suggestions, the lights went on. What will work is a form/subform to both tables. Happy Holidays! Best, Blue Horizon [2thumbsup]

Is there then a way to view the document that is saved in the Attachments table on the table that it is linked to? Best, Blue Horizon [2thumbsup]

Thank you MajP. Dozens of records get the same attachment - they don't all get the same one. So every 30-40 records have the same attached letter, then it changes for another 30-40 records. I'm afraid I'm code-ignorant and wouldn't know what to write or where to put it. I was hoping there...

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

Thank you for your help - I'll look into using forms to accomplish this. HAGD, BH Best, Blue Horizon [2thumbsup]

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

You can use the Text to Columns feature as suggested above, and then use the TRIM function (=TRIM(A1) to remove the space. Hope this helps, Best, Blue Horizon [2thumbsup]

Thanks, DHookam, NULL worked. I'm usually OK with "" to return a blank but not in this instance. Good day! Kathy Best, Blue Horizon [2thumbsup]

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

No crystal ball necessary, Skip. The question was generic to Word macros. It seems I cannot get a font color change to work when I record a macro. I wanted to know if it was a problem with new 2010 macros or if it was a problem on my load of Word. Thanks anyway, K Best, Blue Horizon [2thumbsup]

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, On the View tab, you can click the Notes Master tool and format as desired. HTH, Best, Blue Horizon [2thumbsup]

Thank you to both! I'll try your suggestions and get back with results! The info re forward slash and mod is very helpful. Best, Kathy Best, Blue Horizon [2thumbsup]