Changing credit limit
How can I change the credit limit that is specified for existing credit
Highlight the Account in Account List and click on it. Click on Change
Account Settings. Click on Change Credit Details. You will have to scroll
down a lot on the Account Settings page to see this.
Microsoft MVP - Money
For UK tips & fixes see
For wishes or suggestions see
or for UK wishes http://www.microsoft.com/uk/support/money/feedback
I do not respond to...How do I get started with Outlook?
I am trying to use outlook and I just can't get it to work. I put in an
e-mail address and all that but whenever I go to send an e-mail it
automatically goes to my outbox. What am I doing wrong?
"LauraAshly" <LauraAshly@discussions.microsoft.com> wrote in message
>I am trying to use outlook and I just can't get it to work. I put in an
> e-mail address and all that but whenever I go to send an e-mail it
> automatically goes to my outbox. What am I doing wrong?
When you say "I put in an e-mai...How to get POS out of Evaluation Mode?
Both of my POS softwares are running in evaluation mode. When I log in a
message pops up saying I'm operating on a license that is due to expire in
September and therefore it is running in evaluation mode. How do I get POS
out of evaluation mode and does it have anything to do with my license?
Yes, it has something to do with your license. Insert the license dongle in
POS register 1.
"G E" wrote:
> Both of my POS softwares are running in evaluation mode. When I log in a
> message pops up saying I'm operating on a license that is due to expire in
> Septemb...how can I compare contents of columns in excel?
I have two excel files viz. file-A and -B.
One of the columns of File-A contains chemical names which
is also contained in one of the File-B columns.There are a
lot more chemical names in the latter file than in the
What I would like to do is to transfer additional
pertinent information from columns in File-B to new
columns in File-A on the basis of the chemical names found
in File-A. At the end of the exercise I would have a file
with the same number of chemicals but with more
How can I do it? Your help would be much appreciated.
Take a look at the =vlookup() ...Best Way ?
Looking for some information. With Outlook you can have all your
contacts...address, email address, yada, yada, yada. Can I use this
information in to say mail merge with Word and email a letter to the ppl
with email addresses? Or is this better done with a Access?
The reason I ask is that we want to deliver an email to all our clients with
the latest promotions. And want it to be a bit more automated?
Any information or pointers in the right direction would be appreciated.
Have a good one,
You can use either Access or Outlook as the data source for a ma...255 chr limit in cell
I am exporting a query from Access to Excell - One of the fields is over 255 chrs long and it is being trunkated in Excel
Does anyone know a way round the 255 char limit in Excel
I don't speak the Access, but can you split that field up into smaller pieces
(while in access).
Then retrieve each little bit and recombine?
> I am exporting a query from Access to Excell - One of the fields is over 255 chrs long and it is being trunkated in Excel.
> Does anyone know a way round the 255 char limit in Excel.
Dave P...Add Publish Column to Enterprise Template
I've tried to add the Publish column set to the value of Yes to an Enterprise
project template but the column will not save. Any ideas?
Presbyterian Health Plan
This worked for me. What error message(s) did you get?
Microsoft Most Valuable Professional
"Carla Evans" wrote:
> I've tried to add the Publish column set to the value of Yes to an Enterprise
> project template but the column will not save. Any ideas?
> Carla Evans
> Presbyterian Healt...is there a way to crop a corner out of a rectangular image in Visi
Using subtract on two shapes accomplishes what i want to do, but when the
first shape is a .gif image, it does not work.
No, the "boolean operations", as they're called, do not operate on foreign
objects like bitmaps and controls.
Visio has crop functionality for imported graphics, but it is only
You could draw a small white triangle and give it "no line". Then place it
over the corner of your bitmap.
Hope this helps,
"doug" <email@example.com> wrote in message
news:29D479A6-6099-4051-B7A0-1...List/Numbering indent issue....
Hello... I am creating a document with numbering/list (i.e. 1., 2., 3.---)
and also having images included using text wrap.... but when the images are
inserted into the desired places the numbering/list makes an "extra long"
space between the number and the text. I have right clicked and chosen
adjust list indents and done every possible thing and it tends to change all
of them and not getting me the results i need. I am editing text and
documents for my boss for production and i need help fast.
Unfortunately, there has been an issue with indentation next
to...Create Number From Date
I'm importing large amounts of text into Access and I want to assign a
"trace" number to each record. I'd like the trace number to start with the
date but in just plain number format. Then I'd like the last part of the
number to be automatically incremented. For example records imported on
11/28/07 would have an ID number like:
How can I do this?
Thanks for the help!
On Thu, 29 Nov 2007 12:05:35 -0600, "John W" <firstname.lastname@example.org> wrote:
>I'm importing large amounts of text into Access and I want...Replacing numbers
I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112,
I would like to perform a bulk replace for just the first 3 numbers.
Turn 209*** into 210***.
select the data>edit replace>209 >210
Just make SURE that 209 doesn't exist anywhere else
Microsoft MVP Excel
"Randy B." <RandyB@discussions.microsoft.com> wrote in message
>I have a spreadsheet which contains 6 digit numbers (i.e.209111,...Variable row number in Sum($A$1:A10) formula
I need to be able to change the length of the string of numbers in a column
being added using the Sum formula such as: =Sum($A$1:A10), where A10 is a
variable adjusted by a reference to the number of rows to add in an different
For instance, if C1 is the reference cell and C1 = 20, the the fomula should
automatically change to =Sum($A$1:A20).
How can this be accomplished?
Gary''s Student - gsnu200909
Entered in B1
Gord Dibben MS Excel MVP
On Thu, 3 Dec 2009 11:45:01 -080...How to get list of namespces ?
How to get list of namespces that are declared in an element ?
"Oleg Subachev" <email@example.com> wrote in message news:OU4HcHWdEHA.firstname.lastname@example.org...
> How to get list of namespces that are declared in an element ?
Given that you have first positioned yourself onto an XmlElement
of an XmlDocument, one of the fastest ways is to grab an XPath-
Navigator and enumerate the Namespace nodes that are present.
XPathNavigator nav = myElement.CreateNavigator( );
if ( nav.MoveToFirstNamespace( ) ) do
...customer on hold should get warning on recurring batch posting
If a customer is put on hold after a transaction for it is saved in a
recurring batch, the system will still let the user post the batch without
Please include the GP functionality to get a message prompt or warning that
the user is posting a batch that includes transaction(s) for batch recurring.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion ...weighted random numbers
Would appreciated any help on this. I'm looking to create a
spreadsheet that can generate weighted random numbers much like
professional sports leagues do with their draft lotteries. I play in
a league with 20 teams and we have a draft every year. I would like
to generate a lottery where the teams that finished near the bottom
would have a greater ( say i.e 25%) chance of selecting the 1st pick
than the teams that finished near the top. Any input would be
Jorge <eisen_h...@yahoo.com> wrote...
>Would appreciated any help on this. I'm looking to cr...Is there a way to color code Outlook Contact File Folder Labels?
Is there a way to color code Outlook Contact File Folder Labels?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/
"isailhbca" <email@example.com> wrote in message
>...A way to create sub-categories?
I want to group contacts by category and then a sub-category for easy
viewing. Apart from creating a new field for sub-category is there a way of
doing this? Outlook doesn't seem to support sub-categories.
Author - Special Edition Using Microsoft Office Outlook 2003
Lead Author - Access 2003 VBA Programmer's Reference
Author - Absolute Beginner's Guide to Microsoft OneNote 2003
"Casebase" <firstname.lastname@example.org> wrote in message
news:%23rx5a...I can't get my letterhead to only appear on the first page of a l.
I can't get my letterhead to only appear on the first page of a letter. I
have tried using "different first page", but the letterhead keeps deleting
from the first page, but stays on the remainder of the pages. What am I
See http://word.mvps.org/FAQs/Formatting/NumberingFrontMatter.htm (for 2003
and prior) or http://www.word.mvps.org/FAQs/Formatting/front_matter_2007.htm
for details on how to have different Headers and Footers, etc. in one
document.Hope this helps
> I can't get my letterhead to only appear ...How to Get Rid of Surfboard Shim Object View Message
I had to reinstall everything on my computer after a crash. I reinstalled my
MS Money 2007. Now every time I click on a tab or want to do something I get
this message about Surfboard Shim Object View. I've opened, saved, and
cancelled it and it still keeps coming back.
How do I get this to stop?
In microsoft.public.money, Toni Black <Toni
>I had to reinstall everything on my computer after a crash. I reinstalled my
>MS Money 2007. Now every time I click on a tab or want to do something I get
>this message about Surf...When I type numbers in currency all I get is #######
After I type an amount in a cell, it turns to pound signs as soon as I go to
the next cell. How can I fix this?
Make the column wider
(No private emails please)
"mommy4shane" <email@example.com> wrote in message
> After I type an amount in a cell, it turns to pound signs as soon as I go
> the next cell. How can I fix this?
It could mean a few things.
1. The columnwidth is too narrow to show the number.
Widen the colu...Number of Calendar Exeptions
does someone knows how many exceptions I can have at one calendar?
I want to automatically update the resource calendars with nonworking time
and wondering wether there is a limitation of entries...
Thanks for answering..
Try to find "Project Specifications":
Project 2003 : http://office.microsoft.com/en-us/project/HP453051461033.aspx
Calendar exceptions per calendar 1,400
Testing was able to add more than 15 000 exceptions to a base calendar.
"Steffen" <Steffen@discussions.microsoft...Getting error in outlook
hi steve here
i am getting error in outlook
o/s : 98
Unable to display the folder.
Microsoft Outlook could not access the specified folder
Errors have been detected in the file
Quit all mail-enabled applications, and then use the Inbox
any help would be appreciated
>hi steve here
>i am getting error in outlook
>o/s : 98
>Unable to display the folder.
>Microsoft Outlook could not access the specified folder location.
>Errors have been detected in ...How do I get the gradient at a point on a curved graph?
I have a plot of experimental data and I inserted an exponential trendline
that fits the data very well. I'd like to "differentiate" the curve as I need
its gradient at certain points; as in I need Excel to draw the tangent to the
trendline at a given point and tell me its equation. Can anyone help me do
Thank you all so much.
I don't think Excel knows how to do this as a built in thing. Extract
the coefficients of the trendline to a worksheet (using a worksheet
function such as LOGEST or a utility that will extract trendline
coefficients to a worksheet). Then ...is there a way to change the time card repor format?
i'm using activereports in RMS to generate a custome timecard report. for my
timein and timeout colums, the datatype i have assigned to the columns is
vbDate. when I generate the report, the columns only show the date as
mm/dd/yyyy, they do not show the time of day piece for exactly when the
cashier punched in or out. is there any way to change the formatting of this
so that in the report the time shows up? for example, instead of showing
2/6/2005 in the time in column, it would show 2/5/2005 8:00:00 AM.
thanks in advance,
There is a timecard report on the Reports Library...Page Numbering Management
Example: If you have a 6 page spreadsheet
Is there a way to change the order of page numbering. For instance, pages 1 to 4 will be numbered 1 to 4 (that's the easy part). Problem is: Pages 5 and 6 will have to be numbered 1 and 2
Is that possible, changing the order of page numbering?
Excel has a setting in page setup. (file>page setup>page>first page number),
set this with a number, eg 5 and it will start with a page number of 5
Microsoft MVP - Excel