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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MMSMSD

  1. MMSMSD

    Autofill cells in Excel with a different series than 1

    Combo's solution worked like a charm. Thanks! [bigsmile]
  2. MMSMSD

    Autofill cells in Excel with a different series than 1

    This is hopefully easy for someone else but I don't deal with it often. I have a pointer in a cell to a cell in another sheet in the same workbook: ='ANOTHERSHEET'!A1006 I need for the next cell down to point 9 rows down from the last one: ='ANOTHERSHEET'!A1015 ...and to continue until...
  3. MMSMSD

    Windows 7 and KMS Server Switch

    Thanks for the reply, Linney. I'm probably in the wrong forum but I did figure out the answer: Once your DNS points are in place for the new KMS server, the machines will request and activate on the new server without having to run any additional slmgr commands.
  4. MMSMSD

    Windows 7 and KMS Server Switch

    We're updating from VAMT 2 to VAMT 3 for KMS licensing of our Windows 7 installations. We have a new server configured with VAMT 3 and have changed the DNS entries to point KMS licensing to the new host. Do we need to manually activate machines in order to get the new KMS server running (you...
  5. MMSMSD

    How to find out which DC Outlook 2003/2007 is using

    If you go into your email account settings, select the profile you have there and click on CHANGE or EDIT. You should see the DC listed under SERVER on the first page of the wizard. Hope this helps.
  6. MMSMSD

    Registry key for Outlook 2007 IMAP message deletion

    Not sure but you could use Process Monitor from Sysinternals to figure it out (assuming it IS a registry key. Microsoft bought them out. Here's the URL to the latest version. http://technet.microsoft.com/en-us/sysinternals/bb896645 Run it, make the change and see what changes in the...
  7. MMSMSD

    Excel 2010 and Time Import from Access

    Skip, First, let me thank you for your time and effort to try to figure out this issue. In answer to your direct question, none of these are DURATION values. Second, thanks for your insight into WHY an alternative query would be advised. You are correct: a time value is not very useful...
  8. MMSMSD

    Excel 2010 and Time Import from Access

    Here's the SQL from the query in Access: ---------------------------------------- SELECT tbl_TimeRecord.TR_Date, tbl_TimeRecord.TR_In1, tbl_TimeRecord.TR_Out1, tbl_TimeRecord.TR_In2, tbl_TimeRecord.TR_Out2, tbl_TimeRecord.TR_Reason FROM tbl_TimeRecord WHERE...
  9. MMSMSD

    Excel 2010 and Time Import from Access

    Skip, Yes, I did review the FAQ. I believe I understand it. If I print the query directly from Access, I get values like 6:40, 12:30 and 15:00. These are all proper values that Excel should be able to convert as TIME and display properly. Indeed, under Excel 2003 and Excel 2007, they DO...
  10. MMSMSD

    Excel 2010 and Time Import from Access

    Thanks for the quick reply! The field in the Access table is already set to SHORT TIME, so the query does not contain a date at all. It's almost like Excel 2010 is adding a date (and failing) because one is not there. But that ONLY happens in Excel 2010. When I open the exact same file in...
  11. MMSMSD

    Outlook public calendar html and printing problem

    Have you tried different browsers? I've seen many instances where the browser you use will dictate what data shows up on the page and how it'll look when printed. With OWA (Outlook Web Access), for example, working in IE and Firefox are two TOTALLY different experiences. And, yes, the CODE...
  12. MMSMSD

    Group calendar

    To my knowledge, Outlook will only share calendars via Exchange (or some other centralized server software.) When using PST files (Outlook without Exchange), only one person can access the PST file at a time. So, TECHNICALLY, you could set up a shared folder and let people access each others...
  13. MMSMSD

    Excel 2010 and Time Import from Access

    Hello, I have an Access database which I've been using successfully since Office 2003. It records dates and times. I created a query and then access that query from Excel, to print it out on specific templates. The only CUSTOM thing is that I have Excel configured to show the TIME in...
  14. MMSMSD

    DRIVER_IRQL_NOT_LESS_OR_EQUAL. Please help!

    Glad you were able to find a solution. Not sure what an 'XP' card is. There was a comment made in this thread about an XP CD, which is your original Windows XP CD. Could you have been mistaken about the name? Most "cards" in a computer are ISA, PCI, AGP, PCI-E or even PCMCIA but not XP. On...
  15. MMSMSD

    DRIVER_IRQL_NOT_LESS_OR_EQUAL. Please help!

    Unplugging the antenna does not actually disconnect the wireless adapter from your computer, so all you've been doing is preventing the card from connecting to any access point. There have been a lot of good suggestions here in terms of what I would classify as 'system maintenance' issues...
See more

Part and Inventory Search

Back
Top