Sequentially numbered Purchase orders
In the past with Office 97. I used a purchase order template that would
basically self number itself. when it opened a small box would appear and by
clicking it the PO received a unique number. How can I accomplish this using
How can I make a property page active from a menu item? Thanks in
I got it.
"The Truth" <firstname.lastname@example.org.R.E.M.O.V.E.T.H.I.S.com.no.spam> wrote in
> How can I make a property page active from a menu item? Thanks in
...Printing Multiple Receipts at a Time From Journal
Is there a way to print multiple journaled receipts at a time? Say all
receipts for a batch or by date or other criteria?
Not that I've seen.
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader
to see and download the file attachment. If you are not using a reader,
follow the link below to setup Outlook Express. Click on "Open with
under the MS Retail Management System on the right.
"Tom Bombadill" <Genius_pos...Numbers in a text field-can I add them up?
Hi everyone! Using A02 on XP.
I have a table of data with survey response fields that contain a 0,1,2,3,4
or 5. However, the fields are formatted as text, not numbers. I need to add
up certain blocks (Items 1-6, Items 7-23, etc.) and then do some averaging.
I cannot change the field types from text. Must I append to a new table or
can I do something right in my query?
I've got one field in my query like this: ES:
My result is: 553453 or 554444, etc. I want: 25 or 22, etc.
I would really appreciate any help or advice. Thanks...OWA Password page not showing up.
I installed the hotfix from kb 833734. I've also tried to follow the steps
found at kb 327843.
However, when I set an account to "change password at next logon" and go to
that account in OWA on a FE that's using forms based auth, it doesn't
redirect to the page for changing an expired password. However if i direct
my browser to that page manually and fill in the form, it unexpires my
password just fine.
Is this how it's supposed to work? Shouldn't it detect that it's expired and
thus redirect me to the page for resetting my password?
This ...UserForm will not appear
Here is my code:
Private Sub CommandButton1_Click()
That's it. But every time I click on CommandButton1, I get this error:
"Application-define or object-defined error". The user form worked up until
today and I can't think of anything I've done to affect it. Can anyone help
me fix this?
I can't seem to recreate the error.
Do you have any code in the Userform1 Intialize Event? If so, post the code
in that event so we can try to fix the bug.
> Here is my code:
&g...How do I set the number format to Base 12?
I would like to change the number format on my spreadsheet from Base 10 to
Base 12, eg. 12 bottles makes up 1 case. Therefore, if I were adding up three
different cells 9 bottles + 11 bottles + 6 bottles, my result should be 2
cases 2 bottles if possible 2.2 in a case column.
See http://www.cpearson.com/excel/fractional.htm for details.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Andrew Moore" <AndrewMoore@discussions.microsoft.com> wrote in
>...How do I create a bookfold document in Word 2007?
I am new to Word 2007. How do I create a document in booklet form? Thanks
I'm sure you'll get better answers in an MSWord forum.
> I am new to Word 2007. How do I create a document in booklet form? Thanks
...Column styles doesn't appear on the worksheet
one of my customers has changed the windows xp designs to its own. From this
moment excel doesn't show the font color and the background color of a cell
in the worksheet. Only in the print preview you can see the color settings of
I'm not shure if this problem belongs to the changing of the windows xp
designs, but from this moment it did occur.
This occurs on new excel-documents and on existing ones. With another user
account on the same machine the problem doesn't occur.
I have reinstalled Office 2003 and even deleted user registry entries for
Office...Count on cell for each time it is changed
I would like to count the number of times a cell has been amended/ changed
e.g cell b2 has the word red it it, in cell c2 i would like a counter for
everytime the cell in b2 has changed, at the end of the day you get final
number. Is this at all possible?
You can do it by putting the following VBA macro in your sheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
Cells(2, 3) = Cells(2, 3) + 1
> I would like to count the number of times a cell has bee...Pulling counts out of query results
I have a query that has one field Type which is set to Count
The query results are used in a report.
The report has the fields in the detail section as TYPE and CountOfType (1
line only in the detail section)
The report looks like this when displayed
I need to be able to get the individual AS No (28) and add it to another
number elswhere in the report. How can I do this?
I have tried using a textbox with an if function (if
[type]="AS",CountOfType,0 but that did not work.
Any help appreciated.
I think you will need to do it in the query.
But try addi...Printing Word and excel documents via excel vba
I have a document that has some Excel and some word content i would
like to use excel vba to print both a page from word and then a page
from excel. I know how to select and open the word document, however i
cant find any code to print page X from word.
basically i need to:
print page 1 of c:\xx\document1.doc
print page1 of sheet1 of c:\yy\excelwkbk1.xls
print page 2 of c:\xx\document1.doc
print page2 of sheet1 of c:\yy\excelwkbk1.xls
and so on it will require moving between word and excel - the excel
bit i get, but getting back to excel from word, and printing out in
word is slightly more...Failed to open mmf error appears
A pop up window appears with the message 'failed to oepn
mmf'. I assume it is referring to Microsoft mail format.
What could be triggering this error.
What version of Outlook, and when do you see this error?
> A pop up window appears with the message 'failed to oepn
> mmf'. I assume it is referring to Microsoft mail format.
> What could be triggering this error.
>What version of Outlook, and when do you see this error?
>> A pop up window appears with the message 'fail...Time Delayed Response to MsgBox
I have a several "research" files that I set up to run a macro as soon as a
file is opened. In each case the macro retrieves and summarizes a bunch of
data taking several minutes to execute. I'm setting up a "master" file with
a simple macro that will open and close each of the "research" files
sequentially so I can run the series of reports without being at the computer
There are times where I want to open a "research" file to review the data
but not execute the macro. I'd like to add a MsgBox that prompts the user t...Adding up negative numbers only
Ok, let me try to explain this problem. I have several cells a1 throug
a10. Each cell has a number, for ex. $10.00, ($5.00),etc. , sometime
this number is positive, sometimes it is negative. I want to only ad
all of the negative numbers in cells a1:a10 and put a total in cel
a11. How can I do this?
tonydepo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1530
View this thread: http://www.excelforum.com/showthread.php?threadid=26928
=SUMIF(A1:A10,"<0&quo...Count Unique Items with Multiple Criteria
I am trying to get a list of how many lots a particular car model is
on. For example, say we have a spreadsheet that looks like:
Model License Lot
Ford xjd-394 1
Chevy gwg-394 2
Ford sdf-333 1
Ford lkj-111 3
Toyota skd-333 4
Toyota shk-584 4
I am loking for a way to get data that says how many unique lots each
car is on, so for example:
I was trying to do this with Pivot tables and the count functionality,
but it isn't quite getting me the results I want. I can get the
results with a pivot table ...How can I keep track of when (date and time) data is entered into.
I am trying to create a spreadsheet for a high school class. I need to be
able to track when a student has entered data into specific cells of the
spreadsheet. Any ideas?
In the code behind the worksheet, enter (eg)
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(1, 1).Value = Now()
This will enter in Cell A1 the date and time at which any entry is made in
If you need the location of the time-stamp to vary according to which cell
is changed then you can test the value of Target and vary the destination
Return email address is n...Run-time error 1004
I am using Excel 97 on NT and have a command button on a sheet to whic
I attached a macro for copying the sheet to a new workbook, deletin
specific columns and other unnecessary info, and saving the new book t
a network drive under a name with today's date for emailing to anothe
When I perform the function manually everything works beautifully bu
when I attempt to execute the macro I get the following error
"Run-time error '1004': Copy method of worksheet class failed". when
use the Debug button, VBA highlights Sheets("Daily").Copy as th
culprit. Macro f...Sequential Numbering
I would like to know the formula for making a cell be able to do sequential
numbering such as for purchase orders.
A simple way would be to use something like this, you could assign it to a
button, an open or before print event.
Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1
For other ways to do this or if this is going to be used in a temple have a
And if you are new to macros you may also what to have a look here on
getting start...Bizarre background window behavior in Word
I am running MS Office for Mac 2008 (12.2.4) on a 2008 Intel iMac with the
most recent version of Leopard OS. Since installing a recent upgrade to Mac
Office 2008, I have been having a frustrating problem when I keep multiple
documents open in Word. The active document will randomly be moved to the
background, while one of the inactive open documents will randomly move to
the foreground. Curiously, the inactive window now in the foreground
actually remains inactive, and if I continue typing, the text is placed in
the active window that is now hidden in the background. The only way to
b...Access To Word Mailmerge
I have setup a Mailmerge that is run from Access. The process works like
this: 1) The proper record is selected in an Access form which automatically
starts the process. 2) Word is called up automatically, it shows both the
template and the doument with the proper data in it. 3) Access is closed
automatically. 4) The user then needs to close the mailmerge template. 5)
The document with the proper mailmerge information inserted from Access is up
on the screen. At this point a shortcut is triggered by the user that adds a
document of the users choice to the end of the curre...E-Newsletter Doesn't Print All Pages
Outlook 2003 & 2007
I have a customer who designs and sends out an E-Newsletter in MS Publisher.
When I receive the e-newsletter and try to print it, it does not print all
of the pages of the newsletter. Typically it only prints the first page (of
I realize most would recommend that the customer send it out as a PDF
attachment, but the preference is to send it out as an e-newsletter.
Any thoughts on why I can not print all of the pages in the newsletter and
what I can do to make it work?
Thanks for giving this some thought.
w...Automatic Number Sequence
I would like to make a form in excel that automatically generates a number of
the form in one of the cells. How can I go about doing this, that everytime I
print a sheet it automatically generates a new number in the sequence? I have
tried playing around with macros and it doesn't seem to change, only stay at
a specific number. Is there an easier formula that this can be done with or
do I have to use macro's and how do I do it with macro's if that's what's
required?? It's a product information form for new products that need
entering into the system.
I would like to know if there is a way to set up when I enter the data
each cells on first row, it will default the date and time stamp on
first row. 2nd row should have the different date and time stamp than
I put "=now()" but it create the same date and time for 80 rows. I
don't want that. I want to enter each rows and each rows should be
different by one minute apart but same date - June 22.
Your help would be much appreciated.
Format A1:A79 as Custom dd-mmm-yy h:mm
Hold down CTRL Key and hit semi-colon key then <space> bar.
Sti...Inserting dashes to an existing number
I am trying to create a formula that will divide this ten digit numbe
into the following dashes.
Here is the number 1234000999 I need the dashes to be inserted in thi
What is the appropriate formula.
Thanks for your help.
dinahrose's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1334
View this thread: http://www.excelforum.com/showthread.php?threadid=26643
Why not just custom format
right click on selection>format>number>custom...