upgrading the OS on Exch2003 box
I have successfully upgraded Exch2000 to 2003.
The OS is still Windows 2000 Server.
Now I'm ready to upgrade that box to Windows Server 2003.
Is there anything special I should note before upgrading, or is there
a specific document which addresses any known method or problems ?
"chrism" <chris@no_spam> wrote:
>I have successfully upgraded Exch2000 to 2003.
>The OS is still Windows 2000 Server.
>Now I'm ready to upgrade that box to Windows Server 2003.
>Is there anything special I should note before upgrading, or is there
I would like to do a combo chart. Any ideas?
Plot all the data in a chart using the chart type you want to use for
most of the series. Select one series you want to change, choose Chart
Type from the Chart menu, and pick the chart type you want for this
series. Repeat for any other series you want to change.
Excel offers some built in combo types, but it's easy to make your own,
and you can be much more flexible this way.
Jon Peltier, Microsoft Excel MVP
> I wou...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...What is 'Align Text to Base Line Guide'?
Trying to make sure all lines have the same amount of space between them I
selected paragraph from the format menu and under the line adjustments there
is a box 'align text to base line guides' Ok I did that, now there are lines
at the margines of my newsletter. What are these? Also selecting this pushed
my text down from the top edge of the text box. What is this?
The baseline guide measurements are in the Arrange, Layout Guides, Baseline tab.
There is help in the Help menu.
"Go_Girl3647" <GoGirl3647@discussions.microsoft.com...How to create an "and" rule in Query Based Distribution Groups
With Exchange 2003 Query Based Distribution groups, is it possible to create
an "and" rule? ie, all users who are based in "London" "and" have the first
Please reply to news group only. Thank you.
"Curtis Fray" <firstname.lastname@example.org> wrote in message
news:OjVc...outlook 2003sp3: applying the inbuilt junkmail filter on existing messages?
would like to apply the outlook junk mail filter, with settings set to
'high', on emails already in my inbox. is there any way of doing this?
apologies if this has been posted before, I've made a couple of
searches but can't find anything...
No, there's no way to apply the spam filter to already downloaded items.
<email@example.com> wrote in message
> hi all,
> would like to apply the outlook junk mail filter, with settings set to
> 'high', on emails already in my...Delivery Options Does Not Show Up.
I need to setup an alternative recipient to one of my mailboxes but I can't
seem to find the Delivery Options Button under "Exchange Advanced" tab of
I can only see three options:
What am I missing. It should be there.
Thanks for your time
it's on the Exchange General tab...
Susan Conkey [MVP]
"Percy" <Percy@discussions.microsoft.com> wrote in message
>I need to setup an alternative recipient to one of my mailboxes but ...get rid of macro option at startup
I created and then deleted a macro in an Excel file.
Why do I still get the warning box (i.e. the one asking if I want to enable
or disable macros) when I open the file?
Is there a way to get rid of this since I no longer have macros in this
You need to delete the empty module.!
"Brad Rench" <firstname.lastname@example.org> wrote in message
> I created and then deleted a macro in an Excel file.
> Why do I still get the warning box (i.e. the one asking if I want to
> or disable macros) when I o...How to write a new entry in a combo box to its underlying table
Dear Access 2007 VBA Gurus,
I have a assets database (rather uncreatively named "Assets"). I use a form
(named "Asset Acquisition Input Form New") to enter new assets. The
"Manufacturer" field (combo box name "Manufacturers_ID) on this form is a
lookup to a Manufacturers table. What I want to happen is when I enter an
item that is not in the lookup list, I want a message box to prompt me to add
the new entry to the underlying table, or to cancel and select an item from
the list. I have no trouble with the MsgBox command itself. What I don&...Intelligent Message Filter Installation Failure
I've tried installing the Intelligent Message Filter on a
Windows 2000 SP4 Exchange 2003 SP1 server. The
installation fails at around 98% with the following
error: There is a problem with this Windows Installer
package. a program run as part of the setup did not
finish as expected. contact your support personnel or
I tried downloading it again, and had the same results.
...Excel 2003 Copy/Paste filtered column
I have a filtered column on my spreadsheet. I have copied the column,
changed the figures and then tried to paste it back on to the filtered
column. It is not copying over the original filtered column but rather over
cells that have been filtered out. The worksheet/cells are not protected.
What could the problem be?
That's the way pasting works. It'll hit the visible and hidden cells.
> I have a filtered column on my spreadsheet. I have copied the column,
> changed the figures and then tried to paste it back on to the filter...Intelligent Message Filter (IMF) SCL for Junk E-mail being ignored
I have Exchange Server 2003 Enterprise SP1, and I recently downloaded and
installed Intelligent Message Filter.
In Message Delivery Properties -> Intelligent Message Filtering, I have
- Gateway Blocking Configuration
- Store Junk E-mail Configuration
All users have Outlook 2003 Professional installed.
Although I have SCL set to 8 for "Store Junk E-mail Configuration", Messages
with SCL 6 and others with SCL as low as 3 are being sent to the Junk E-Mail
I am able to see the SCL of the emails because I installed an SCL Column via
Forms using th...tbBox options
In the XML files, for the <BORDER> tags, tbBoxColumns forms a border on
either side of a cell, tbBoxRows forms a border above and below a cell. What
option forms a border on all 4 sides of the cell?
hi you can use
<BORDER> tbAll </BORDER>
> In the XML files, for the <BORDER> tags, tbBoxColumns forms a border on
> either side of a cell, tbBoxRows forms a border above and below a cell. What
> option forms a border on all 4 sides of the cell?
...Payables Trial Balance Report with Options
I am trying to run an A/P Trial Balance Report today that will give me the
A/P balance at January 31, 2007. I keep getting the balance as as February
28, 2007. I've run the same report for A/R and am able to get the balance as
at January 31, 2007. Currently using GP 9.0. With my previous employer who
was also using GP 9.0, I sure that we were able to run an A/P Trial Balance
report for a previous period. Does anyone have any suggestions as to what I
my be missing or what may be set up incorrectly?
The only date that you can spcify on the Aged Trial Balance With
Options, ...selecting a cell
I seem unable to select a single cell, or a single row--click on one in the
normal manner, and the two below also highlight, then delete or whatever
command is given. If I input a number/text, that just goes into the one
cell. tapping F8 increases this to two wide and three high automatically
Also, very slow to do almost anything.
Are you by any chance using Excel 2007? If so there is a known bug that
causes multiple cell selection and I understand this has been reported to
If you take the zoom level up and down this is reported to cl...E-mail box sizes. Echange System Manger.
Now and then I need to find out the size of the various e-mail boxes in
Exchange2000. The problem is that the size indicated in the Exchange System
Manager do not reflect the same size when you look into Outlook.
Is the a way to figure out the correct e-mail size?
If not. Is this better in Exchange2003?
Thank you in advance.
I'd consider the Exchange value to be the most important given this is what
will be used for mailbox quotas, etc.
"Dag N" <email@example.com> wrote in message
> Now and then ...Junk E-Mail filter unavailable in online mode
We had Outlook 2003 clients on an Exch 2000 server, and, as expected, the
Junk E-Mail filter was not available when working in online mode. In cached
mode it was working fine. Now, after upgrading the organization and server
to Exch 2003, the Junk E-Mail filter is still not available in online mode.
According to all the MS documentation this should be working.
All of the documentation that I have know of says that it works on in Cache Mode. Can you give us a link to the documentation that you saw that shows it will work with online profiles?
Matth...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....Routing Restrictions button unavailable (gray) no matter what options selected in IMS-->Routing tab
I am running Exchange 5.5 SP4. In Connections-->IMS-->Routing Tab, my "Routing Restrictions" button is unavailable (greyed-out) no matter what options I select. Any suggestions? Thank you.
Try installing Exch Admin prog on other machine, apply SP4 and see if
you can change it from there. Post back with details.
> I am running Exchange 5.5 SP4. In Connections-->IMS-->Routing Tab, my
> "Routing Restrictions" button is unavailable (greyed-out) no matter
> what options I select. Any suggestions? Thank you.
...Highlight color for selected items
How can I find out what color is used for highlighting
selected items (for example in Windows Explorer)on a users
Normally it is a blue color, but a user can change that.
"Urban Olars" <firstname.lastname@example.org> wrote in message
> How can I find out what color is used for highlighting
> selected items (for example in Windows Explorer)on a users
> Normally it is a blue color, but a user can change that.
See if it's GetSysColor/COLOR_HIGHLIGHT.
Jeff Partch [VC++ MVP]
Take a ...Enable/Disable a Form Control Based on Security Group Permissions
How do I enable or disable a control in a form based on a user’s security
group membership? For example: If I have a checkbox on a form (call it box1),
I want box1 to be enabled if the user who opened Access is a member of a
security group called “Breaker Test Admin.” For members of any other group
(except of course “Admins”), box1 should be disabled.
Thank you, for your help!
On Mon, 02 Jul 2007 18:57:13 GMT, "BenS" <u35527@uwe> wrote:
>How do I enable or disable a control in a form based on a user�s security
>group membership? For example: If I have a checkbox on a ...How to return the primary key from a combo box
I have a table containing two columns
Column 1: Primary key
Column 2: Name.
I want to create an unbound combo box that shows the name but returns the PK.
I have these properties set:
Control source: <is empty>
Row source type: table/query
Bound column: 1
Row source: <I have a select that returns the desired records>
In cboClient_AfterUpdate() I look at debug.print cboClient.Value and I see
the name. I need the PK so I can construct the query for the next combo box.
How do I get the PK
Thanks for the help
Message posted via http://www.accessmons...Simple Yes/No drop down box
Hi, I am looking to create a simple drop down box which has yes or no as the
options. For the life of me i can't remember how to do it.
Select the cell and then click on Data | Data Validation. In the
dialogue box for Allow click on List, and then in Source you can type
"Yes,No" (without the quotes) and ensure that In-cell drop-down is
checked. Click OK and then you have it.
Hope this helps.
On Apr 21, 9:41=A0am, Debi <D...@discussions.microsoft.com> wrote:
> Hi, I am looking to create a simple drop down box which has yes or no as =
...EXTRACTING UNIQUE RECORD BASED ON CONDITION
This is a multi-part message in MIME format.
I would like to extract unique records based on a condition. For =
example, how to extract unique record from column 'B' when column 'A' =
has "AP" or any other desired condition.
The data is as follows:
A B =20
AP PATRICK CUDAHY INCORPORATED=20
AP PATRICK CUDAHY INCORPORATED=20
AP SUGAR CREEK ...creating nested formulas from drop down box
Hi, I have cell A1 with a drop down box containing 26 available choices. B1
has the dollar amount matching to the choice in A1 using vlookup. E1 totals
several cells including B1 together. I want F1 to look at A1 and either
enter the number from E1 or NA. Here's billing example:
A1=January , B1=$5 ,C1=$10, D1=$1, E1=$16 (total of b-d1)
F1 is the column for January
G1 is the column for February
H1 is the column for March, etc
If A1 = Jan, then F1 should be $16
If A1 = Feb, then F1 should be NA or $0
This is the formula that has been working so far: