Search results for query: *

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

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

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

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

Currently we have on Exchange 2003 server in our domain. We want to retire that old server and fire up the new one. What would be the best, in general, way to do that? We don't want to have to reconfigure all the Outlook clients to point to the new server. And, if at all possible, can the...

Please correct me if I am wrong with my steps to install the remote control agent on a Windows XP sp2 machine. We browse to the SMS server and double click the shared folder "SMS". Inside that is a folder named "Client" and "i386". Then we double click to run the client.msi. The program runs...

We are running on a rebuilt CCM version 4.1(3)sr4d. For some reason or another, one of my Attendant Consoles is connected to the CallManager just fine. The other, however, does not. I get logged in, but the Call Control Up does not initiate. All it says is "Trying...". Now, I inherited this...

Previously we were running SMS 2003 with a site code of COB. Then we had to re-install SMS and gave it a site code of (can you guess?) "SMS". Now we are able to remote control the OLD clients, but any new computers we add to the network will not work. We get the usual "Remote Control Agent...

I have a report that list phone calls to and from. For the life of me, I can't figure out the formula that will count the total number of records that contain a certain phone number. In Expression Builder, I tried the following: Count ( [callingPartyNumber] ) =1351 Wouldn't work!

I am have a form with a drop down list of departments. After completing the form, you click on a command button that runs a macro. The macro is set to email the report. My question is, is there a way to have Access look at which department is selected in the form and fill in the email address...

I have a spreadsheet that is generated weekly with a presentation form in front. I need a cell to reference sheet1 and subtract the bottom value from the top value. The problem is one week there may be 4,000 records and the next week there may be 5,000 records. So what formula could I use to...

I'm working on creating a form for our administrative assistant to use over and over again when emailing our building department. It's a pretty simple form with 4 user defined fields. The fields are: Permit # Location: Name: Place: I've got the form published and it will email to the...

I have 7 tables in my database. Table 1 is the "master" that lists all of our accounts. Tables 2-7 are those accounts divided up by zone. What we are trying to do is (for example) have table 2 look at table 1 and if the account numbers match then pull 3 fields that are unique to only table 1...

Heres the breakdown: Two tables Receipts_table and Categories. Within the receipts_table are several fields, two of which are called For and For_Account. The For field is a combo box lookup bound to a field in the Categories table called Category_Name. I need the For_Account to be populated...

I have a hum dinger of a report I'm trying to run. I will try to be brief with my description. One report called Cash Collection Report. Within that report I need to have several different totals in it. I have a single table with 4 fields I need to query from. They are: Receipt_NO (unique ID...

I have an unbound field with the calculation of =IIf([Tax_Exempt]=0,[Account_Total]*0.065,0) How do I take that value and store it in the table in the field called Tax? I need the value stored into the table so I can call upon it later in a query. The way the form is set now, the tax is...

I have a field on a form that is calculates tax on another field called Account_Total. Right now, the calculation in the Tax field is as follows: This is the event procedure for the form's Op Open event: If Me.Check20 = False Then Me.Tax = Me.Account_Total * 0.065 Else Me.Tax = 0 End...

How do I format an autonumber field to show the year plus an number that increases for each new record. I've tried typing the format as yyyy but it does not display the year correctly. Basically, the field is Receipt_NO and I want each new record to have a unique receipt number that is...