4,118 reputation
144697
bio website security.stackexchange.com
location Florida
age 32
visits member for 3 years, 11 months
seen 7 mins ago

I'm not the droid you're looking for.


Aug
1
comment Excel date & time formula-round up cell value
Without having to do the calculation yourself, you could do +TIME(0,1,0) instead.
Aug
1
comment View the current day in the taskbar
@AndreasRejbrand Oh, you're right! I guess I never really noticed that since it's one of the first things I do on a new system - I do it more for the optimization of horizontal space on the taskbar than for date/time formatting.
Aug
1
comment View the current day in the taskbar
Confirmed. It's Aero. You need three rows without, but only two if it's on. Apparently, everything down there is bigger with Aero, so there's more room.
Aug
1
comment View the current day in the taskbar
@AndreasRejbrand Oh, cool. So I'm not insane. Now I'd just like to figure out why it takes 3 rows for Scott when 2 works fine for me. I'm guessing it has something to do with Aero, but that seems odd.
Aug
1
comment View the current day in the taskbar
(i.e.: I presume inclusion of the day-of-week abbreviation in the tooltip is automatic regardless of date/time format settings, but I'm not sure why this does not appear to be the case for @AndreasRejbrand.) I'll have to do some more testing on one of my VMs later.
Aug
1
comment View the current day in the taskbar
Two rows work fine for me in Win7 with Aero, and I just double-checked my regional settings to make sure the short date format wasn't changed on this system. Also, my tooltip does show day of week for additional clocks. The lines in the tooltip are, in order: Local Date, Local Time, (Add'l Clock 1), (Add'l Clock 2). The local date appears to be in "Long Date" format, and each time is represented as ddd HH:mm (e.g.: "Fri 11:44"). The time portion of the times in the tooltip appear to match my "Short Time" format, but I don't see where I've set the abbreviated day of week to be included.
Jul
31
comment Windows 7 loses all network connectivity after screensaver is disabled
Alternately: Does this happen when you're not using the VPN also?
Jul
31
comment Windows 7 loses all network connectivity after screensaver is disabled
Sounds like it might be an issue with the VPN software. If it's configured to drop the VPN when the user is away, it might be triggering after the screensaver. (Unlikely behavior, but not improbable.) Once the VPN drops, everything relying on network connectivity will drop as well. Depending on how long your system takes to switch from the VPN to the normal network configuration, some applications may not be able to tolerate the momentary loss of connectivity. See if there's anything about power saving or idle timeouts in the VPN client configuration or connection profile.
Jul
31
comment Two users on Windows 7 connected to different networks?
@Drake Ok, it looks like we need more information on how your networks, systems, and services are setup. Typically, a VPN would involve your computer connecting to another private network and using that tunnel to access any resources within that network. The systems/services available on the remote network are usually not exposed to the public with the private IP, let alone done so in a way which might prevent private network users from connecting to the public service. Also, this is really starting to escalate to the level of a Server Fault question. (Please don't cross-post. Request migration.)
Jul
31
comment Install Windows 8 to last partition on drive
@Ramhound I'm fully aware that Windows works fine with other OSs (I've done a few dual-boot systems myself), and I'm sure Microsoft isn't actively trying to prevent dual-booting. However, this doesn't mean they're going to go out of their way to make dual-booting any easier either. This is why dual-boot schemes involving Windows always go easier when Windows is installed first and why, as YtvwlD mentioned, to do otherwise requires (at minimum) that you re-install the boot loader after Windows is installed.
Jul
31
comment Two users on Windows 7 connected to different networks?
@Drake In that case, we'll need information on the VPN client and server software to guide you on how to enable split tunneling. (Or Google will probably be helpful enough, now that you know the search term you need.)
Jul
31
comment Two users on Windows 7 connected to different networks?
@heavyd By my understanding, the access privileges of User A & B are not relevant - the separate user accounts were simply being created as an attempt to work around the restriction caused by split tunneling being disabled. What Drake simply wants to do is to be able to access everything on the local network while also being connected to the VPN, and I'm sure having to switch users to do so is an inconvenience which he'd rather avoid.
Jul
31
comment Install Windows 8 to last partition on drive
@Ramhound Ok, to be more clear: Microsoft wants Windows to be the only OS you use, so (at least historically) Windows installation processes were made with the assumption that this would be the case.
Jul
31
comment Install Windows 8 to last partition on drive
If I was sure there was no way without wiping the drive first, I'd have made that an answer. Chances are, there are indeed some workarounds for this. My comment was just to note, for future reference, that setting up a clean system for dual-boot usually goes best if Windows is loaded first.
Jul
31
comment Install Windows 8 to last partition on drive
Windows wants desperately to be the only OS on the system. The easiest way to do a dual-boot install is always to install Windows first.
Jul
31
comment Two users on Windows 7 connected to different networks?
What you're looking for is called "split tunneling" and is commonly disabled in the VPN policy for security reasons. Contact your organization's IT Security department for more information. Without violating security policy, you won't be able to get the same system talking to both the VPN and your local network at the same time. A common workaround, as you've apparently discovered, is to run the VPN on a VM and use the host computer for access to the local network. Or, just use two wholly separate computers.
Jul
31
comment Create New Spreadsheet of data from many Excel workbooks
Are you looking for a one-time consolidation, or do you want to continue updating the individual sheets and have those updates pushed to (or pulled by) the master?
Jul
31
comment Connect to Windows Server 2012 Essentials without creating new user login for Windows
I've flagged the question for migration. This will require either moderator action, or concurrence by four other users with close-vote permissions. Please be patient.
Jul
31
comment Connect to Windows Server 2012 Essentials without creating new user login for Windows
There are ways to migrate local profiles to domain profiles. Have you considered that? This sounds more like a problem for Server Fault - please don't cross-post, we'll see if it needs to get migrated.
Jul
31
comment Connect to Windows Server 2012 Essentials without creating new user login for Windows
This depends on which SQL database application you're using, and how it's configured. At the very least, you will need to configure a user account in the database for the user.