Search results for query: *

Thanks Mintjulip, I did finally figure out how to get it to update on print. Paul, I will try that approach too.

Also, when I edit the text in the bookmark, I have to highlight the text and re-insert the bookmarks. I am clearly doing something wrong.

I have a long document in Word 2010 with various footers that need to change based on a name put in one of the headers in the document. So I inserted a bookmark for the text in the header and then inserted cross reference to the bookmark in all the various footers(different sections). Anyway, I...

Thanks Paul. I will let you know how it goes. I probably won't work on this again till Monday/Tuesday.

Hi Paul, please see attached. Thank you. http://files.engineering.com/getfile.aspx?folder=ed89c716-22d8-4997-9f23-aacf627803e1&file=Capture.JPG

Yep :(

Looks like just the bullets change. In source document they are round bullets and in working document they are square ones. The font is the same between documents. Dawn

Help! I am copying/pasting formatted text from one document to another and it doesn't keep the exact formatting. (it keeps some but things like the bullets change.) I have tried everything. I use paste special of course and I have checked all the copy/paste settings under word options. I've...

Yes! Thank you. I knew I was missing something simple.

I feel like I should know this but I can't figure out what I am doing wrong. I ran this query asking for only records where the name field contains the word in the keywords1 field. But when I view the results, there are many records that do not have the keyword anywhere in the name. I have...

That's what I did. I inserted the text field from the legacy tools in the control panel. No problem inserting field, just not sure why it only allows user to type in one character.

Not sure what I did wrong, but I created a fillable form in Word 2010 with just some text fields. But when I protect the form, the fields only allow one character to be typed in. I cannot find a property anywhere that tells me how to set the character length. Can you help me? Thank You, Dawn

Hi there, I really need help on this asap. I created a report in Access 2010. It's a listing of contact information, name, address, phone, email, etc. Since everyone doesn't have every piece of info, I have the fields shrink if the field is blank. Some cases it shrinks and some it does not. So I...

I got an error when I tried your code PHV. However, I got it to work. Not sure if this was the long way around or the actual fix. I first created a query that found the MAX date for each domain. Then I created another query that found the person that properly matched with that date/domain. I am...

Ok, when I use Max, it gives me the right date but doesn't give me the correct name that goes with that record. UGH! It still gives me the 3/15/2013 name, even though it is showing 5/24/2013. Shouldn't it keep all of one record together?

Maybe I figured it out. Should I be using MAX for dates instead of first/last?

Here is the SQL of the query I am doing if it helps. SELECT tblExhibitors.strEmailDomain, Last(tblExhibitors.dtmDateLastUpdated) AS LastOfdtmDateLastUpdated, Last(tblExhibitors.strFirstName) AS LastOfstrFirstName, Last(tblExhibitors.strLastName) AS LastOfstrLastName...

I often have trouble with totals queries. So I start with just one field at a time to make sure I am doing it right. I have a data field (say company name) I am grouping by, and then a date field. I want to see the records with the most recent date. So I group by company and sort descending by...

Thank you for your help on this. I forgot I posted it and just asked something similar. (not quite the same, but looking through this post to see if it provides the answer.) Thanks again.

...1) <> "\" Then MyPath = MyPath & "\" End If ' If there are no Excel files in the folder, exit. FilesInPath = Dir(MyPath & "*.xl*") If FilesInPath = "" Then MsgBox "No files found" Exit Sub End If ' Fill the myFiles array with the list of Excel...