Multiple user names at one bank or brokerage
I have 3 accounts at one bank. I have 3 corresponding accounts set up in MS
Money 2007. One of them is setup for online banking while the other two are
not. I now want to set the other two up for online banking but I can't find
a way to specify the unique login info for each of the other two accounts.
...Access 97 Runtime question
We are using Access 97 runtime for some of our staff.
I noticed today that in reports if they right mouse click, they don't get a
shortcut menu. I want them to be able to Export the report they are viewing.
Would Access 2003 runtime have the shortcut menu?
"Kelvin Beaton" <kelvin dot beaton at mccsa dot c o m> wrote in message
> We are using Access 97 runtime for some of our staff.
> I noticed today that in reports if they right mouse click, they don't get
> a shortcut menu. I want them to be...Optimiztion question
I was looking at MSDN on optimizing queries
(http://msdn.microsoft.com/en-us/library/ms998577.aspx) and am unclear as to
why a foreign key relationship affects the query in this case. At the
beginning of the article it gives an example and starts out by saying:
The sample screen shot in Figure 14.2 shows an execution plan that accesses
only one table, although two tables are included in a join in the query.
Because there is a declared foreign key relationship between the authors
table and the titleauthor table, and the au_id column in the titleauthor
table is not allowed to b...Multiple Domain e-mail addresses
We are running Exchange Server 2003 Enterprise addition and I am having a
bit of a "brain-freeze" at the moment... Where in the Exchange Admin do I
configure the server to accept e-mail from more than one domain. For
example, we currently accept e-mail from mycurrentdomain.ca and would also
like to accept email from mycurrentdomain.com. Please note that I have
updated all of our DNS MX records as required, just need to make the changes
on the Exchange server. Thanks in advance...
Recipient polices-email address policy.
"Raymond Spitzingle" <ray(nospam)@stuff...How do I merge two publisher files?
I am using publisher 2003. I am creating an 80 page catalog. I like to save
page 1-10 as file one, pages 11-20 as file two and so on. When I am finished
with my catalog I need to send one file to the printer. How can I merge all
of my pages together in one file?
Copy and paste. Or if you have Acrobat (not just the free Reader) you can
create a single .pdf file with the parts.
MVP Microsoft [Publisher]
"screnda" <firstname.lastname@example.org> wrote in message
>I am using publisher 200...Using two conditions in a formula
How do I write the following formula:
I am in cell I6
If g6 AND h6 is blank, then blank, else I5 minus g6 plus h
Richard Pitt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1533
View this thread: http://www.excelforum.com/showthread.php?threadid=27042
In cell I6, enter the formula:
Though you don't check for case when G6 is blank and H6 isn't, etc.
MS Excel MVP
"Richard ...Macros/Signatures Question
I have an Excel Workbook that I created for a PC Order Form. I set it up to
only make certain rows visible based on the Machine Model that they choose.
I digital signed the Worksheets and exported the Digital Signature
Certificate and installed it on the User’s PCs. The code works great. The
user opens the Workbook and it runs the Macros with no problem. The problem
I have is when the user goes to save the Workbook. They get an error that
“Excel can not sign VBA macros when saving to this file format. Do you want
to remove the digital signature and continue saving this workbook?”...Windows and Mac have two distinctly different units for column width.
Operating System: Mac OS X 10.5 (Leopard)
I am trying to format columns for some data I am entering in a spreadsheet and when I enter "15.00", which is the required width for these columns given by my professor, I end up with a column 15 inches wide. What I would prefer is for the options to be like the default options in Windows version of Excel. In Windows version of Excel, when you hover over the lines between the columns it gives you two numbers (e.g. 8.43 (64 pixels)). These are the default numbers for column width in Windows Excel....I cannot paste from one workbook to another. Copy works, paste do.
When I attempt to copy from one workbook and paste into another, copy appears
to work but paste does not. The paste menu item is grayed out in the
workbook to which I attempt to paste.
Are there setting that can be changed to aloow the paste??
Check to see if either workbook and/or worksheet is protected.
If so, unprotect. Then Copy/Paste should work.
BTW, how are you copy?paste(ing) Tab or content?
> When I attempt to copy from one workbook and paste into another, copy appears
> to work but paste does not. The paste menu item is grayed out...Simple IMAP question
How do I enable shared calendar with free/busy information through IMAP ?
When I add the "calendar" folder in IMAP it displays as a mail folder, not a
Is this calendar a mailbox or public folder?
Why are you using IMAP instead of MAPI? MAPI is much more feature complete
as it applies to this sort of thing.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Pierrot Robert" <email@example.com> wrote in message
> How do I...Exchange 2003 Question??
I would like to know if there is an upgrade path from Exchange 2003 Standard
Edition with SA to Exchange 2003 Enterprise Edition with SA? Thank you.
This might help
"KA Kueh" <firstname.lastname@example.org> wrote in message
> Dear all,
> I would like to know if there is an upgrade path from Exchange 2003
> Edition with SA to Exchange 2003 Enterprise Edition wit...Unable to delete the Dead Domain controller
Iam working on windows server 2008 Ent Ed I have two doman controllers in
the domain both are GC but only one domain controller has all the fsmo roles
but iam having replicattion problems with the dead DC (i.e mppkw-database)
and Iam unable to delete or remove the dead domain controller from the domain
and iam having follwing problems using the ntdsutil :-
select operation target: list domains
Found 1 domain(s)
0 - DC=mediaphoneplus,DC=com
select operation target: select domain 0
No current site
Domain - DC=mediaphoneplus,DC=com
No current server
for one week now, my exchange 2000 server crashes nearly every night at
random time, the only solution to have it all restart is to restart the
In the application log, multiple error events are reported like these :
Event Type: Error
Event Source: Userenv
Event Category: None
Event ID: 1000
User: NT AUTHORITY\SYSTEM
Windows cannot establish a connection to *domain name* with (1364).
Event Type: Error
Event Source: Userenv
Event Category: None
Event ID: 1000
User: ...IDN/ACE domains
Does anyone know if it's possible to have ACE/IDN domains in Exchange 2003 ?
I want to have a domainname with norwegian characters in exchange but I
doesn't allow me to type norwegian characters in the email-tab in active
directory users and computers.
Any ideas anyone ? Third party plugin ?
...Combine small documents into one master document
I currently have an "engagement letter" that is created for our clients to
set the expectations for our business relationship (I work for attorneys).
We have about 10 different paragraphs that may be inserted into the letter
based on different factors (3rd party payor, if a retainer is required,
etc.). So I start with the basic letter and then have a userform with
checkboxes where you can select the text block options (stored in Autotext).
When you click OK the various paragraphs are inserted at bookmarks.
While this works, I find working with Autotext cumber...out side domains
I can not send emails to persons that do not use the same
domain ISP. I recieve this message when i try to
our message did not reach some or all of the intended
Sent: 18/04/2004 8:43 PM
The following recipient(s) could not be reached:
email@example.com on 18/04/2004 8:44 PM
550 5.7.1 <firstname.lastname@example.org>...
Relaying denied. IP name possibly forged [22.214.171.124]
Has anyone got any ideas
Have you set your server settings to authenticate before sending?
Milly Staples [MVP - Outlook]
Post...Filter two columns with criterion applying to one or the other?
I am looking for a solution to the following filtering problem:
I have two adjacent columns, so using a filter for both of them is no
problem. But what I want to do and don't know how to do is this:
I want to filter for values greater than x (a certain number, in my
case 5000) in any of the two columns. I can filter both columns for x
greater than 5000 but that filters out more than I want because there
may be some cells with a value greater than 5000 in only one of the
Is there a solution to this problem (using Excel alone or an add-on)?
you can use th...Excel2000: Strange behaviour for one cell in workbook
There is a Excel workbook used for registering working time in firm
departments, created earlier. The worksheets are protected, and I don't have
the password, as author isn't working here anymore. The workbook is stored
as read-only on network resource, and monthly every department is copying it
to local computer and filling the table.
The table's body has 2 rows data for every employee with 31 columns for
month's dates, and several protected summary columns. For every date,
working hours or some code string is entered into according cell. One of
codes, and ...Vlookup, multiple times in one column summing corresponding
I have a list that contains common invoice numbers that appear multipl
times in column A and need to use the vlookup function to find and su
the corresponding amounts in column B.
As you would be aware the following vlookup functio
=VLOOKUP(A3,DATA,2,FALSE) will only return the one amount once i
reaches a match and I need it to continue down the column and sum al
matching invoice numbers.
Column A Column B
145880 80.87 *
145880 54.09 *
The answer I�m looking to return is
It has to be a vlookup sty...using domain account for Exch2003 services
In Chapter 3 of the MS Press Training Kit "Implementing and Managing
Microsoft Exchange Server 2003", there are instructions for changing the
Exchange Services to run under a domain account (with appropriate group
memberships and rights) rather than the default Local System account for
security & auditing purposes.
However, I could not start the services after making the change and reviewed
several articles stating that only the Local System account will work - KB
Articles 271920, 239762, etc.
Is the training kit wrong, or is there a way to do this?
thanks in advance,
...One front-end server multiple back-end servers
I was wondering if someone could help with the following scenerio and make
some suggestions as to an answer.
We have 3 exchange AG groups. 1 AG group has 3 exchange servers in it, each
located in it's own AD domain. 1 AG group has one exchange server in it, it's
in its own AD domain. Thirdly, the last AG group has 2 exchange servers in
it, both are in the same AD domain. 1 of these 2 exchange servers in the
final AG mentioned is a front-end server, that should be supporting all the
exchange back-end servers.
The problem we are facing is that when a user from any of the ...Filtering question
Is there a way to expand the filter option so that it shows 1 row (or more),
both above and below any row that contains the value I am looking for?
Data|filter|autofilter examines each cell/row on its own.
Maybe you can put the key value for each group on the rows you want. Then
filter by that column.
> Is there a way to expand the filter option so that it shows 1 row (or more),
> both above and below any row that contains the value I am looking for?
...Re: limit numbers of connections to one server
hi there :-)
my pop3 server is limited to 10 query per sec. and per ip. i have abou
16 mail-accounts on this server. the last 6 allways error with timeou
is there a way to limit the number of connections to one server i
outlook 2002 on windows xp pro?
thanks a lo
Posted via http://www.mcse.m
View this thread: http://www.mcse.ms/message674073.htm
Set your send/receive settings to consecutive mail checks, rather than
conc...Macro Question #10
I am working with a text file that I imported into Excel.
It is a transactional report of sales by customer. The
data will have the customer number and name spread out
over three cells. What I want to do is to create a macro
that will contatenate all three cell and then perform a
paste special and paste them into another cell in another
column. Since the number of transactions by customer can
vary the customer name and number can appear anywhere on
I created a macro to do this using the first customer
which appears in cell B5 through D5. The next customer
appears...question about leaving messages on server
My husband and I have 1 POP mail account. I am accessing it from a
computer in Virginia, where I'm staying with relatives. He is accessing
the same account from California. I have my Outlook set up to keep
messages on the server, but to delete them after 1 day (so that he will
still get the messages, but the server won't get clogged). His email
program, Eudora, is set up so the messages will be deleted from the
server after he downloads them.
Is there a chance I won't get some messages because he has his computer
set up that way? (He downloads it 1st, then it gets deleted off serv...