auto number index snafu
I have a 2003 DB I've been adding to for 2 years. It's at 423 records =
I export to a PDF for simpler searching and viewing.
Using the search the other day, I went to grab DVD 186, on carousel tower=
And what came up didn't match the record.
The index was totally screwed.
I went thru all 423 records and created a numeric index by hand. The auto
number field is useless.
But I would still prefer an auto number field.
Trouble is when I create the auto number field, it's still off the actual
numbers of the records..
ie: 99-100 is actually 99-186,187, 188, 189 100-385,...Auto assign Lot Numbers in PO receiving
Has anyone made a customization to auto assign Lot numbers upon item
receipt? My client's lot number is numeric, they want the system to auto
assign this. Any ideas? Thanks!
Yes indeed, I created one for a client. You probably will not be able to
use it as-is because of some client specific functionality but
I'm sure you could use this as a stepping stone.
The key features were that it would allow for rapid lot number entry by
a. Auto-incrementing the lot number - we had Alphanumeric lot numbers so we
added a suffix and
b. copy the previous lo...Sequential ticket numbers and printing 4 to a page
i have mail merged my numbers from excel into my publisher ticket. Thanks
that worked well, now i want to print 4 tickets to an A4 page and in print
preview, i get 4 tickets all with the same number on one page. how do i get
Print preview showing all the same is a bug. Print a test page.
Mary Sauer MSFT MVP
"Neyol" <Neyol@discussions.microsoft.com> wrote in message
news:90034D4C-9951-4550-9DAC...Displaying MS Excel Chart control in ASP.NET Application
We are working on an ASP.NET (VB.NET) application. In one of th
screens of our application, we need to show a graph and for this we ar
using MS Excel Graph control. We have the graph prepared in Excel. Th
application would feed in certain values into certain cells of th
excel file and the graph would be drawn by the graph control based o
We need some help on how exactly to display the excel graph contro
directly on the screen of ASP.NET application.
Thanks for the help
...Dates in fomula showing as whole number
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires
(From cell 2D). The expire date in "2D" is either the word "none" or a date
that that persons license needs to be renewed.
Those instructors with "None" come out in the calculated field fine, however
the ones with dates come back as whole numbers, Example 8/6/10 shows 40396.
any help will be appreciated
You need to change the format of that cell or column, highlight the cell or
the column, right click o...Enter "1", cell show ".01". Why?
Any number typed into a cell is divided by 100.
If proceded by "=" the number is correct.
What caused this and how can I fix it?
Try this ..
Click Tools > Options > Edit tab
Uncheck "Fixed decimal" > OK
Things should be back to normal now ..
(it's a fixed decimal setting !)
"Yonian" <Yonian@discussions.microsoft.com> wrote in message
> Any number typed into a cell is divided by 100.
> If p...Drivers for percentage increase
I am trying to set up a driver to include in my budget profile so that my
managers can select the percentage from a driver and see on each budget line
what the outcome will be i.e
staff costs may be calculated at 150,000 but if I used my driver to
calculate an increase of 3.5% that would change the staff costs to 155,250.
Can anyone help?
I am not sure what you question is but this may help:-
In cell A 2 I have 150,000
In cell B 2 I have 3.5%
In cell C 2 I have:-
- and this returns 155,250 to cell C 2.
If my comments have helped please h...How to increase an entire collumn by a certain percentage?
I have a collumn of dollar amounts that I want to increase by a certain
mulaplier, say 35%. Is there any way to do this? The collumns are on
average 30 rows long, with various amounts.
In an empty cell somewhere type 1.35 (for 35%). Then do the following:
1. Select and copy that cell with 1.35 in it
2. Then select the column of numbers that you want increased by 35%
3. Click Edit/Paste Special
4. Under Paste, select "Formulas"
5. Under Operation, select "Multiply"
6. Click OK
> I have a collumn of dollar amounts that I want to increa...Percentage difference calc that knows the largest figure
I have a calculation in cell A3 which looks at the content of Cell A1 and
Cell A2 and then works out the difference between both as a percentage
Cell A1 = 100
Cell A2 = 10
Cell A3 returns the difference as being 90%
My simple calculation in Cell A3 is as follows =(A1-A2)/A1
Cell A3 is formatted to give the answer as a percentage to 2 decimal places
The above works fine as long as the number in Cell A1 is greater than the
number in Cell A2
If the number in A2 is greater than the number in A1 then my calculated
answer is incorrect
Cell A1 = 10...Display Report Header/Footer
Can somebody please give me the telephone number of the smartass MS VP who
came up with the bright idea for the Ribbon so that I can call her and have
her tell me how to display the Report Header & Footer in a report?
Obviously, I must be an idiot because I can't figure out how to do it with
this simplied, intuitive, help-ya out m***** fu***** ribbon.
Oh stupid me, its under 'ARRANGE'. How idiotic of me to think that it'd
under 'DESIGN' since I'm 'designing' a report as opposed to 'arrangeing' a
"microsoft"...matching columns of numbers
In EXCEL 2000 for Windows, I have two columns of numbers. Column A has
500 numbers, Column B has 1000 numbers. I need to know which cells in
Column A have a match in Column B, and if so, what is the Cell (or row
number) in B that matches to that particular cell in A. How can I do
Thank you for your help.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
try the following:
- insert a new column between A and B (so make B the new C column)
enter the following in B1
=IF(ISNA(MATCH...Ordering by number and text
I use a report to print out checklists that in the detail section have item
number to delineate each checklist item. The item numbers as an example are
1-1, 1-2, 1-2a, 1-2b, or 2-1, 2-2, 2-3, 2-3a, 2-3b and so on. The report is
grouped by checklist section and the grouping works perfectly but when the
report is printed the item numbers are ordered in this order 1-1, 1-10, 1-11,
1-2, 1-3, 1-3a, 1-3b, 1-4, 1-5, 1-6, 1-7, 1-9.
Obviously I want the the order to be in proper numerical sequence where 1-10
comes after 1-9. but even replacing the '-' with a decimal point doesn't
...Zero filling a number field
I have an auto number field that I want to zero fill to six digits but
can't figure out how. Any ideas?
You don''t say where you're trying to do this, but basically
>I have an auto number field that I want to zero fill to six digits but
>can't figure out how. Any ideas?
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
You can't do that wi...How do I change numbers to negative without re-typing?
I have a large range of data that needs to be changed to negative numbers,
Can I do this in Excel?
...Determine number of rows with data
I am using the macro below to pull some data from an external workbook.
The 2 issues I need to sort are:
1. The number of rows in the external workbook can vary. How do I amend this
code to pull all of the rows with data?
2. The number of rows in the autofill also may vary. How do I autofill only
the number of rows required? i.e the number of rows in column A that contain
'Lookup Previous Month Sales
Selection.NumberFormat = "General"
Selection.FormulaArray = _
"=S...Converting number to text
Is it possible to convert, say 1234 to one thousand two hundred and thirty
There is no direct functions to convert this. For a VBA solution check out
the below links
Jacob (MVP - Excel)
> Is it possible to convert, say 1234 to one thousand two hundred and thirty
...Sequentially number lines automatically
Operating System: Mac OS X 10.5 (Leopard)
How can automatically number the lines as I enter data. <br><br>so box A1 would automatically be 1 <br>
and the next time I created an entry on another line that line would be 2, etc. <br><br>The reason is so that I can sort, delete and the numbers will remain, so I can also go back to the order than things were entered into. <br><br>Could do this manually, but a pain. <br><br>Or could possibly do this with a date and time? <br><br>Thanks Steevee
Se...OWA Premium Client Not Displaying Correctly
I wonder whether anyone has seen this problem before because i would
really appreciate any help on this one please.
I have six Exchange 2003 servers in my organisation and there are two
Exchange servers in three sites. Four of the Exchange servers are
running Windows Server 2003 and Exchange Server 2003 [With Exchange
SP1]. The front-end server is running Windows Server 2003 SP1 and
Exchange Server 2003 SP2. Users with mailboxes on those four Back-End
Exchange servers do not have any problems using OWA.
The two Exchange servers on my site are using Windows Server 2003 SP1
with Exc...Excel Number Format Codes
I can't figure out how to format numbers so that when you type 3220 it will look like 32.20 kinda like how you can enter numbers on an adding machine. I would greatly appreciate this number format code. Thank you.
I think you want to go Tools | Options | Edit | Fixed Decimals - 2.
That will divide all the numbers you enter by 100.
You will also have to format the row or column to display 2 decimals.
Select the cells or range, right mouse click, format cells, numbers, 2
Hope that helps.
"MBB" <MBB@discussions.microsoft.com> w...Receivings Number
When I am doing my purchase receiving at the Receivings Entry, I sometimes
encounter some problem which the Receivings Number.
For example, suppose the new receivings number should
be REC/03/000004, but this number REC/03/000005 is given
to me instead. What could be the possible cause of the
missing receivings number:REC/03/000004. (this no. is not
used by anyone).
Please advise or tell me how can I avoid.
Thanks in advance.
I believe it's when someone started to do a receivings but then deleted it.
It already increments to the next number. You can prevent deleting of
documen...Limit number of characters in a cell
Is there a way to limit the number of characters that a user can key into a
I want to get a list of names and addresses imputted by user, but I don't
want them to be more than 35 characters.
Thanks for the help
Take a look at Data|Validation.
You can have excel yell at the user when they hit enter after typing in a
Dr Senji wrote:
> Is there a way to limit the number of characters that a user can key into a
> I want to get a list of names and addresses imputted by user, but I don't
> want the...Counting the number of times more than 1 variable occurs
I need to determine how many Separations were processed by a particular
A | B
1 MIKE | SEPARATION
2 MIKE | LEAVE
3 SARA | SEPARATION
4 JOE | SEPARATION
5 JAMIE | LEAVE
6 MIKE | LEAVE
7 JOE | LEAVE
8 SARA | SEPARATION
The only way I can think of is the COUNTIF Funtion
This does not work though. The results return 0 with no errors when
the answer should be 1.
does anyone else know of a wa...number of lines on a word document
Operating System: Mac OS X 10.5 (Leopard)
I want to produce a long, double-spaced document with the same number of lines on each page, not one that flips to a new page if the end paragraph is too large to fit. Can anyone help?
Maintaining a constant number of lines per page is dependent on at least 2
1- Using the same font & font size throughout, &
2- Turning off Widow/Orphan control in Format> Paragraph - Line & Page
Due to the proportional spacing considerations of modern word processing --
which is more closely akin to typesetting than typewr...Counting number of words in a sentence and highlighting or commenting
I found some old code, from Helmut of Bavaria I believe, that is
supposed to find long sentences in a document:
Dim rDcm As Range ' the documents main story range
Dim oWrd As Object ' a word
Dim oSnt As Object ' a sentence
Dim oPrg As Paragraph ' a paragraph
Dim lWrd As Long ' a counter for words
Dim lSnt As Long ' a counter for sentences
Dim lPrg As Long ' a counter for paragraphs
Set rDcm = ActiveDocument.Range
For Each oPrg In rDcm.Paragraphs
lPrg = lPrg + 1
lSnt = 0
For Each oSnt I...Change a positive number to negative number
I have a column of positive numbers that I need to change to negativ
numbers. Is there an easy way to do this? Right now I manualy make th
change. Thank you, Pa
patowens's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2456
View this thread: http://www.excelforum.com/showthread.php?threadid=38155
patowens, put -1 in an empty cell, copy that cell, select the numbers you
want to change, right click and paste special, check multiply, OK.
Always backup your data before tr...