Recent content by Wendyj

That did it! Thanks for the quick replies, appreciate the help!

Yes I did. The Member List has a lookup for the Unit Number. The Unit Table is also limited to a list of 1 - 72 exluding 13. Wanted to do this to eliminate someone accidently putting in a non existent Unit number.

I am very very new at this so please be very elementary if replying: I have a query that is based on two tables. The Member Table has the following columns: Unit Number; Last Name; First Name; Phone Number; Move In Date and Move Out Date. The Unit Type Table has the following columns: Unit...

She is operating mostly out of Office, but every program she tries comes up with the same results.

My co-worker is having a problem with PDF writer (4.05). She uses this program almost daily and suddenly this problem has just appeared. When she is wants to print to Acrobat writer the document automatically saves to the same file every time. She does not have the "save as" box come up at...

I am probably not the person who will be doing this merge on a regular basis, so I am trying to make this as idiot proof as possible. I really need something that is going to be automatic here. Thanks for the quick replies.

Unfortunately I have tried both of these suggestions and yet the footer does not update automatically. Anything else I can try?

I am in MS Word 97 and this is the problem. I have a document that I have mail merged to an access database. This document also has a footer showing the filename and path. After the mail merge is complete and I save the document the footer does not automatically update to the new filename and...

Problem is solved. I just left out the sht. in front of range.

It turns out I'm still having a problem. The error that keeps coming up is Run Time Error "1004' Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook referenced by Visual Basic The 2 excluded sheets and the first sheet to be renamed go...

I think this may do it. I have to make a couple of small changes but early indications are that this is solved Thankyou, Thankyou, Thankyou

This has worked! Thanks a lot Now my next problem is to have the 200 sheets all change at the same time while NOT changing the 2 externally linked sheets!

Here is the situation: Excel 97 SR-2 (I know I know) Workbook consists of 2 externally linked worksheets that will update from the parent worksheet as it opens (faster update than if each worksheet is referencing an external link) 200 worksheets linked to the 2 externally linked worksheets...