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...2004 trial, how do I get rid of it?
My trial is over, and I want my Money 2002 back. Does
anyone know how I can do that?
The easiest way is to use control panel->add/remove programs to remove the
2004 trial pieces (there are two programs to uninstall). Then reinstall 2002
and use the backup file created when you first installed Money 2004 - it'll
be named something like My Money.M10. Any transactions entered in the trial
which you want to keep will need to be re-entered into the 2002 version, as
you can't downgrade a file from 2004 to 2002.
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.co...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...Where to get missing msvcp70.dll?
After I uninstalled a bunch of software, when I run an app it says app
failed because msvcp70.dll was not found.
Re-installing that app does not help. I guess I need to restore the missing
msvcp70.dll. What is the official way to get it?
Some sites offer this file for download but I'm not sure the files are
In my system32 folder there is msvcp50.dll, msvcp60.dll, msvcp71.dll, but no
msvcp70.dll. It is not in the recycle bin either :(
"james" <firstname.lastname@example.org> wrote in message
> After I un...get rid of macro option at startup
I created and then deleted a macro in an Excel file.
Why do I still get the warning box (i.e. the one asking if I want to enable
or disable macros) when I open the file?
Is there a way to get rid of this since I no longer have macros in this
You need to delete the empty module.!
"Brad Rench" <email@example.com> wrote in message
> I created and then deleted a macro in an Excel file.
> Why do I still get the warning box (i.e. the one asking if I want to
> or disable macros) when I o...AOL IMAP account
I have set up AOL email account as IMAP type and keep getting pop up in outlook " your IMAP server wants to alert you the following: Can't read attachment for message 6438.
this pops up for many times and each time the number is different.
new profile same issue.
Office Version:Office 2007
Operating System:Windows Vista / Windows 7 - same issue.
Submitted using http://www.outlookforums.com
Do you have a virus scanner installed which integrates itself with Outlook?
Uninstall this integration part of your virus scanner and try again; you'd
still be sufficiently p...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...Exchange 2003 SP1 to get DST patch & Exchange 2000 patch is available to anyone for $4,000
This is a multi-part message in MIME format.
In the "New Highlights" section: "Exchange Server 2003 SP1 will now be =
supported for an updated version of the Exchange CDO patch to be =
"DST Hotfixes for products in Extended Support can now be purchased for =
I'd like to make a menu page with buttons to jump between spreadsheets
of a workbook. I will turn off the tabs at the bottom in order to do
this, but I'm looking for code for my menu buttons to flip to each
Also to return to the menu from a specific spreadsheet, I'd like to use
a right click to jump back to the menu. Can someone help me with this.
I'm used to programming in MS Access, so programming in MS Excel is a
new venture for me.
How about an alternative...
Create that index worksheet and put hyperlinks to A1 of each sheet.
And then put a hyp...Can Outlook 2003 use MSN Messenger INSTEAD of Windows Messenger?
I didn't get an answer to this question last week so I'm re-posting...
I recently purchased a new computer (Windows XP Home Edition w/SP2) and
loaded up all of the available updates to the OS, Internet Explorer, etc.
Next, I installed Office 2003 Professional. I disabled Messenger
integration with Outlook 2003 as discussed in other posts here.
Next I installed MSN Messenger 6.2 and it seemed to run properly as
a stand-alone application. So I re-enabled Messenger integration on Outlook
2003. The next time I booted up and ran Outlook, the Messenger icon appeared
in the taskbar...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...Detect page change in PropertySheet?
Hi, I have a property sheet that is the parent of several property pages. If
the user clicks a tab to change to another page, is there a way I can detect
this (and possibly prevent the change) in the PropertySheet dialog? Does
windows/MFC send any kind of message to the PropertySheet dialog?
I looked at all of the over-rides and WM_ message, but cannot see anything.
Not directly. You can catch that in the CPropertyPage and relay the message
to the CPropertySheet. (I know you are asking, why doesn't the
CPropertySheet get the notificatio first? who knows!)
"...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...How do I print only odd pages in Publisher and then only even page
I am attempting duplex printing with a printer that is unable to do duplex
printing by printing odd pages first and then flipping the pages over and
printing only even pages.
No option is given that I can find in the print window.
Sarah Wright wrote:
> I am attempting duplex printing with a printer that is unable to do
> duplex printing by printing odd pages first and then flipping the
> pages over and printing only even pages.
> No option is given that I can find in the print window.
The duplex printing add-in can be found here
(http://publisherm...Getting kicked of outlook2003
Every time I print directly after I get kicked offline
Do you mean that Outlook closes?
"jp614" <email@example.com> wrote in message
> Every time I print directly after I get kicked offline
No, It completely boots me off the network. When I loose connection to
Outlook it takes my computer offline--looses connection...
"Vince Averello [MVP-Outlook]" wrote:
> Do you mean that Outlook closes?
> "jp614" <firstname.lastname@example.org> wrote in message
> ...Add a blank page separator
How do I add a blank page automatically as a separator after every 15 pages
when printing a document of 250 pages?
Use a macro containing the following code to print the document:
Dim i As Long
Dim blank As Document
For i = 1 To 240 Step 15
ActiveDocument.PrintOut Range:=wdPrintFromTo, From:=i, To:=i + 15
Set blank = Documents.Add
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professio...Formatting cells and getting pound signs
I am using Excel 2003 with all updates as of 4/28/04 and trying to format a cell using the custom category and choosing the #,##0.00 type.
I am trying to add the $ symbol at the beginning of the type and add text at the end of the type to look like this $#,##0.00 "text".
When I do this however it shows up in my cell on my worksheet as ##########. It does know what the value is and shows as I would expect it to when I place mouse over cell in a balloon
If I use only the $ symbol befor the type it shows fine. If I use only the "text" after the type is shows fine. Using the...Can I show server name instead of drive letter?
When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?
where ServerName is the name of the server and drive is the appropriate
drive, and then find the file on the drive from that point.
> When using the =Cell("filename") function, I would like to show the actual
> server instead of a drive letter because the letter is dependent on...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...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?
...get rid of extra spaces between paragraphs worked only once.
Changed style from Word 7 to Word 3, used help online, but still have 2 left
with spaces I cannot get rid of on my last page. Got any help for me?
Only fools and bigots prefer French over Spanish to be taught in public or
In the Styles pane (Ctrl+Alt+Shift+S), right-click the style name and choose
Modify from the context menu. In the Modify Style dialog box, click Format,
Paragraph. Make sure that Line Spacing is what you want, and that Spacing
Before and Spacing After are both set to zero. Click OK. To transfer the
style definition to the attached template, d...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