Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sgreenwood

    Problem opening MS Excel file "attachment"

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

    Problem opening MS Excel file "attachment"

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

    New Abit VT7 motherboard...usb ports no working

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

    New Abit VT7 motherboard...usb ports no working

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

    Excel - Making absolute cell references

    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!!
  6. sgreenwood

    Excel - Making absolute cell references

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

    Runtime error '91' when browsing workbooks in Excel??

    Thanks, I will give your suggestions a try.
  8. sgreenwood

    Runtime error '91' when browsing workbooks in Excel??

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

    Excel re-calc problem

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

    Breaking links in Excel97 -- frustrating :(

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

    How to set-up a "prompt" in Access

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

    How to set-up a "prompt" in Access

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

    How to set-up a "prompt" in Access

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

    How to set-up a "prompt" in Access

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

    Assigning Keys Question

    Perfect Tony, thanks VERY much!
  16. sgreenwood

    Assigning Keys Question

    Thanks for your response, unfortunately I am trying to accomplish this in Excel. I should have mentioned that in my original post. Thanks again.
  17. sgreenwood

    Assigning Keys Question

    Hi, Is it possible to assign keys, or "re-assign" keys in MS Office XP? I would like to either re-assign help to something other than F1 or even just disable F1. Thanks for any insight you provide. Steve
  18. sgreenwood

    Internet & network problems

    I don't know if this will be of any help to you, but I just had the same sort of problem with my laptop connecting to the internet. The solution that worked for me was to drop to a command prompt and type "ipconfig/release" then type "ipconfig/renew". This renewed the ip...
  19. sgreenwood

    Excel 97 start up problem

    I've encountered a minor problem recently when starting Excel 97. After opening Excel but before the "blank" worksheet appears I recieve an error message. I believe it's just sort of an informational error (a window pops up with an exclamation point in a yellow triangle?) The window...
  20. sgreenwood

    MS Access Data Paste Question

    Hi, Hopefully this will be an easy question. I have a blank column in an Access table. I want to type "Trade A/P" in the first field and then copy it down the entire column. Is there an easy way to do this?? I tried doing it as I would in Excel....copy the field then highlight...

Part and Inventory Search

Back
Top