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,...Numbers and text
I have a link table from an Excel sheet. The first column is for account
numbers but some are numbers only and I get the "#num!" error. The only way I
can get rid of the error is to retype the number in Excel.
I have tried formatting the cells in Excel as "text" but it doesn't work.
Is there a work around?
...Auto complete in Excel (Office) 2003
Is it possible to increase the *memory* of autocomplete?? I notice in the
columns that excel will attempt to autocomplete if the text has been used in
the last 100 or so cells (i think). What I would like is it to attempt to
remember , say, 500 cells back. Is this possible?? Have I explained myself
well enough? :-)
Check http://www.excelforum.com/showthread.php?s=&threadid=219730 fo
Message posted from http://www.ExcelForum.com
...Outlook 2003 Imap Auto Purge wish list
I hope someone at Microsoft can code in a auto purge Imap
deleted email function into there next Service Pack. I
can see a problem rolling this out to our employees.
There going to delete messages and those messages are
going to stay on the Email server until they do a Purge.
I'm afraid they just won't do this.
We use Imap.
No auto purge means emails staying on the server which
over time just takes up hard drive space and makes tape
backups take longer.
You should send suggestions to email@example.com as the newsgroups are
not monitored for feature request...Auto Forward mail to a group of External addresses
Can someone please tell me how I create an Auto Forward
to a group of external email addresses.
I want to setup an auto forward on my exchange so that
all mail sent to firstname.lastname@example.org is then forwarded
to a group of email accounts such as email@example.com,
Can someone please tell me how I set this up on an
exchange server. I know how to do it for an individual
but I can't work out how I create an auto forward for a
group of people.
Thanks for any advice!
what version Exchange? only the terminology is different...create custom
recipients/contacts ...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
In my Account List view, I see that there
are "Transactions to read: 13" for my checking account.
However, when I go to my checking account, there are no
unread transactions! Note that I do have "View: All
Transactions covering All Dates" selected as the view, so
I would expect to see all of the transactions.
I've been using MS Money for years, and this is the first
time this problem has come up. Does anyone have any
suggestions on how to resolve this?
You could try deleting the statement from the account list, right click
where it says 'X tr...Voiding Transactions
We are trying to analyze whether to void or delete orders and have questions
as far as what happens when an order is voided. I've tried searching the
knowledgebase and in the documenatation folder but it doesn't have the
information that I'm looking for.
Can someone tell me what what happens when you void an order and whether it
un-allocates the line items on the order? Also, we know that it goes to
history when the order is voided but how do we know it is a voided order from
any other type of order?
* will be shown with voided orders which shows ...Vendor transactions and checks
I'm trying to create a vendor payment report from my program. From which
tables I can get the vendor payable transaction information??? I also need
to know whether there is a check aleady issue to a transaction.
When I press F2 I am able to see all of my items, and the quantity that I
have. I see an item that will say quantity 3, when I press properties, then
inventory it will show quantity 2...I had just re-indexed my computer, not
sure why it does this?
...Simple Question-How to create more than one transaction on the Acc
If there is a question already posted let me know. The question is: I created
a bank account information on the Account list icon and want to have more
than (one)transactions listed and see each payee displayed separately on
each page so i could have all the months posted with due dates and total
listed. Thank you.
In microsoft.public.money, a.j. wrote:
>If there is a question already posted let me know. The question is: I created
>a bank account information on the Account list icon and want to have more
>than (one)transactions listed and see each payee displayed separately ...XL 2007: How to find out what keyboard shortcuts I've assigned to macros?
Over the years, I've recorded and written a lot of macros. (Probably
time to take a week or two and go over them and delete at least
half!) I assigned a keyboard shortcut to a lot of them.
I seem to remember that before XL 2007, there was a keyboard organizer
that I could go through and review what shortcuts I had already
assigned to my macros. I can't find that in 2007, though.
Is there an easy way to generate a list of all my keyboard assignments
and what macros they go to?
I don't recall ever seeing any such keyboard organizer in 2007.
Canned from a prev...Auto forward incoming mails.
How to configure such that all incoming mails to exchange will auto forward
to my personnal email address?
You can create a rule for that; Tools-> Rules and Alerts
Note that automatic forwarding is disabled by (secure) default on the
Exchange server. To enable see;
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Emyeu" <firstname.lastname@example.org> wrote in message
news:uNQsdGAkEHA....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...Paid Sales Transaction Removal error message
When I try to do run a "Paid Sales Transaction Removal" against a specify
customer (Microsoft Dynamics GP menu >> Tools >> Routines >> Sales >> Paid
Transaction Removal) in Dynamics GP 10 with SQL 2005, I get the following
error: [Microsoft] [SQL Native Client] [SQL Server] Violation of PRIMARY KEY
constraint ‘PKRM30101’. Cannot insert duplicate key in object 'dbo.RM30101'.
I searched for the error message in Customer Source Knowledge base and found
Article ID : 861084, which I followed and it showed the duplicate document
(invoice...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
Any way that we can assign leads / opportunities / other entities to teams
rather than individuals?
All the best
Team ownership is not supported in CRM 3.0. Could you describe your
scenario, and maybe we could provide some alternatives?
Microsoft Dynamics CRM
This posting is provided "AS IS" with no warranties and confers no rights.
"Electronic Workplace" <info@electronicworkplace.LoseThisBit.com> wrote in
> Any way that we can assign leads /...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...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...