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,...Default picklist values not appearing on convert from lead to acco
Converting a lead to an account. I have several picklist fields (on the
account) which should bring up a default value. When I create a new account
from scratch they all appear. When I convert a lead to an account none of the
default values are there. There are no offending mappings or scripts that
would explain this. Has anyone else seen this or can offer any guidance.
Default values are not set on enties which are converted or created trough
the webservice. The only way to have a default value set for any path is to
use the PreCreate Callout.
Patrick Verbeeten (MC...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...Price from database does not showup correctly in POS
When I try to ring up items in the POS the sale price of some items does not
showup correctly in POS. It shows a totally different sale price which is
sometimes less or sometimes more than the sale price in the database. I
always bachup my database and also refresh the Sql server but the problem
Does anybody has a solution to this.
Try reindexing the DB in SO Administrator - Database/Reindex
Other than that, can you provide more details? Have you set up customers
with Discount Percentages or Price Levels?
Tiber Creek Consulting
http://www.t...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...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...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
...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...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...Managing Incomplete Purchase Orders
What should we do when we receive a purchasse order and not all products were
Here is how we are set up. All products are marked as "allow backorder". We
have this set up this way so we cna special order a product if needed.
However, the vendors do no backorder. If a product isn't shipped, we need to
The problem occurs after we receive (as shipment/invoice). The unreceived
items on the PO remain open. Since we use Purchase Order Generator, the items
are not reordered because they are still "on order" in the system.
What are we supposed to ...Setting the default font and font size for Excel comments
Do you know how to set the default font and font size in
Excel for the cell 'Comments'?
I have looked in Options as well as in the registry to see
if I can change the default from Tahoma (size 8) to
another (i.e. Arial size 12).
Your help would really be appreciated.
Clint - UK
...Purchase Order 2.0.0127
Am I the only one having issues with the upgrade?
1) I create a purchase order
2) I click on add item
3) I type in the supplier ILC, and nothing comes up (ONLY on some items)!
4) I click on all items, and find the item, and add it!
5) When I click on OK the item is added to the purchase order, along with
the supplier ILC!
When I click on all items, even though the item may be in the database, I
can't find it to add to the PO, unless I close out the PO and re-open it???
This started happening only since I upgraded the the 2.0.0127!
Yes...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...Winfax question before purchase
i dont know where else to place this and there have been alot of posts
in here relating to winfax, so here goes:
I run a business and all of the time we get customers telling us they
faxed something, and we have no record of it. now sometimes they never
sent it...sometimes they sent it upside down and we received it
blank..sometimes we just lost it. I am thinking that Winfax might be a
solution to my problems, but I need to know a few things.
A. can I set up winfax so that I plug my fax line into my comp, it
receives the fax, and automatically prints it out to my printer
(functioning jus...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
...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...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...Error trying to make an account default
I have a new computer and my outlook 2003 is not letting
me assign a default account to send and receive. I get
this error: "The Specicied Account could not be found. It
might have been deleted."
I have four accounnts setup and have tried removing the
accounts and recreating them and still get the error.
when the account has been made, it tests fine. None of
the four can be made default.
Thanks in Advance!
...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...Multiple Sales Transaction for Same Work Order
I am in the process of trying to create a store level report by department,
catagory, and item of the moneys received in total by both deposit on work
orders and on direct sales that are not work orders. We require a 100%
deposit (of a single tender type) on work orders. I then need to break this
deposit down by department, catagory and item. Then I must add that to the
same break down for direct sales. Thereby getting a total of all moneys
received during a specified period for the store across all registers.
So basically I am trying to figure out the data structure and org...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...Quotes, orders and invoices all crash CRM!
I have a post update callout process which I have attached to the
update event on the quote, order and invoice. Having attached the
process whenever I attempt to read an existing quote, order or invoice
or to save a new quote, order or invoice CRM presents its 'an error
has occurred please contact your system administrator' message.
Normally in this case I would check the event viewer but in this case
it is completely empty! The callout process as it's first action logs
a message to a file just so that I can monitor the progress and this
is not happening so it appears that the pro...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...Activity History Order Chronologicaly
Is there a way to order the activity history by data and time
completed? My users would like to be able to take a look at history and
see what was the list activity that they had with an account or contact
or lead and continue where they left off, but know it seems like they
have to open and close a whole bunch of history to see where they are
you could use this unsupported work-a-round to add the collom:
You can see the GUIDs i SavedQueryBase
remember this is UNSUPPORTED.
or you ...