Adding new server to New Admin Group?
Had a question - I have an existing exchange Administrative Group, and now
I'm adding a new server at a remote location. Whenever I install exchange,
it goes into my existing Admin group, instead of the new one I created.
Read some posts and people are saying that when I run the install, exchange
will let me choose which admin group it will go into, but that's not
happening. Any idea why? Running Exchange 2003 SP1 on the other servers,
everything is in the same domain name, just trying to separate this one out
since it's a remote site that will have it's own smtp serv...A report to show credit invoices vs. reversed (cancelled) invoices
Hi there. Here is my problem.
1-credit invoices issued to client
I generate invoices (debits and sometimes credits)to bill our customers in eSM and post them in GP/Dynamics.
When the "take the credit", on a payment check they will list the debit and the credits paid on that cash receipt. When I enter the payment in GP, I start with the credit invoices and I apply them to the debit invoices on that receipt.
2-Sometimes, after generating a live invoice, I have to reverse/cancel it (a mistake in amount, we decided not bill at that time; that invoice will not be sent...Adding Text Values
I'm looking for some assistance in writing a simple formula and I nee
I have a spreadsheet where I'm tracking types of visits. In m
MV is a Missed Visit = a value of 1
VC is a Visit Completed = a value of 1
DC is a Discharge Visit = a value of 1
We are going to enter these values into a row (A) and I want tota
these values based on this table. I know the solution is simple but
don't know how to write it.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages ...Search a user and ad it to a group in all AD domain from file
i'm tring to search a user in AD and add it to a group from a file(txt
or excel it's not important).
My problem is find the user in all OU AD.
It's possible the user is in evry OU (ex.):
I write a script for a specific OU(i know the user path and group
strOU = "OU=import,"
strOUg = "OU=Sedi,"
strUser = "CN=Bill Gates"
strGroup = "CN=grup test"
' Bind to Active Directory and get LDAP name
Set objRootLDAP = GetObject("LDAP://Root...Reporting #3
I'd really like to know how many messages are sent/received from my Exchange
2003 server. I've set up a MOM server with the Exchange extensions, but I'm
getting the "no data to report" message for all reporting.
Does anyone know an easy way to find the number of messages sent/received
...How to get query/report to show an entry if system date
It is a little more complicated than that for me atleast.
Here is the situation: I am making a "Daily Report" for our manning. We
have people go on vaction and have appointments often in our office.
I have built a database that we can enter in all of this information where
(vacations, appointments, people coming and people going, etc...)
My situation is I want to make a Daily Report to send out to each section
everyday, but I do not want everything to show up for each form on the
report. I only want what is going to affect that day.
If Jason Jones is ...Adding Autonumber with a prefix
Hope someone can help me?
I have a database with the following fields.
Trailer Sheet No. (Currently Blank)
We have a number of lorries, all with different Trailer Nos which come and
go each day.
When they are being loaded, the pallets get scanned and then placed on the
What I am trying to do is run a query that says all lines with the update
field of "0"
and a location of "PL" I want to enter an autonumber eg. PL000001.
Then when the next trailer has been scanned, I want to run the query again
which will give all th...Adding durations
I'm using excel '97.
I have a spread sheet with durations on it (vodafone) and want to add them.
Is there any way to do this?
When I highlight and hit sigma it tries to enter nothing in the top
selection instead of the total at the bottom.
Just select a cell under your data and hit the sigma.
You may have to paint the time format into it, or even format it Custom with [h]:mm:ss, to prevent the cell from tipping over at
Microsoft MVP - Excel
Microsoft MVP - Excel
I need a help, because the lenght of report - part detail is define
max probably 55 cm and I need for my form twice, can I change it
Any section in a report is limited to about 22" maximmum height. If you need
more, the trick is to add more sections.
For example, if you have a report based on a table of clients, with a
ClientID primary key, open the Sorting And Grouping pane (View menu). Choose
the ClientID field, and in the lower pane of the dialog set Yes for Group
Header and for Group Footer. Access adds 2 more sections to the report - the ...Percentages #2
I need to set up a sheet whose columns will show red when cells between
..005 and 6.99, green when >=7 and white when 0. I used conditional
formatting to achieve these results.<br><br>
However, I also need a column that will take the number of green cells
and determine what percentage they constitute of the total of red and
green cells. I used COUNTIF and divided it by number of columns to
arrive at percentage, but this is a rigid formula. I need a formula
which calculates the percentage of green cells (>=7) but which adjusts
according to the number of blank cells(0).&l...Can I use the Windows AD Migration Tool AFTER I've used the AD Connector?
I am migrating from NT/Exchange 5.5 to Windows 2003/Exchange 2003. I have
already installed the AD Connector as well as Exchange 2003 into the old
Exchange 5.5 domain. All of the NT accounts that were not in the Windows
2003 AD have been replicated into a new container. I am now ready to move
the mailboxes over to the new Exchange 2003 server. My question is..Can I
use the Windows AD Migration tool to move over the SIDs to the new AD
accounts? If I had used the AD migration tool BEFORE I had replicated
accounts using the AC connector, it would have replicated the necessary
information ...Adding SMTP addresses to multiple users
Is there a way to add a new smtp address to a group of existing users (2000+)
in an Exchange Organization / Active Directory Domain?
Why not create a Recipient Policy?
Alternatively, check out admodify.net.
MVP - Exchange
NEW blog location:
"bj" <firstname.lastname@example.org> wrote in message
> Is there a...Report, Combo Box
When attempting to create a report from a query, one of my record sources is
a combo box. When the report is generated, the field that should be populated
by the combo box text entry is filled by the primary key of the table used to
fill the combo-box.
How can I have this show the text instead?
The combo box, unless told otherwise, reads the first column that isn't 0cm
The usual format is to have the ugly ID numbers (that do all the real work)
first, then the nice non-threatening text field and then other fields if
You can change this by right-clicking on the combo, goi...Incorrect Invoice totals in SOP
I am using a modified SOP Blank Invoice report. When I print each invoice
individually, there are no issues, but when I print all invoices in the
batch, the invoice total is the total of the following invoice. the last
invoice has the correct total.
It must be something in the modified report as the original works fine.
Thanks in advance for your help.
Not discounting it may be something in the actual report....I have seen this
happen when the report worked perfectly on the machine it was originally
created on, however, behaved similarly to what you're describing on..."Group" Task Reminders
I just discovered that a Task folder in Public Folders can't have it's tasks
assigned to others. Is there an Outlook add-in available (preferably free)
that has this feature?
What we want to do is setup an application that sends out reminder that a
task has to be done, and the recipient is required to close the task when
> I just discovered that a Task folder in Public Folders can't have
> it's tasks assigned to others. Is there an Outlook add-in available
> (preferably free) that has this feature?
> What we want to ...adding lines to added data
I have added data to an existing worksheet but when
printed the row lines and column border lines do not
show. How do I add the lines to the added border to
match the existing lines?
...Group Time by Categories
I am trying to build a formula or function that will split
a start and stop time into time categories. For example,
the three time categories would be 12:00 midnight -
7:00am, 7:01am - 5:00pm, and 5:01pm - 11:59pm. If a
surgery started at 3:00am and ended at 9:00am, the formula
or function would return 4 hours for the category 12:00
midnight to 7:00am and 2 hour for the category 7:01am to
5:00pm. Would anyone have advice on grouping times by
category? Any help is appreciated.
I can help if you can have 3 columns, 1 each for your
3 time-shifts: assumming start time is in A13 ...Shifting textboxes on report after hidden
I am attempting to shift some textboxes and their associated labels to
the left on a report. Currently, I have them only appearing when a
True value is encountered by utilizing the code: txt1.visible = Nz
Each of my textboxes is labeled txt1, txt2, txt3 etc...
I would appreciate any help, as this is the final step in a project I
have built. Thank you.
If they are not visible, then why move them?
If you really need this, then share your existing code that sets the visible
Microsoft Access MVP
> I am a...Exchange Properties in AD.
I have a small problem, well at least one that might be able to be
sorted out in this forum anyway. :)
I am nearing the end of a domain consolidation project. We have been
migration users from three different AD domains to one new one. Now two of
these three were nice and simple due to their size and OU structure. The
third is a pain in the you know where.
What I need to know is what is the name of the object that I reference
to find out if a user account has forward in place for email, what is the
name of that forward and what OU is the user account in.
I have the f...Smartlist Received Not Invoiced match Received Not Invoiced report
Smartlists (at least in GP9.0) comes with query already written under
Receivings Line Items titled "Shipments Received but not Invoiced". This
Smartlist, however, does not give the same result as Reports - Purchasing -
Analysis - Received/Not Invoiced.
The difference appears to be that the report will not include unmatched
shipments from closed purchase orders, while the Smartlist will include these.
This inconsistency is resulting in many of our users being reluctant to
print their own reports and/or smartlists because of the varying answers they
This ...Sum group totals and then average by # of groups
This one seems pretty straight froward to me, but I am going wrong
I have a user who has a grouped report indicating expenses on a per month
basis. The details section shows the individual expenses, per date, within a
given month. At the end of each month there is a sum showing the total
expenses for each month. Grouped field name = "sum of amount"
The report footer has a grand total for all the individual amounts in the
What she would like to do is sum up the per month group totals, and then
have the system figure out the average of the pe...Adding Property pages from Dll?
I want to create an app that allows the user to add property pages to my
I will off course have a basic property sheet but how can I add a page
via a dll?
Would COM be what I need? I recall something like that on codeproject
but I cannot find it.
Any hint? Many thanks
I had this same requirement. I have a control panel applet that has a set of
property pages. The applet will also look for components with certain
extensions, LoadLibrary the module, and make a call into that dll via
GetProcAddress mechanisms. One of the things returned is a pointer to a
CProp...Way to mark a group of transaction as reconciled
I am using MS Money Plus Deluxe and have had a need to mark multiple cash
transactions as reconciled at one time. I have had problems with the normal
balance process of late most likey due to a problem with the downloading of
data from a brokerage account. So, specifically I am talking about cash
transactions within an investment account. To get my account up to date I
had to right click on about 30-40 transactions and select the mark as
reconciled option one at a time. It would be nice to be able to do a batch
at a time instead.
Thanks for your advice.
There is no way to d...adding sql server compact in platform builder wince5.0
i would use sql server compact in .net (c#)
what i have to add from catalog ?
- SQL Compact
- SQL Mobile
- SQL Server CE 2.0
i tried on a device to create a db via SqlCeEngine.CreateDatabase on sotrage
but i get error:
"SQL Mobile encountered problems when creating the database"
HResult : -2147024882
NativeError : 28558
there is enough space on storage card ....
You add what you want to use. SQL Compact is the most-recent of those. I
don't usually build the database into the OS, myself. I feel like I'd rather
install it to a completed device.
...Pivottable:adding grand totals
How do you add together grand totals, also would there be a way to
subtract a "grand total" from another number on another worksheet?
You can use the GetPivotData function to return data from a pivot table.
There's information here:
and in Excel's Help.
> How do you add together grand totals, also would there be a way to
> subtract a "grand total" from another number on another worksheet?
Excel FAQ, Tips & Book List