I'm making custom receipt template. I use different headers
("OverlayFirstPage" and "OverlayOnlyPage" differs from "OverlayMiddlePage"
and "OverlayLastPage"). Problem is that these headers are of quite different
size and there is a lot of space between header and document section on
middle and last page. Can I define different <TOP> parameters in <DOCUMENT>
depending on what page it is (or what overlay uses)?
I got it myself, using page number:
<CONDITION>\p=1 | \p=\t</CONDITION>
<T...Can I Edit the From Field?
I now receive my voice mail in the forum of email messages with attached wav
files. The "from" field is the generic address of the voice mail system. I
would like to be able to edit the from field and change it to the name of the
person who left the voice mail, so that I can find it later if I need to.
If the answer is not possible, I'd like to hear suggestions about the best
way to handle this. I know there are other ways I could handle this such as
assigning the email to a contact, The issue though is that I would like
whatever method I use to work whether I keep the...Writting ACCESS table to Excel
I am trying to write to Excel and have this code.. which fails at line Dim
Rst1 As New ADODB.Recordset, saying "User definded type not defined" . Also
after witrring I want to rename my template
Dim DXrptPath As String
DXrptPath = "r:\temp\Resultsreportingworksheet.xls"
'***Opening Report Template
Dim myDB As Database
Set myDB = CurrentDb
Set ExcelWindow = CreateObject("excel.application")
ExcelWindow.Visible = True
Dim DXrpt As Workbook
Set DXrpt = ActiveWorkbook
DXrpt.A...unique key in an excel 2007 table
In an excel 2007 table, I want that one column has unique values. I
want to check this at input time, with a data validation function.
Say that I have Table1
where a and b are column names. I don't want another "qw" or "zx"
value in column a.
I have tried with Data/Data Validation, with a formula like
but the countif function does not seem to recognaize structured
references in data validation formulas.
How could I get around this problem?
&qu...count different instances in two columns
I haven't been able to solve this...
I have two columns in the same sheet. I would like to extract (in another
sheet) all the unique elements of each column and count how many each data
is repeated. Any element can appear in both column. An example would be:
column 1 column 2
the result would be
Sorry for my english and thanks to whoever can help me with this.
Bo...Exporting Date Modified Field
I'm trying to export Outlook 2003 Contacts to a .csv file. I want to include
the MODIFIED field, which is a data field automatically stamped by Outlook.
(It shows up on the FREQUENTLY USED FIELDS tab when displaying ALL FIELDS on
It doesn't come up as one of the mapped field choices when the wizard asks
you to map fields to export.
Anyone know how to export this field?
If not, anyone know how to filter an export to include only those contacts
whose MODIFIED field falls within a certain date range?
Right now you can use our preview edition of ContactGen...Calculating Days in Excel 97
Can someone tell me how to project a date in the future
given a specific number of days? eg: Today is July 29,
2003, what date will it be 199 days from today's date.
Granite Shoals, TX
"dluhyt" <email@example.com> wrote in message
> Can someone tell me how to project a date in the future
> given a specific number of days? eg: Today is July 29,
> 2003, what date will it be 199 days from today's date.
With 29-Jul-0...Return comination of Current record and next record fields
I have a table:
Run_point_List_ID 1 (Autonumber)
How can I get the query to return the first two fields from the 1st record
and the second two fields from the 2nd record, and so on... like the example
From Record 1 From Record 1 From Record 2 From Record 2
From Record 2 From Record 2 From Record 3 From Record 3
From Record 3 From Record 3 From Record 4 From Record 4
From Record 4 From Record 4 From Record 5 From Record 5
From Record 5 From Record 5 From Record 6 From Record 6
...Date Difference 02-24-10
Good Morning. I am trying to figure out how to calculate the number of days
between two dates. I have a table callled events. That table has event
date, event type, event outcome.
For example a defendant will have an Advisement Date (AA as stored in the
table) and say a Preliminary Hearing date (PH). When i enter information I
will enter the date, event type and the event outcome will be (PD for
Pending, CN for Continued, or CP for completed). For example Case Number
10-12345 will have an AA on 01/05/10 which is Completed and a Preliminary
Hearing on 02/05/10 which was C...Pivot Table
I have a Pivot table with some numbers in it. Is there a way to
replace the numbers with a text?
For example: replace all numbers >1 with "yes" . Is this possible? If
not whats the best way to achieve this?
Only by changing your data source. Eg.
Dim rCell As Range
For Each rCell In Range("DataSource").Columns _
If rCell > 1 Then rCell = "yes"
"vinstream" <firstname.lastname@example.org> wrote in mes...Different Account Balance
I have a different account balance when I view all transactions vs.
view transactions by past 12 months. My account balance from balance
account is also different from my account balance vs. all transactions.
I have read the KB article at:
I exported then deleted all my existing transactios and re-imported
them (method 3), but all my account balances are wrong. I don't want
to use this file since it is almost twice the size of my original file.
I know there are 7 transactions that are wrong (the remaining
t...Pivot Table Solve Order
I'm trying to change the solve order of formulas I've created inside a pivot
table. However, when I go to:
Formulas -> Solve Order
in the pivot menu, the
Calculated Item Solve Order
dialog box is empty.
I've used the
Formulas -> List Order
to produce the list. So, I can see the current order. But, I'd like to
change the order. How is this accomplished? Thanks!!!
The Solve Order refers to Calculated Items, not Calculated Fields.
I suspect that you have Calculated Fields in your PT, but you do not have
any Calculated Items
-- ...save a document where fields be used but not altered
I have careated a documents that need to be saved but not as read only. The
feilds are needed, such as a form. How can I save this material so the
format remains but text box alterations and movement areno longer on the page.
There isn't a surefire way of locking the form, but you might want to try
this as a workaround. Once the form is complete, group all elements
together. Then reduce the viewing size down so the entire pasteboard area is
visible on your monitor. Draw a single line from the top of the pasteboard
area to the bottom and then a second line from side to side. Move t...re:Time Differences
This is a multi-part message in MIME format.
I have a spread sheet where I am looking at what we call turnover times =
and case length and I need to have difference in times sometimes be a =
sometimesnegative and a positive but it won't allow a negative number to =
display as hours and minutes any th...calculating in a changing range
I am trying to find a maximum value in a range that will be changing (in
starting position, and length). Here is an example, this is cells A1 to
I want to find the max between zero points (In this case, there would
be one max, and it would be 4). The number of zero points and the
number of cells between them will change. Anyone have some idea of how
to go about this, or anything to even get me started?
gkaste's Profile: http://www.excelforum.com/member.php?...VB code based on different forms loaded
I have a Database that i use for taking ordes, the form is called
I have now created a very simply vertions of frmOrder called
frmOrderTill that is will be used in our shop ( does same stuff but
Hoever some of the subform replating to frmOrder and now frmORderTill,
have code in it that refers back to frmOrder, is there a way to write
the code so it can use either frmOrder or frmOrderTill depending on
what form is open
Example of code used
i need a way t...Insert Into query statement error between tables within same DB,Up
Use following in a query to run, get syntax error for Insert Into statement:
INSERT INTO Kopia av Kontakter [(Efternamn[, Förnamn[, Företag[, Kategori[,
Språk[, E-postadress[, Telefon-arbete[, Telefon2[, Faxnummer[, Mobiltelefon[,
Telefon-hem[, Godk epost reklam]]]]]]]]]]])]
...How do I calculate total of months that have passed?
I want to know how many months have passed since a certain date. There is a
start date and an end date. I want to calculate how many months are in that
period. For instance if the start date is 05-01-01 and the end date is
05-03-01 two months have passed.
You can use =DATEDIF(A1,B1,"m")
A1 = 05-01-01
B1 = 05-03-01
"m" = month ("d" for days, "y" for Years, "ym" for Months Excluding Year,
"yd" for Days Excluding Years and "md" for Days Excluding Months And Years)
akhileshdalia<at&g...Item Description field in Requisition Management
I would like the Item Description field added to the Requisition Management
module for the business portal. I asked for a customization and was told by
Microsoft Support that it was not possible.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.co...Address State Field
I have a client that has a need to make the address state field a drop down
so that they can run reports off of it. Is there any way to do this? The
only way I thought of was by creating a new field with a drop down.
Any ideas would be appreciated.....
Tara Sifuentes, CCDA, CCNA
We always create a new drop down field for Stateorprovince and we write a
script in "onchange" on the properties --> Event of this new field. The code
update the original field and you don't need to change all of your reports.
the only thing is you need to keep the original f...Web Query How do I change columns of the MSN Stock quotes table?
I want to add the opening price to the web query MSN Moneycentral Investor
Stock Quotes. How can I adjust which columns are included in this table
If you are talking about the MSN Money Stock Quotes that appears on the data
menu, if you select that option, then Help, you'll get to a web page that has
another link entitled MSN Stock Quote Function Reference (or something
similar). It lists the information that's available and explains the syntax of
On Wed, 20 Oct 2004 06:13:07 -0700, "BKM24" <BKM24@discussions.microsoft.com>
>I want to add the...turn automatic calculation off forever!
I want to turn off automatic calculation for all new Excel sessions I
When I change the settings and close Exeel the changes are lost in a
I tried to save a sheet called book1.xls in my xlstartup folder with
calculations set to manual. Close Excel and open a new Excel sesson
remembers the change.
When I open one more Excel sesson it says that the file book1.xls is
locked for editing.
I am using Excel 2003 and are sometimes using Excel 2000 as well.
I'd open excel
and hide book1.xls (window|hide)
Then close excel and answer yes to th...using the same CRM connection to add tables
I'm creating reports in CRM using the microsoft CRM connection to get the
data. In a previous workout I added some sights and want now to add some
Now the problem: How can add tables or sights using the same connection I
used in previous workout. If I add new tables, sights a new connection
(*SSO*) is added and this is more than worst to the report speed.
Thanks for your help
...CRM+GP HOW TO LOCK A FIELD
is there a way to lock a field so a salesman cant edit and overide a parts
In Great Plains, a customisation like this can be easily achieved with a
variety of tools. You can use Modifier, VBA, Dexterity or each the Field
Level Security module.
David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "A...Customizing Pivot Table Totals
When i set the options to Total a row I get totals for all 10 of my data
fields, which would be fine, except 3 of these data fields should not be
included in the display of totals. Is there some settings that I can
configure so that certain data fields are not inlcluded in the totals? Below
is an example
City Project Type Data Jan Feb
1 a Houses 4 5
Cost 3 6
People 12 3
b Houses 5 11
Cost 4 10