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...
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.
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Since your adapter is not N, then my suggestion won't work. I'm not sure why connecting to a different wireless router would crash the computer. Changing your router shouldn't affect the desktop computer at all. I mean, it could stop you from getting access but not crash the computer...
Does your linksys PCI adapter support N? I'm guessing that it does and there's something wrong when you try to connect with N. Try setting the Belkin router to G-ONLY and see if the computer behaves. If so, then it's either the 'N' portion of the card or perhaps a power issue when the card...
A dual-core processor will THEORETICALLY give you double the speed but it never really works like that. When a specific program is MULTI-CORE compatible, that program will use both processors and give a 'typical' real-world increase in speed of somewhere around 30% - 50% over a single-core...
If it's the same users that seems to run into this problem, then I would suspect their profiles or security rights as the issue. The issue is not limited to one machine, and you can (at least temporarily get around it) so would NOT recommend messing around with the computer and its domain...
So, with the laptop, everything was working fine until you put the machine on the domain? Are you perhaps using roaming profiles? There may be something unique (such as shortcuts on the desktop to network paths or USB devices) about those users that is causing the system to lock before the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.