Is there any REALLY good reason to upgrade from Windows Vista Home Premium
to the Windows Vista Ultimate?
Wrong news group, but that depends strictly on what you want to do in Vista.
I personally will not use anything less than Ultimate, but as a developer
that is what my requirements are. I also have an MSDN subscription that
allows me to install the "flavour" I may need for testing.,
The personal opinion of
Gary G. Little
"Eykleidis" <email@example.com> wrote in message
> Is there any...adding a leading 00 to some loan numbers
I've got several thousand loan numbers which need to be updated to a
ten-digit format by adding a leading 00.
That's easy enough to do, HOWEVER, some of them have already been updated
with the leading 00.
What formula can I use to add 00 only to those which have not already been
If the values are all numeric (not text), you could apply a custom format:
Select the range
format|cells|Number tab|Custom category
or use a formula like this if the cell looks numeric:
=tex...Scan item on shelf for price
Is there a way you can scan a item on the shelf for price and match to the
file on computer. With a csv file.
Next question how do you see the price or each store thru HQ?
If you want to say matching of quantity it is already there, but matching
the price do you mean that you will scan it using the handheld and once you
scan the item you will enter the price which are on the shelf and then go to
computer and import the file to same RMS database and wanted to match then
there is no such thing. BUT you can develop the script where you can match
the price I am writing below the scri...Date Changes to 01/00/00 when i enter any date.
Using XL2003, I have a problem. When i enter a date in cell, such as
08/25/10, or use the shortcut Ctrl ;, XL displays 01/00/00 in the
cell instead. I have formatted the cell as a date. What can I do to
fix this problem?
Thank you so much.
...How do you insert a water mark into an excell worksheet
How do you insert a water mark into an excell worksheet. Like the word DRAFT
You mean for printing purposes?
See Bob Phillips' site for details.
If not for printing simply add a background to the sheet which will be
visible on screen but will not print.
Gord Dibben MS Excel MVP
On Wed, 12 May 2010 15:36:05 -0700, leppinl
>How do you insert a water mark into an excell worksheet. Like the word DRAFT
...Change the Default Language Setting
Is it possible to set the language to 'English (Australia)' so it will be
the default across all office applications? I keep having to change it
manually in outlook at the moment.
...Set Number of Previous Documents under FILE
When I open Excel and click on FILE on the menu bar, it
only shows 4 previously opened documents. I want it to
show 8-10 but can't find any options to change it. Can
it be done? I have the student and teacher edition 2003.
<Tools> <Options> <General> tab,
Change number of entries by the "RecentlyUsedFileList".
Please keep all correspondence within the Group, so all may benefit!
"Carolyn" <firstname.lastname@example.org> wrote i...Serialized items sales question
Is there any way to prevent the sale of serialized items when a
customer is not associated with the invoice?
...Missing Additionals in Sales Order Processing
In version 8, we have Create Return andHistorical Lookup under the Extras >
Additional. Upgraded to version 9 and now both those are gone. Have not
change any security, yet cannot find these windows.
Where did these great features go?
...Price doesn't show up in PO
For some reason when I make a PO from HQ I have to enter the Price of the
Items every time.
Is there some thing I can do to have it list the price in the PO with out my
typing it in?
I have noticed that the items all have a 'last cost' of $0.00 on each of
them. How do I get HQ to track this?
This is a multi-part message in MIME format.
Do you have a cost in the supplier file for the item?
Get Secure! - www.mic...Employee's sales totals are wrong
We have just installed MS Dynamics POS 2.0 and was wondering if any of
you experts can help us out. We have non-inventory items set up in a
department for shipping, crating etc. When we enter one of these
items in POS the sale's line item and totals are fine, but the problem
is they are also showing up on the employee's total sales amount. For
instance if the sale was for a $100 item and we charges $15 for
shipping, we only want the employee to be credited for a $100 sale not
$115 as is being done now. What are we doing wrong? Desperately need
If you are concerned wit...Heart Beat w/ Thud for 1:00 minute
Good morning Wizards of the Board ... Excel 2000 ...
I am back with the Heart Beat ... My Production lines must
produce product to the customers beat of demand ... to
emphasize this ... I would like to imbed a Red Pulsating
Heart with a Heart Beat Thud within my spread sheet. I
would like this to be activated when WorkBook is opened &
since I understand this might prevent Excel from
performing other activities while activated ... I would
like it to be disabled after 1:00 minute of play ... I
would also like to be able to edit the time of 1:00 min if
I am not happy with it.
As ...Set mailbox permissions individually?
We deployed Exchnage 2003 + SP2 on W2K3 domain.
Is there any posibility te set permissions on folders/subfolders etc. of a
mailbox individually from Exchange Server (not from client)?
No. If you need to set granular permissions at the folder level, you have
to use Outlook.
Read my blog!
http://feeds.feedburner.com/winzenz (RSS Feed)
"mustafa" <email@example.com> wrote in message
> We deploye...How to let field sales people use our data base (without ASP/Scripting) ??
We have a data base we want our field sales people people to use
We have all our queries and forms and reports done in Access.
We do not want to have to re-do it all in ASP or some other Scripting
We think we need something like Citrix and Terminal Server... but they
are expensive... right?
What are the alternatives available to very small businesses?
Thanks for any help.
"Mel" <MyEmailList@gmail.com> wrote in message
> We have a data base we want our field sales people people to use
...Combination Graph with current year and prior year sales
I'm trying to create a graph showing sales results for 5 organizations over 3
individual quarters, for current and prior year. My plan was to show current
year as a bar chart with the 5 organizations each having their own bar for
each quarter (therefore there will be 15 bars). I then want to show the
prior year data as a line chart, again 5 lines and 15 data points.
I've tried several options and my issue is that the data points (labels) for
the line charts are in line, in the middle of each quarter, and I would like
the data labels to begin and terminate within the correspond...Need to set up ID on Outlook Express
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 in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Try posting this in an Outlook Express news group - this is not one of them.
Outlook i...How to set up two accounts with one brokerage?
I am using MS Money 2003. I have two accounts with one
online brokerage. One is my 401k and one is just some
stocks. In order to log in, I have to use a different
user name and password depending which account I want to
access. The problem is, MS Money only allows me to enter
one user name and password for each brokerage. I change
the online properties of each MS Money account one at a
time, but the changes do not stick. Both accounts wind
up with the user name and password of the account I
changed last? Am I doing something wrong? Any help
would be appreciated.
In microsoft...Tiered item costs in Purchasing
Our company is a distribution company. We have tiered pricing for what we
purchase from selected vendors. As of now, either our sales staff has to
tell our purchasing agents the price to buy the product at, or our purchasing
agents will have to manually change the purchase price in the inventory card,
then go ahead with the PO.
There has to be a better way for this.
I know there have been posts about this in the past, but can either Great
Plains or a third-party piece of software that integrates give us something
similar to the selling price lists in SOP?
Are other organizations h...Outlook problem #25
Following a power outage last night, I am unable to open
Outlook at all. All other programs on the computer work
fine, including other elements of Office. Any suggestions?
...Any way to mark junk as read automatically
I can't seem to find a way to configure message rules to mark all junk mail
as already read. Is there any way to do this? Mail that goes into the junk
folder is always junk so I'm sick of having to go in there, right clicking
the message and clicking mark as read just to stop it showing up as a number
beside the folder ie Junk (1)
Thanks in advance.
Why bother with marking it read? Simply click the X to the right of
the Junk E-mail folder which enables you to empty that whole
folder with one more click.
Gary VanderMolen, Microsoft MVP (Mail)
----------------...Setting up account balances
I have just installed GP and now I need to set up my beginning balances. I am
want to show a debit to checking for $22,000 and a credit to Capitol for
$22,000 ,,,how do I do this. How do I journalize this. I am an old school
It depends on if you have the Bank Reconciliation module. If you do, you
should enter a Bank Transaction so your checkbook and GL cash account are
updated. If you do not have this module, then you enter a GL journal entry.
Charles Allen, MVP
> I have just installed GP and now I need to set up my beginnin...How to set exchange mailbox size limit
This is a multi-part message in MIME format.
How do I set a big 3 gb mailbox for just one user in Echange 2003
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-...Set focus in a specific record within a subform
I have a main form with a subform. The subform contains multiple records and
a hidden unique id which ties it to the main form. After I enter data into a
field on the subform, I am requering the main form. I would like the focus
to remain on the subform on the specific record the user is editing. I have
been able to get the focus to remain the subform however, the focus jumps to
the first record.
This is my code:
Private Sub MP_Reserve_AfterUpdate()
Forms!Liability!ClmntInfoForm!.Form![BI ...How can save a stationery created using a Publisher design set to.
How can save a stationery created using a Publisher design set to be used as
my Outlook stationery?
What version Publisher?
Select all, right-click, click save as a picture.
In older versions, select all, copy and paste to a Paint program.
Mary Sauer MS MVP
"Mike" <Mike@discussions.microsoft.com> wrote in message
> How can save a stationery created using a Publisher design set to be used as
> my Outlook stationery?
...Update Product Details from Sales Order screen fails
I am new to MS CRM 3 and still learning. I have set up 3 users, all with
full admin/customisation/manager privileges (User A, B and C). As user A, I
have created a product catalog and when logged into the intranet interface,
am able to create product order entries, and change the attributes of the
product within each entry. However, when user B logs in using the Outlook
interface, he is unable to change the attributes of the product when entering
a new product order entry. I have given the same privileges to all 3 users,
and even logging in/out of Outlook and Windows does not seem t...