Recent content by sgreenwood

I failed to mention that we are using MS Office 2003.

We are having what I consider a very odd problem. We have an Excel file that is updated each morning and emailed to a distribution list of 20 users. The file is emailed by an administrative assistant to the distribution list and is received and opened just fine by everyone on the list...except...

Thanks for your responses. I haven't even attempted to connect the front usb headers yet. It looked like something that could easily be done incorrectly so I figured there were enough on the MB to start with. Unfortunately, the MB ports aren't being recognized at all.

I just installed a new Abit VT7 motherboard and none of the on board usb ports are working. There are no usb ports/hubs showing up in my hardware list. I am running Win XP Pro sp2, so I would have thought the drivers would have loaded. Does anyone have any idea what the problem may be? Any...

Ken, I like your way of thinking! I would have never thought of doing it that way...but it works perfectly! Thanks so much. A star for you!!

I have a friend with a worksheet that has several columns containing formulas. They want to "transpose" the columns to rows, but of course the formulas don't work after doing a paste special-transpose, so they want to create absolute cell references in the formulas. There are A LOT of cells...

Thanks, I will give your suggestions a try.

I'm hoping someone can help me with a VERY annoying situation that I have. I've search through all of the posts and found many references to "runtime error 91", but none in this context. When working in Excel 2002 (Win XP Pro), I receive this error when trying to navigate through a multiple...

I'm having problems with a particular file not wanting to re-calc. It's not a very large file (45 sheets), but it is very formula intensive. The file used to re-calc fine either manually or when set to automatic, but now it won't re-calc either way. If I save the file, close it, then reopen...

I don't know if this will help you, but I use it all the time to find links that I don't want. I do a find across all worksheets in the file for ":\". The reason is because every link that I have seen has a reference to the drive where the linked file exists, therefore the link always...

BINGO! That is exactly what I was looking for. Thank you SO much for your help!

Actually I can use whatever way would be best. I was thinking probably query, but as I mentioned, I'm not all that familiar with Access. What would be your suggestion as to the best way to accomplish what I'm trying to do? Again, thanks for you help.

Thanks very much for your response. I understand what you are saying, but the structure can't be changed. I probably didn't go deep enough into the original explanation. One additional field in each record is "recommendation number". Each record in the table comes from a single numbered...

While I am "fairly" adept at using Excel, I'm reletively new to Access. I believe what I am trying to do shouldn't be too difficult, but I can't seem to figure out how to do it! I'm working with an Access database and I want to be able to set it up so that the user will be prompted to enter a...

Perfect Tony, thanks VERY much!