automaticly copy text to header
I want a my template file to automaticly copy a text item (file or case
number) into the header so that it will print on each page 2 throough the end
of the document. Anyone know how this can be done?
Copy from where?
Many ways to do it, depending upon the answer to that question. If the file
number was being entered into a userform, it could be written to a document
variable and then displayed where required in the document by the use of
See the following page of fellow MVP Greg Maxey's website :
http://gregmaxey.mvps.org/Create_and_employ_a_UserF...about transfer order
I created a transfer order "TO666", transfer items from store01 to store02,
the system automaticly created a TO No."00001_TO666 ". And the strange thing
happend: the items in "TO666" is so different with the items in "00001_TO666
where is the problem?
with a lot of thanks.
Try creating another order with the same items, if the problem still exists,
most probably you have a problem in the IDs of those items.
What HQ does is to map the items in the created order in Store1 to the
corresponding items in HQ, then map them again to Store2 and th...automatic time formatting
In attempting to run mail merge with word, if the time format has the am / pm
in it, the contents of the cell are entered as a decimal. But if one can
enter the time as (9:15) the contents in the mail merge appear as they were
entered. trouble is that any time I enter a number such as above, it
automatically formats to (hh:hh:ss am/pm) how do i turn off the automatic
format! I have attempted to change the format to the custom (hh:mm)once the
extended time is in the cell, but though it is selected and entered, the
contents of the cell do not change. I have used excell mail ...Transfering messages
I want to transfer all my messages from one PC running Vista to another
running Win7 which I have Windows Mail running on. However, I have two
1. On transferring some of the transferred folders contain the full message,
some only contain what you might call place holders e.g my transferred Inbox
has 'From' with a list of 30 or so messages but just shows an envelop and
the date and time but no message
2. Is there away to transfer attachments too?
"Ron O'Brien" <email@example.com> wrote in message
news:uBH3g6UjKHA.218...Date format #16
I want to format a column of cells so that when 012208 is entered with the
numeric keypad, 01/22/2008 appears in the cell. So far, I'm getting
Hate to say it but why not just type the extra two characters to make
If you type "12208" in a cell, Excel assumes you are entering a serial
date (hence the conversion to 6/3/1933). How much easier to just type
the two "/" and don't force Excel to guess what you want.
On Jan 22, 10:00=A0pm, "Cathy C" <cchrist...@aristotle.net> wrote:
> I want to format a...HR Position Transfers
Is there a way to import a mass amount of position changes in GP HR?
We are getting ready to effect changes for our upcoming fiscal year.
There are numerous changes to our departments, positions moving from
one department to another and some of the departments are altogether
new. Is there a tool to import Position Change/Transfers? If not,
does anyone know all the tables I would need to hit if I need to
import the data?
...SendObject Not going to PDF Automatically
When i do this SendObject it doesnt automatically go to pdf but rather
DoCmd.SendObject acReport, stDocName, asFormatPDF, "", "", "", "Training
Confirmation: " & txtCourse & " on " & dateStartDate & " to " & dateEndDate,
I can tell you that asFormatPDF doesn't exist as a constant in Access.
Try using acFormatPDF
> When i do this SendObject it doesnt automatically...Excel to PDG Format Error
I am used to using Excel 2007 to convert my workbooks into PDF's. However,
recently, all of a sudden, everytime I PDF a workbook my Formating and graphs
are all wrong. I have noticed that this only happens when I do multiple
sheets, but the problem with doing individual ones is that I can't combine
them with reader.
Try Dr. Dan's All-Purpose Excel-PDF Cure:
Select all worksheets by <ctrl> or <shift> clicking
from the menu bar: File > Page Setup
click into the Page Quality box, and select 600dpi, if it already says
600dpi, select it again.
...Windows Easy Transfer
I am having trouble with Easy Transfer from an XPhome to XPhome installation.
Actually it is the same computer after re-installing XP. I ran the Easy
Transfer to back up the data onto an external drive. When I run it now on the
new build I don't get the "Continue transfer in Progress" option. It does not
ask if this is the new or old computer. I haven't used it before so maybe I
am not using it as intended. I have user the XP File settings and transfer
program for a situation just like this with no problems.
Computer is a basic HP Pavi...Automatic sorting in Excel #2
Your technique works a treat when I insert the code; however, when I save the file and reload it (after having saved it as a Macro-enabled Worksheet in 2007), the code does not seem to work.
Am I doing something wrong?
EggHeadCafe - .NET Developer Portal of Choice
Did you enable macros when you opened the workbook?
One more thing--your post is a standalone post. I'm not sure any reader will
understand what code you're writing about. In this case, it's not important,
Anand, Dhuru wrote:
> Your technique works a tr...Creating a Rule in Outlook to Automatically Pair replys
Not sure if this is the right place but im trying to create a rule for
outlook at work so that it automatically pairs sent emails with replys
and moves them to a specific folder in outlook.
Now all emails get sent to a shared email address and then we each take
turns (a week each) replying to the ones we get so im thinking the best
way to do this is if its possible to have a macro that automatically
can do this? instead of pairing up my emails with replys all the time,
even though i could just click subject and then select the ones i want
this is very time consuming as ...Transferring an order to an invoice...
We are transferring over to GP 10. I have a question about invoicing that
I hope someone here can help me with.
In GP 8, there was a transfer button on the Sales Order Transaction screen
to transfer the order to an invoice. In GP 10, the transfer option is in a
pull down menu. Can we make the transfer option a 3rd button on the screen?
If someone could let me know, I would appreciate your help greatly!
yes you should be able to do that if you wish using a button and a bit of
This posting is provided "AS IS" with no warranties, a...Automatically Update Date/Time in Template
I can insert a date/time in a new message if I am using Word as my
editor, but then I cannot save it as a template (why you would want an
auto-updating field in a message that cannot be stored as a template is
another question). If I switch off Word as the editor so that I can save
as a template, I cannot insert a date/time and have it auto-update. Is
there a way out of this conundrum, or should I just chalk it up to
another peculiarity of MS software?
Thanks for any assistance.
...System does not auto create Transfer In during Inter-store transfe
my customer running 2 stores and both store having the same interstore
transfer option setting. my problem is 1 of the store does not auto generate
Transfer In doc
1. store A - Transfer Out Doc store B - auto generate
transfer In Doc
store A uploaded 2 HQ message to HQ & store B received 2 HQ message.
2. store B - Transfer Out Doc store A - NOTHING GENERATED
store B only uploaded 1 HQ message to HQ & store A received 1 HQ message.
anyone got ideas how to solved this?
Did you set the HQ Configuration options to auto gen...Formatting Cells/Data
Hi, I hope you are doing well.
I have a file I downloaded from our AS/400 (OS400 operating system). I open
the file as a text file and go thru the wizard for converting the file to
excel format. One of the columns/fields is numeric with some neg and pos
numbers and some blank cell contents. During the wizard conversion the field
is categorized as DOUBLE with no option to change the field. When I finish
the wizard I save the file as an Excel workbook. Then I use the autosum
option to calculate the total of the field/column; however, it only picks up
on the positive #'s. Hence the t...Condition Format syntax
I have pairs of cells to test.
What I want to check is if the value of the 2nd cell is higher than the
first, but less than 1.5 times as high.
I've tried various syntax combinations using 'Formula is', but just
can't seem to hit the right one (Excel 2003).
Can anyone help?
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)
Try this one:
"Paul Hyett" <firstname.lastname@example.org> skrev i meddelelsen
I need to know how to format a cell for time. I need to have the cell formatted so that when I type in the cell say 125211 or 12 52 11 it will automatically appear as 12:52:11.
For a possible solution see
"Denise" <email@example.com> wrote in message
> I need to know how to format a cell for time. I need to have the cell
formatted so that when I type in the cell say 125211 or 12 52 11 it will
automatically appear as ...TRANSFER OUT TO TRANSFER OUT
I HAVE BEEN WORKING WITH RMS FOR OVER A YEAR AND HAVE NEVER SEEN THIS
STORE A MAKES A TRANSFER OUT AND STORE B RECEIVES A COMPUTER TRANSFER IN THE
TRANSFER OUT WINDOW INSTEAD OF A TRANSFER IN. IN ADDITION TO THAT THE
TRANSFER HAS BEEN CLOSED AT STORE B'S END AUTOMITICALLY AND IT IS EMPTY.
AN KNOWLEDGE AS TO WHY THIS HAPPENS
Check HQ Client for errors, or from HQ Manager, view the event log for that
store. You'll probably find some errors at Store B on the 401 that created
I would guess that Store A used a transfer number with more than 14
My simple chart project has turned ugly.
I have several charts linked from different files into my
active spreadsheet. The x axis on all of these linked
charts are date fields. However, on all of these linked
charts a general number format is showing up not a date
format. Is there anyway to have these numbers defaulted
to a dated format?
I've had problems with dates looking like numbers on axes
in the past, and to get them to look like dates I had to
go into the axis properties (right-click the axis or one
of the numbers on the axis, then click on "format axis")
an...Macro-Return Blank Cell
I am creating an Invoice by the help of macro where I want to clear all the
data from unlock cell after entering the buttom named NEXT or OK.So I could
enter fresh data in the same unlock cell.
How it possible?
Dim cel As Range, r As Range
For Each r In ActiveSheet.UsedRange
If r.Locked Then
If cel Is Nothing Then
Set cel = r
Set cel = Union(cel, r)
If cel Is Nothing Then
Gary''s Student - gsnu200909
...Downloading stock prices automatically
How can I download stock prices automatically (say from Yahoo) into Excel
Select a cell where you want the table to start and then
Data|Import external data|New web query.
Paste the address of the Yahoo site into the window that's appeared and
Select the table you want to import and click Import.
Back on the worksheet right-click the table to set up the refresh frequency.
> How can I download stock prices automatically (say from Yahoo) into Excel
> 2002? Thanks.
...Fixed Asset transfer for a New Company
Is selling the Fixed Asset to the new company the best option to make a
transfer to a new company?
Can you give us a little more detail on what you are needing to accomplish?
If two companies are different legal entities there are all kinds of other
rules on 'transferring' assets. Is this just a new database or are you doing
an intercompany transaction? We can help, we just need a little more
"FA user" wrote:
> Is selling the Fixed Asset to the new company the best option to make a
> transfer to a new company?
...Format cell will not appear
I have a budget spreadsheet in E2k that I need to update. I can change al
the numbers and formlas but if I select Format Cells the dialog box will not
appear. I cannot find a single cell anyware in that workbook that works. The
budget sheet has some grey area to the righ. I tweaked it last year and I
can't remember what I did. Please help
Maybe the sheet is protected. Tools, Protection. If you see Unprotect
sheet" it was.
mvpearl omitthisword at verizon period net
"Tim Marciniak" <t...Condtional Formatting
Is there a way to set a label to display differing sets of text based on a
merge field value? Or a way to set the visible property of a label to false?
I suppose I could set a whole mess of merge fields and use those as my
labels but then that becomes a heck of alot of data for a user to fill
in/understand how to fill in correctly if they want to create a datasource
I'm using Publisher 2003.
...Which Transfer In?
A question for you all, which our support company can not answer...
If branch 5 receives a transfer from another branch of 64 of item 68209, but
the paperwork is missing, and there is no label on the box to say which
branch it has come from, is there a quick way of finding the correct
Transfer in document?
We have tried the Item movement and item movement history reports, but the
answer is NO!.
Basically, look through all of the transfers in, until you find the correct
I'm, after a report or a solution which does not involve Store
Administrator, as it should be an easy to us...