Recent content by NerdyOne

I need to find the minimum value in a date range in my spreadsheet. The worksheet has 17691 records, each record represents a 15 minute (in chronological order) snapshot for the value we're recording. That equals to about 6 months worth of 15 minute snapshots. What I need to do is find the...

We're a small shop that grew from just a couple of computers. That's the main reason why. Also, we started using SMS for remote control puproses, and if we had to change an IP address, then the client wouldn't update quick enough for SMS to recognize the change. Now, I'm TOLD, that the new...

Awesome, thanks! :) Also, I'd like to report that the script ran perfectly. Now, we're able to power down our primary DNS server and know that our secondary will answer DNS requests! The Titanic was built by engineers. The Ark was built by an amateur.

I found a solution using a startup script and the netsh command to set the ip address for my "Local Area Connection". This is a handy tool for networks, like ours, who do NOT use DHCP. The Titanic was built by engineers. The Ark was built by an amateur.

I created a group policy that sets the DNS settings for our computers. The GP is attached to the OU "Contoso Computers". The policy has been applied and verified using the gpresult.exe command. Even my clients registry shows the correct (and new GP) settings. Now comes the funky part. If...

I have an Access database stored on a shared drive that is accessed from various office locations. From day one, the database has worked fine for the 20+ users who use it. Now, all of a sudden, one particular user is having a problem clicking a button that emails a report from a form. The...

John, Thank you for your help, you've certainly pointed me in the right direction! The only problem I've run into is, within the VBA, it says that IncRID=empty. Therefore it saves the file as 0.doc. I'm trying to think of a way around that. The Titanic was built by engineers. The Ark was...

Okay, I'm a little dense I guess. Could you elaborate on what you mean by "Look at the Fields collection"? The Titanic was built by engineers. The Ark was built by an amateur.

I have a document template that I created to issue work orders with. The data in the template pulls codes from a separate application using field codes: (i.e. { QUOTE IncRID \* MERGEFORMAT } My question is; how do I write a script/macro that uses that field "IncRID" as the filename? For...

Recently we installed a new Windows 2003 Enterprise server. We've changed the group policy to re-direct My Documents from "server1" to "server2". The group policy is based on the Users organization unit. Everyone's My Documents moved over pretty good (as can be expected). Now here's my...

Zelandakh, You're right, the server is straddling both. The good news is I was overlooking one important step. I didn't know to run the /domainprep from the Exchange CD on the new domain. Now I can I migrate the exisiting users from the old domain and into the new one. But I haven't found...

They are on the same LAN, but on different subnets. one.example.com is 192.168.60.x (Exchange & 7+ servers) two.example.com is 192.168.70.x (new domain & 1 server) We have the second domain seperated out for organizational and security purposes (sensitive data). That's the reason they're on...

I forgot to mention... The trust has been established and validated (it's a two-way trust). Also, I gave it over the weekend to replicate so I'd hope it would have worked this morning. ADUC for two.example.com shows the correct mailbox store and all, but it's just not authenticating. The...

Very good. I believe, after reading everyone's response, that it should go pretty good. The last thing I want to do is have to visit every client and type in the new server name. Thanks, again, for all your help! The Titanic was built by engineers. The Ark was built by an amateur.

I have an Exchange 2003 running in one domain, called one.example.com. I created a new domain in the same forest called two.example.com. Then I used the ADMT to move the user accounts from one.example.com to two.example.com. From a local PC, I logged into the new domain and try to configure...