Slow Login #2
I am having issues with a machine which does not host the Store Operations DB
being slow to sign in. When the cashier signs in it thinks for about 10
seconds then lets you in to POS. They are on a 100mb network but suspect it
is a comms issue backto thw SO.
...Updating Accounts #2
I just upgraded to Money Plus Deluxe (Have XP) When I go into Money it states
its "updating account" and my CPU usage is at 99% when I run Money. There are
NO accounts that are being automatically updated as I do them all manually.
The "updating accounts" icon stays up until I finally have to turn off
computer because I cannot work on any other part of money as it says it is
doing an online function.
It also goes online to seek its own updates. Do you have SSL2 enabled in
Internet Options? Do you have firewall software enabled beyond the XP
firewall...Vertical Page Break
Is it possible to force a vertical page break on a report? For
example, I have a report that is 20 inches across, and I would it to
"break"/start the new page at 10 inches. Now, fiddling with the page
setup and page layout is fine when I am working with only one printer,
but the formatting gets slightly messed up when I am printing across
different printers, to PDF, etc.
Any ideas on how this vertical page break can be done?
that sure would be nice to have
I'd reccomend just putting the page 2 below page 1.. and use more
subreports if you run out of room
On ...CRM 1.2 Leads & Searching
Hope someone can help - how do you search by Company Name field in the
Leads view, as well as Name field (by default). On older leads people's
names often get forgotten about, but the company name does not!
Is there a way of selecting which fields are searchable?
Afraid that you don't have this control in v1.2. v3.0 does give you the
ability to pick which fields to search though.
MVP - Microsoft CRM
"Adam Carter" <email@example.com> wrote in message
Hope someone can help - how do you se...Multiple SMTP Address
If a user is set up to have multiple SMTP address setup in active directory.
When they send an email in outlook how can they chose which one it is from.
You can only do this, in the setup you describe, by using a 3rd party app
such as ChooseFrom from www.ivasoft.biz
> If a user is set up to have multiple SMTP address setup in active directory.
> When they send an email in outlook how can they chose which one it is from.
On Tue, 31 May 2005 06:41:03 -0700, "Shane"
>If a user is s...GP Upgrade #2
We just upgraded to GP 10.0. We want the salesmen to be able to enter their
own orders, but we don't want them to be able to change the unit price or
the extended price on the order. Is there a setting I can use for this?
I might be wrong but I think thats a security issue.
> We just upgraded to GP 10.0. We want the salesmen to be able to enter their
> own orders, but we don't want them to be able to change the unit price or
> the extended price on the order. Is there a setting I can use for this?
> Than...Excel 2007
We have a spreadsheet that was set up to link to a database via a
system DSN. To simplify deployment of this, I'd like to change this
to connect via the connection string below:
I've done this for another spreadsheet, and it was easy (Data tab-
>Connections->Properties), but in this next spreadsheet the Connection
Properties for one connection are greyed out/disabled, so I can't
change the string.
Does anyone have any ideas how to enable these values again so I can
change the connection string?
...The connection was dropped by the remote host #2
All day I've been getting email stuck in the outbound queue with the below
Message delivery to the host '184.108.40.206' failed while delivering to the
remote domain 'yahoo.com' for the following reason: The connection was
dropped by the remote host.
I've been able to send email to some domains but not all.....
I've restarted the exchange 2003 server,
Restarted DNS on DCs
Reset our firewall...
NSLOOKUP is good
Pings by name resolve
I can telnet to my mail server
I can telnet to other mail servers.
Can someo...Word default paper size- networked user accounts
Word 2004- processors various, OS 10.5
How do I get Word to default to A4 (instead of US letter) for networked
The succinct answer to this is "By ensuring that your operating system
locality preferences are set correctly before you install."
Microsoft Office picks up all its global settings from the "Language and
Text" system preferences in OS 10.6 (I think they were called something else
If this has been done wrongly at installation, you need to set the System
Preferences correctly and then delete the individual user's...[ANN] Xinclude.NET 1.2 released
I'm glad to announce XInclude.NET 1.2 release.
What is XInclude.NET
XInclude.NET is free open-source implementation of XInclude 1.0 Working
Draft of 10 November 2003  and XPointer Framework Recommendation 
written in C# for .NET platform. XInclude.NET supports XPointer
element(), xmlns(), xpath1() and xpointer() (XPath subset only) schemes.
XInclude.NET has been tested using The XInclude Test Suite under
Microsoft .NET 1.0 and 1.1 on Windows 2000.
Changes since 1.0 release:
- Updated to new XInclude syntax and namespace according to new XInclude
1...How to display page tabs vertically?
How do I set tab pages be displayed vertically (left side). By default, they
are set on top, I need them on the left side. Please assist.
Thank you for any tip/help provided.
Please post all your inquiries on this community so we can all benefit -
"Adnan" <firstname.lastname@example.org(donotspam)> wrote in message
> How do I set tab pages be displayed vertically (left side). By default,
> are set on top, I need them on the left side. Please assist.
> Thank you for any tip/he...Saving data #2
I need to save data (results) from a base spread sheet program that i use on
a weekly basis. i am in the middle of building this program, and have just
discovered macros, but this, along with links is about my current knowledge
how can i automate to accumulate data from the base spread sheet (program)
when i clear all data from the program to produce fresh results the following
week, and to keep past data up to date and available for further use.
Any help would be appreciated.
With a combination of formulas and dynamic named ranges, it is possible to
just add the ...Parse multiple text lines into 1 line in excel
help. I am an excel beginner and can't find out how to turn multipl
lines of text into 1 row in excel. It's probably really easy but m
manual is USELESS. Can anyone help
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
You're a little short on details. If nothing below fits the bill post back.
"Multiple lines" is how many and is each line in a separate cell down one
Do you want all lines to go into one cell?
You can use this form...refer to data on multiple worksheets using hlookup/look up data on many worksheets?
I have data on many worksheets in the same workbook.
Is it possible to look up data on multiple worksheets using Hlookup,
which means can the second argument in the formula refer to multiple
If it is not possible, is there any other way I can do so?
I would like to select and display data according to a fixed order,
whereby the data is located in one of many worksheets in the same
For eg, I have stock returns of many firms in many worksheets. Say I
would like to display in a single worksheet the returns of Firm D, Firm
Z, Firm R; whereby the data of these 3 fir...Unwanted Formula Display #2
I'm using Excel XP, preparing cost estimates.
In my summary page, cell references display the name and total of each
category, from the associated category page in the document.
When I insert a new line for a new category, and "point and shoot" to assign
the formula, e.g., ="A425", it displays the formula rather than the cell
reference value, e.g., "Carpentry". I've tried formatting the cell as Text
and General, copying another cell reference that is displaying correctly, and
then editing the formula, and painting the new cell from one that is
wor...Best Practices shows 114 GB Database Size limit
I just ran a best practices scan against my Exchange 2003 SP2 Server and it
shows that the Mailbox limit is 114 GB. I though the limit was going to be
75 GB in SP2? The value data in the Database Size Limit in GB registry key is
72 hex. DO I have it configured wrong? SHould it read 114 GB in the best
practices scan? Any help would be appreciated.
72 Hex is 114 decimal...you need to set it correctly in your registry.
"mrjules" <email@example.com> wrote in message
>I ju...random number #2
how can i create a normally distributed random number
and a random number that has a beta distribution
i need these both to be integer outputs
thanks for the help
Use NORMDIST and BETADIST
> how can i create a normally distributed random number
> and a random number that has a beta distribution
> i need these both to be integer outputs
> thanks for the help
I think you meand NORMINV and BETAINV. See my reply under the OP's repeat of
It is generally better to reply to your original thread with fol...How do I make footnotes appear on each page (cross ref)?
I have cross referenced several footnotes throughout my document. Is there a
way to display the footnote on each page where it is referenced? For
example, if footnote 2 is on page 4 and I have cross referenced it again on
page 10, it is possible to display the footnote text again on page 10?
Not without creating a new footnote, no.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"lapple" <firstname.lastname@example.org> wrote in message
&g...Match formula to match values in multiple columns
Hi all, does any friend know that how can I make below formula work
I am not sure I have understood correectly. Please go through the below example
With data as below if you need to retrive the name of the 1st Rank holder
D2 = 1
D3 = London
In D4 apply the below formula
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar'...Noob Question For Selecting Multiple Fields On A Form
In versions earlier than 2007 I would be able to go to the Menu Bar and
click Edit -> Select All to select all fields on the form.
Now, my question is... where in 2007 did the put that functionality? If
Microsoft removed it from there... where did they recreate it?
"SQLSQUIRREL" <SQLSQUIRREL@discussions.microsoft.com> wrote in message
> In versions earlier than 2007 I would be able to go to the Menu Bar and
> click Edit -> Select All to se...Page numbering 12-04-09
I have taken the trouble to review all the related previous posts but do not
see the answer to meet my needs.
I have a 7 page document which consists of a front and back cover 2 pages
each and so far 3 pages of report.
Page 2 is followed by a section break next page while page 5 is followed by
a section break next page. In addition I also put a section break at the end
of the document which I should not need.
Numbering starts on page 3 as page 1 of Y which seems to work fine.
However, page 4 and 5 do not display page numbers while page 6 displays page
1 of 6 and page 7 i...Database Field Sizes.
I have two small problems, firstly Can the Matrix Description field size be
increased to 40/60 chars at present too small.
or is there a bigger field i can use eg the extended description field size
We need a way that when a saleperson inputs a sale order at the POS and the
item needs to be special order the following information is automatically
passed to the purchased order for the supplier.
1, supplier Ref number for item.
2, Supplier Colour (four suppliers have 56 colours each)
3, Size of Dress etc
4, delivery date required
5, Order confirmation date and number from suppli...Cannot Start Outlook #2
I have just run the auomatic windows update on my local PC
and now Outlook 2000 will not start. It just hangs at the
splash screen. Outlook is configured to connect to
Exchange. Other PCs on the same Lan which have not been
updated can still connect. The updates installed were
824141, 823182, 826232, 825119, 828035, 828749. I have
unistalled all of these updates and Outlook still will not
start. Any ideas?
Does it start if you run this command from the command line, go to Start >
Run > type "outlook /safe" without the quotes but with the space before the
&...2 Email domains w/2 Act. Dir. Domains - Same Forest
We've had domain1.com (AD) setup and running in exchange 2003 for a year now
w/mixed win2k and win2k3 servers - email domain name is the same, domain1.
OWA works great and haven't had any problems. Our company is branching out
into a new business segment and I've created a new active dir. domain within
the same forest, domain2.local. It is NOT a child domain, but does sit under
the same forest.
I need to configure my front end/back end exchange 2003 boxes to do the
-receive email for both email domains (domain1.com and domain2.com)
-let users...Search Multiple Worksheets #2
Is there a way to search trough multiple worksheets for a specific value?
Other posts have mentioned to use VBA, but I have never used that before. If
anyone can give me some advice on using that or a type of formula to perform
that can search multiple worksheets.
There may be other ways but, while holding down the ctrl key select each of
the worksheet tabs you want to search in then select Edit|Find from the
menu. Type in the value you want and it will go to the first instance of
that value. Now if you are wanting to preserve a specifice value for
reference or ???, then...