How do I apply a combo box to multiple cells in Excel so that it .
I would like to apply a combo drop down box in Excel. However I only want
the box to appear when the cursor is over the cell can anyone offer me some
help on this matter?
Perhaps you are looking for Data Validation, available on the Data menu.
See Debra Dalgleish's tutorial at:
"DB" <DB@discussions.microsoft.com> wrote in message
>I would like to apply a combo drop down box in Excel. However I only w...Apply view to all folders
A user has numerous folders created under her Inbox in
Outlook 2000. She woule like to create a custom view and
then apply it to all folders automatically.
I can create a custom view easily, but can't find a way to
apply it to all folders other than on a one-by-one basis.
Is there a way to apply the view to all folders at one
You can't apply it to all at once - unless you customize the Messages view.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Gu...Downloaded Transactions not matching correctly, non-downloaded transactions showing up with 'E' status when they shouldn't
I recently did the cure-all of 'Remove all bills data' and I've regularly
repaired my file. But I'm still seeing an issue of data not matching, and
manually entered transactions mysteriously showing up with 'E' or
Here's what I think is going on:
1) I enter a bill into my register. It shows up un-reconciled.
2) I download a statement from the bank, and this includes a transaction
that matches the bill entered in step 1 perfectly (date, amount anyway)
3) I go into the register, and Money has *not* matched the downloaded to the
ex...Is there Smartlist Builder Template for GL Account Transactions???
I know from Partner Source Smartlist Builder templates can be downloaded, but
I do not see one for the "Account Transactions" smartlist in the Financial
Does anyone know if a Smartlist Builder template is available for download?
We need to modify the canned Account Transactions smartlist using Smartlist
Builder. Having a template would be very helpful instead of starting
everything from scratch.
On Disc 2 of the install CDs, in the Tools>Dex>Doc>PDF folder, there=92s
called IG.pdf, which is the Dexterity Integration Guide. There=92s a
What does the following WLM beta message mean?
View applied not connected to imap4.xxxxxx.co.uk
I had already clicked on this account and a couple of emails were
...payroll integration with payables
Hello, I keep reading about payroll integration with payables and I saw some
screenshots of the "payroll vendor setup" window to set this up.
However I am having difficulty finding documentation or "how to's" on this
new feature or how to find it on GP10.
I did find a cnk file that installs "payroll extensions" which gives you
this feature. However, I am still trying to figure out how this prices out.
Is this part of advanced payroll? (which costs extra). We are contacting
microsoft and I'll give you an update.
--...I've applied a Fill and now can't see the gridlines....
Does anyone know how to show the Gridlines through a fill? I've searched and
searched but can't find the answer, yet the silly thing is I know it can be
done as I have done it before (by accident)
Any help mostgratefully received!
In article <62E1EA83-287A-4FE3-BEC6-7C0155EA1850@microsoft.com>,
"FizzyBunghole" <FizzyBunghole@discussions.microsoft.com> wrote:
> Does anyone know how to show the Gridlines through a fill? I've searched and
> searched but can't find the answer, yet the silly thing is I know it c...Not receiving email in outlook #2
About 1 month ago, Email was no longer being received in my Outlook inbox. I
can still read my emails via Hotmail . After lots of frustration, I have not
been able to resolve. Any suggestions?
Any error messages ?? Post it here . Also describe what happens
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"Chris" <Chris@discussions.microsoft.com> wrote in message =
> About 1 month ago, Email was no longer being receiv...M2005 Cannot Apply Epayment To Invoice
This is a multi-part message in MIME format.
I create invoices for payments from customers. I have those =
automatically charged to their bank accounts and credited to my bank =
account. When the payments hit my bank account and are downloaded into =
Money, I go into the transaction and enter "Payment For Invoice" and =
then try to go to the apply payment to an invoice screen but a nice =
little pop up comes up in Money 2005 that says &qu...Cross Apply problem
How do I get the desired result for the following:
SOURCE TABLE: USSoilLyr
FIELDS: TAXOR PARTSIZE PCT_R
Alfisols ashy 60
Alfisols ashy 57
Alfisols ashy 38
Alfisols clayey 85
Alfisols clayey 79
Andisols medial 50
Andisols medial 36
DESIRED RESULT (TARGET TABLE): T_Order
FIELDS: TAXOR PARTSIZE PCT_R
Alfisols ashy AVG(60+57+38)
Alfisols clayey Avg(85+79)
Andisols medial Avg(50+36)
My T-SQL Code, as follows, returns wrong calculations when I manually check
SET ...Install V10 HR after applying service pack 3
I am currently on V10, SP3 and now have purchased the HR module.
I am not sure of the steps I need to take to load the HR module (we have the
V10 DVD that is not sp3)
Are these my steps?
1. Load the HR module from V10 DVD on SQL Server install (I was told
previously to use the Add/Remove programs option and change but it still asks
for the DVD)
2. Do I need to reload SP3 on server install?
3. Then load the HR module (from V10 dvd) on additional workstations?
If I have to re run the SP3 I am concerned it is going to take hours to
complete like original instal of SP3
If anyone has a...Apply Multicurrency Invoices in Bank Management
I oppened a ticket to know why I cant apply Multicurrency Invoices to payment
transactions in Bank Managment as it is available in Payable Management.
I've been suggested to post a suggestion for that.
Simply, while doing a payment in Bank Management. If the Chequebook Currency
is diffrenet than the invoices currencies that you are paying againist, then
you can't apply these invoices. Thus, you cant see them in the remittance
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestio...Transaction Report
Is any way to have a report by transaction Numbers ?
Detailed Sales report includes Transaction Number. I believe it is hidden
by default though - use Show/Hide columns to display it.
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information
"JAL" <email@example.com> wrote in message
> Is any way to have a report by transac...Payment for invoice in 2005 from downloaded transaction
I am trialing Money for small business and downloading transactions from
bank, I am having probem with two things.
1. I try to reconcile the downloaded transaction and it doesnt work
Account register-select transaction(show transacton forms) Deposit-From,
category is Special - payment for invoice get the error message 'payment for
Invoice is not a valid selection for this transaction' HELP PLEASE, I'm about
to throw out the product.
2. when you do the above WHY dosent it split the transaction in the amount
field to the amount/VAT....help again please
> 1. I try to reconci...unposted applied credits
how can list all unposted applied credits in AR.
If you have SmartList Builder, you could use it to create a SmartList based
on the Cash receipts work file.
"Scott Rusoff" wrote:
> how can list all unposted applied credits in AR.
Create a report off RM10201 (RM Cash Receipts Work File). Add a restriction
where Current Transaction Amount <> Original Transaction Amount.
"Scott Rusoff" wrote:
> how can list all unposted applied credits in AR.
Which smartlist contains t...I can receive but not send emails, using Outlook 2003 with AOL9
Am trying to configure Outlook 2003. AOL instructions seemed ok, and can now
receive emails but when I try to send them, it says the connection to the
server was interrupted. The AOL Q&A mentions this problem and says to reduce
the regularity of send/receiving to over 11 mins. Have done this but its made
no difference at all.
If you've experienced this and come out the other side, I would gratly
appreciate your suggestions.
Thanks in advance
I don't know if this will help, but read it through:
Outloo...Payables issue with Applied Payments and Void Check
We had a user a number of months ago apply a number of Credit Memos from a
vendor to a large invoice while creating a check. Apparently the check was
then void, without a normal check number leaving us with "REMIT0000000000xx"
as the reference to it. We now have a situation where the large invoice and
all of the credits are still showing in the system as open. The individual
credit memos do not show as having amounts applied, but when we try to apply
them we're told that the amount is already applied. Everything seems to be
stuck in limbo, with no way to post to resol...local exchange users not receiving email
I've just loaded Exchange 2003 Server. We already had
existing domain users in the domain so to create
mailboxes for them I went into AD users and computers,
selected the users object and right clicked on each user,
selected Exchange tasks, then created each mailbox. That
went very smoothly. However, no one is receiving email.
They all send fine but do not receive. We do have a
firewall and I have allowed SMTP and POP3 through the
firewall. Presently we are not using Internet Email on
the Exchange Server just internal email only. Can
someone tell me why we can send locally...Where do Originating Transaction Source values come from on Receip
I was looking at the records in the GL20000 (YTD Transaction Open) table for
two Purchasing Receipt transactions.
Receipt #1 has a TRXSORCE value of 'GLTRX00019321' and a ORTRXSRC value of
Receipt #2 has a TRXSORCE value of 'GLTRX00016391' and a ORTRXSRC value of
Why would they have different ORTRXSRC origins (i.e., GLTRX for Receipt #1
and RECVG for Receipt #2)?
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Currently supporting: GP 9.0, SP2
Receipt 1 may have 2 explanatio...Error 0x80040118 when sending/receiving
Any clue what error 0x80040118 (unknown error) is. I get this on a pop3
account in Outlook 2002. I have googled it and didn't find anything.
What is happening when this error occurs?
Outlook Tips: http://www.outlook-tips.net/
> Any clue what error 0x80040118 (unknown error) is. I get this on a pop3
> account in Outlook 2002. I have googled it and didn't find anything.
...How to apply a weighting
I'm trying to apply a weighting to my teams to allow for experience and
I have 3 teams which are different sizes and are different skill
Level 5 is the lowest skill level and level 1 being the highest skill
How do I apply a weighting to these numbers to allow for team size and
experience. Can I do this using sumproduct? I tried looking at this but
cant get my fragile little mind around it
Thanks in advance.
---------------------------------------------------------------...Able to receive mail from domains but not send to them
We have a front-end / back-end Exchange 2003 Standard setup - with Exchange
SP1. The front-end server basically has no problems with sending and
receiving mail except for one external domain.
The servers can receive email from the external domain with no problems but
cannot sent email to it. The outbound email stays in the outbound queue in
What should I be looking for or what should I ask the administrator on the
external domain to look for to fix this problem?
- Check SMTP logs
- Can your server resolve fqdn of remot...Mass apply or batch apply sales documents?
Is there any way to avoid manually applying payments one by one? Our current
process is that we have a cash receipt batch of payments that have declined,
and on a daily basis, it is reauthorized. When the payments are approved,
the payments are posted without applying the payment to the invoice first.
We are using GP 10.
There are several third party programs that address this issue very well.
Do a search on the internet and you shall find them.
"Erin Black-Mitchell" wrote:
> Is there any way to ...adding business name of customer to invoice
Can I customize my invoice design to show the business name in addition to
the customer name in the address area on the invoices? This is not one of
the check box options. (Why not?)
> Can I customize my invoice design to show the business name in
> addition to the customer name in the address area on the invoices?
> This is not one of the check box options. (Why not?)
Are you talking about an invoice created in Microsoft Money (what
version and type?) or Microsoft Access the database problem?
Joseph Meehan wrote:
> Tazz3L wr...Apply CF to Row after CF was applied to Column
Can someone please help me? I've read through the postings and the help
files but still can't seem to figure out how to do this. I've applied
conditional formatting to the J column of my spreadsheet so that if there's
any text listed the cell turns yellow. What I'd like is if not only the cell
but the row, from A:O turned yellow also. How do you do that? I'm using 07.
Any help in English walking me through the steps or a hint toward the
appropriate post would be greatly appreciated. Cuz I aint figrin it out on
Thanks in advance!