Sequential Numbering in Word 2003 and Recycling unused numbers
Once again, I am stuck in Macro world which is quickly consuming me :) It is
though, quite addictive and I am determined to win the fight I'm having with
I work for a company which uses network servers so the document needs to be
accessed by different people but not necessarily at the same time. We operate
Windows XP Word 2003.
I am trying to create a document that will open with a sequential number,
but if the document is not used or opened accidentally then the number it has
generated needs to be recycled for auditing purposes. I seem to be able to
get the number t...Case numbering 01-26-04
I have found the auto numbering in 1.2, but it only lets me change the
prefix for the cases "CAS". I need to start my numbering at 3500 instead of
1000. Is there a way to change the starting number?
...how do Ii remove the grey page numbers in a work sheet
how do Ii remove the grey page numbers in a work sheet
Try going to the View menu and unchecking Page Break Preview
On Wed, 2 Feb 2005 11:01:08 -0800, "parker1230"
>how do Ii remove the grey page numbers in a work sheet
You may be in page break preview mode.
Go to "View" and select "normal"
"parker1230" <email@example.com> wrote in message
> how do Ii remove the grey page numbers in a work she...How can i stop Outlook from re-retrieving messages on the server?
Outlook all of the sudden, is recieving thousands of old emails that I have
already read. It does this now whenever I open the program and will only get
old emails, never quite making it to the newest ones, of course, the ones
that I need!
Did you select the option to keep a copy on the server? and is that needed?
If so, and pop account, log on to web mail, create a new folder, move all
your old msgs to the new folder
"Tdragonman" <Tdragonman@discussions.microsoft.com> wrote in message
&g...Manufacturing Job Cost Link to PO Line and PO Receipt
Upon our upgrade to GP 10 we encountered a “BUG”. We use the “Manufacturing
Job Cost Module” to link our PO lines and RCT lines to jobs. Typically when
you receive a po line that is linked to a job number, it carries the link to
the receipt line, but since we upgraded to GP 10, this doesn’t work!
The link is stored in the ICJC3100 and ICJC3110 for PO lines, ICJC3200 and
ICJC3210 for PO RCTs. Currently the ICJC3200 and ICJC3210 tables don’t have
the links that they should. We have not changed anything in the Transaction
List Setup, it still is set to link “all” transactions.
Any hel...OL2000: Propotional / fixed-width font settings
What is the significance of the proportional / fixed-width font options under International Font settings in Outlook? Outlook always chooses the proportional option anyway.
Furthermore, how does Outlook reconcile the setting under "when composing and reading plain text" vs. the settings under International Fonts? Say I have a plain text message in ISO 8859-1. How does Outlook decide what font to use to display the text?
...Underlying Connection was Closed when opening System Settings
I've seen a couple of threads on "Underlying Connection was Closed"
when opening System Settings. I just found a solution not mentioned in
those posts and thought I would add to the knowledge base.
System Settings requires a connection to Microsoft SQL Reporting Server
(SRS). If your SRS server is down or offline the above error will be
...How to you selectively sum on a series of numbers?
I have a column filled with numbers, but I only want to sum up a few of them.
Let's say I have numbers filling A1:A10. Let's say I only want to sum up
the numbers located is A3 and A4. I'd like to ability to enter something in
the b column (e.g. "y" in cells b3 and b4) and have a formula that adds up
the values in the "A" cells that have a corresponding "y" in the "B" column.
This formula would allow me to selectively choose which cells needs to be
What is the best/cleanest way to write that formula? Thank you.
=SUMPRODUC...Try Catch to Pinpoint Set-Based Error?
I have a fairly simple Merge statement with this:
When Not Matched Then Insert Values
... long column list ...
cast( crazyCol1 as decimal(16,8) ) / 1000000 )
, cast( crazyCol2 as decimal(16,8) ) / 1000000 )
cast( crazyCol2 as decimal(16,8) ) / 1000000 )
cast( crazyCol2 as decimal(16,8) ) / 1000000 )
The insert source is about 50,000 rows. One of the rows is failing the
cast (original source is varchar(36).
I would like to implement a try/catch block around this somehow so I
can catch the offending row.
How can I do that?
SnapDive (...How do I reduce the number of data points I have??
I have some 10000 data points from which I need to reduce to something like
100 points before making an xy chart. Typically I would like to make a chart
of every 10th point. So basically I need to reduce the length of my two
rows. Is there any way I can do this easily??
Any help is highly appreciated. Thanks in advance
From the Microsoft Charting FAQ:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
ssan...Outlook 2003 changing global auto archive settings?
Outlook offers to Run Auto Archive every days. It allows
you to run it more frequently, but I would like to run it
less frequently. In other words, I would like to run it
every 120 days and then archive the bottom four months.
It doesn't seem that you can change the auto archive setting
above 60 days. Is there a way to do this?
I have the box checked to ask me before auto archiving - but
if I say no, will it continue to ask? Or, will it never ask
Essentially I would like to archive every 4 months and not
more frequently - and I would like to archive my inbox and
my se...International Range style settings
I am using Excel 2007, the Ducth version.
I have created a workbook with macros, partly recorded.
In one of the I am using some code like
If .Value < gdblNormValue Then
.Style = "Ongeldig"
In the English version it shoul be
If .Value < gdblNormValue Then
.Style = "Bad"
Is there a constant I can ue instead of the text "Bad"?
Styles have both Name and Local name properties, so I *think* the English
name should work ...Automatic number fill-in on Labels
Is it possible to have word automatically fill in a series of numbers on
Labels. I need a set of labels, counting by fives, from 1 to 3500. Just
wishing I didn't have to key in every number....0001-0005, etc.
Microsoft Word MVP
"Bridgett" <Bridgett@discussions.microsoft.com> wrote in message
> Is it possible to have word automatically fill in a series of numbers on
> Labels. I need a set of labels, counting by fives, from 1 ...converting from text to numerical number
I have a spread sheet of entire year schedule. The format as following:
1 2 3 .... 31
row 3 Jan
row 5 Feb
row x Dec
I would like to replace column 1 up to Jan to 1. Replace the cell below Jan
to Feb to 2. etc.
Would anyone help.
Thanks in advance.
You could select cells A1:A3, type a 1, then press Ctrl+Enter
Select A4:A5, type a 2, and press Ctrl+Enter
And so on, till all twelve months are done.
> I have a spread sheet of entire year schedule. The format as following:
> 1 2 3 .... 31
&...Single set of folders in Navigation Pane?
In Outlook 2007, I have Exchange Server and 2 POP accounts. I would like all
of the messages from all of the accounts to display in the navigation pane in
the same folders and follow the same rules and alerts. Currently I have
Mailbox fro exchange and Personal folders for the 2 POP accounts.
Can someone help me out with this?
You can set your delivery location for each account in;
Tools-> Account Settings...-> tab Email
You'll have to decide if you want the default location to be a pst-file or
the Exchange mailbox. If you choose for a pst-file, all the d...randomly scatter text
I have pub. 2003, I need to know how to take a phrase and randomly scatter it
allover the page, with out placing it manually. I was able to do it on the
last version of publisher but I can't seem to find the random button on this
Mary Sauer MSFT MVP
"jenice" <firstname.lastname@example.org> wrote in message
>I have pub. 2003, I need to know how to take a phrase and randomly scatter it
> all...How do I set up auto complete from a drop down list in Excel 2000.
I have a 10 sheet workbook that I will be sending out to various users around
the world. For their convenience, we are adding a lot of drop down lists for
them to choose from. However, since there are many options to choose from in
each list we would like for it to auto complete based on their initial
entries: Ed -> list to jump to Edinburgh, etc.... I have enabled the
AutoComplete in the cell values button in the Tools/Options/Edit tab, but it
is still not working. Any help on this matter would be greatly appreciated.
not possible for the data validation listboxes
--...I need help setting up my database
I used Access in the past, so I have a general idea on how to use it, but now
I have Microsoft 2007, so it's not as familiar. I currently have an excel
document with staff names and drills they have performed. The drills include
dates, times, an observer, and if they passed or failed. I had considered
doing something where I had a table with all my staff, and then connecting
tables for each person to list out the specifics for their drills. I don't
know how to link the relationship with that though because the table name was
the staff's name, so there wasn't a...Converting a number to Hour & Min format
I am attempting to take a basic number, say 2000, and convert the number into an hour and minute format (i.e. 33:33) only. Everytime I use the custom format tab or the time/date tab I get a date included or an AM/PM setting. Any ideas or suggestions? Thanks in advance.
For any number to be converted into time format you need to divide tha
number by 24, since Excel time code is 24 (hr) code. then you forma
the divided answer (83.33) into time, you will get 8:00
Message posted from http://www.ExcelForum.com
In article <...Setting series values on Excel Chart
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as i...Label of Number in a Range
I have set a high and low range of values with a correponding label,
how do I return the label of the range where the data point fits?
ColA ColB ColC
5 10 Low
11 20 Medium
21 30 High
D1 has the value 13 how do I get E1 to return the label "Medium"
"webnntp" <email@example.com> wrote in message
> I have set a high and low range of values with a correponding label,
> how do I return the label of the range where the data point ...Text Function with Different Formatting for Number
I'm trying to use a text function where I reference a number from another
cell but I need the text part to be bold and the number not to be bold. This
is the formula I'm using right now:
Unfortunately, excel won't let me just make the text bold without making the
number bold. Anyone have any suggestions? Thanks
I think a macro could do this, since it's really a string you're going to
wind up with. But if you can put the Sales: part in a separate cell, life
will be much easier anyway. then you ...Double emails when setting up new POP3
A long time problem I'd like to resolve is when setting up a new, or
resetting an user name and password for a POP3 mail account. In all
versions of outlook I have users who keep many months of email stored on the
mail server. I don't mind them keeping it there, but for some of these
people, when I setup a new logon name to the same mail account the Outlook
program is somehow reset and does not know that it already has months of
emails in its account. So, it goes ahead and downloads them all over again.
Well, I've used Duplicate Email remover that works nicely to remove t...length of lot number
increase the amount of characters in the lot number field. current field
length is not ample space to adequately describe lots in our organization.
Length of the item description was increased to 100. In our case, lots are
as important as items.
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 Agre...How to set up a uato incremnt in sql server 5000 express
I'm trying to get into database programming. Cannot figure out how to
do a auto int for my key value in sql server express.
On 19-12-2009 19:40, tedpottel wrote:
> I'm trying to get into database programming. Cannot figure out how to
> do a auto int for my key value in sql server express.
Set IDENTITY on the field.
PS: This is a C# forum.
"tedpottel" <firstname.lastname@example.org> wrote in message
> I'm trying to get into database programming. Cannot figu...