Custom Fit to Page
Does anyone know how to fit multiple pages to page? What I mean by this
is I have a worksheet that is 707 rows and I've set the page breaks to
break the worksheet into 8 pages. The pages are set to letter size.
However, some pages have empty space at the top and bottom, and other
pages fill out the page completely. This is because each page has a
different amount of rows in it obviously. I want to make it so each
page is "fit to page" where there is no empty space at the top and
bottom, regardless of how many rows each page has. Hopefully what I'm
saying makes sense. ...rep commission payment
I would like to be able to pay the reps without reentering the info as bills
I'd have to look but I seem to recall I wrote something that automatically
generated payables documents when you ran the transfer commissions. It
would generate a document per commission record so if you ran your
commissions in summary it would make one payables invoices (or credit memo
if negative commissions). Or if in detail, then one document per commission
Email me if you are interested in details. I'd have to see where it might
be and if I have a demo or not if you are interested. If ...Custom Serialization
Could anyone tell me if this is possible please?
I have a class which looks like the following
public mblnUpdateMyProp1 as boolean
public mintMyProp1 as int16
public mblnUpdateMyProp2 as boolean
public mintMyProp2 as int16
This serializes to
Now I know you can control serialization with attributes such
XmlElementAtt...Adding custom fields to dynamically created controls.
I created a custom Outlook (2003) form that imports data from Access to
populate user defined fields and create additional controls based on
the number of records in an Access query. Everything works fine except
the data the user enters for the dynamically created controls don't
hold their value when the form is sent. I am quessing that is because
there is no user defined fields bound to them. (how do I do this) I
have been looking on the net but cannot find anything close enough. Any
help (examples) would be appreciated.
Look at http://www.outlookcode.com/d/formcontrols.htm, lots of inf...Forcing users to use a custom Contacts form OR removing Contacts
Using Exchange 5.5 and Outlook 2000
Is it possible to set it so all users use a cusom contacts form for new
items in their "Outlook Today" folders?
Or better still, is there a way to remove the Contacts folder, or make
it point to a folder in the public folders tree?
...Help needed with customer address entity
Our company sends out a great variety of documents to clients, each of
whom can have multiple addresses. To complicate matters, clients
frequently request different document types to be mailed to different
addresses. For example, John Doe may want accounting documents sent to
his "Home" address, tax documents sent to his "Work" address, quarterly
letter documents sent to his "Vacation" address, etc. The easiest way
to track this would be to relate my new custom entity 'Documents'
to the customer address entity and the contact entity, then customize a
Just started looking at MS CRM. We have a client who has started using it
and want us to do major customizations. I have already added a few custom
forms (in the form of external asp.net applications).
I want some more info (I have searched this NG and didn't find and
conclusive answers) what I want to know is:
1. Can I add a new entity like the built-in entities and then link
(mapping?) the new entity to a built-in entity? Basically what I want is to
add a new table in the database and then have the ability to create objects
accessible through the proxy dll. If it is not possi...how do I customize my menubar using a2007?
I've move to A2007. The menubar I created in A2003 is still there but how do
I now customize it?
I believe that you can only customize it in Access 2003, since 2007 doesn't
use menubars anymore.
Arvin Meyer, MCP, MVP
"Jesper F" <firstname.lastname@example.org> wrote in message
> I've move to A2007. The menubar I created in A2003 is still there but how
> do I now customize it?
>I believe tha...Error when trying to customize attributes
Recently we had a system failure and ended up restoring our CRM 3.0 to a
newer version of 3.0. Everything seemed fine for a while until we attempted
to do some additional customizing with the attributes. This is the error we
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set
to an instance of an obje...Export directory entry type mailboxes as type custom recipients (remote)
As a prelude to the final, way overdue, extinguishing Exchange 5.5,
want I want to do is export from the GAL all the mailboxes in the
other sites, but convert them in a single operation to type custom
At which point I will remove our x.400 connector, then import all of
the custom recipients back into our own administrative group.
I am aware that no further directory synchonization will occur. I am
aware that there are solutions for sychronizing between active
directories (MIIS, federations, LDAP address books, etc.), but I have
no cooperation from any other responsi...Quote for Customer Report Problem
I create a printable quote form using Crystal Reports base don Michael
Yourshaw's method (send GUID to aspx page and redirect to the report).
But I have a problem. When I press the 'open quote in Crystal' button on the
quote form, I have to enter my username and password again to be able to see
How can I solve this?
...customizations grayed out on the IE toolbar context menu
from some reason, i have many items in the context menu of the toolbar area
of IE grayed out.
status bar, favorites bar,command bar, etc...
even the items in the "customize" submenu are grayed
here's a screenshot:
please tell me how to fix it.
We can't do squat to help you until you state your IE version and full
Windows version (e.g., WinXP SP3; WinXP 64-bit SP2; Vista SP1; Vista 64-bit
SP2; Win7; Win7 64-bit).
What anti-virus application or security suite is installed and is your
subscription cur...Exporting Unpublished Customizations
We started development of some changes on Production Server A, and
we'd like to move them to Test Server B so we can test them before we
publish them in production.
When I export the entities from server A, and import & publish them on
server B, only the already-published entities are available on server
B. Editing an entity does not show any of the unpublished changes.
Is there a way to move the unpublished changes, or do we need to
publish what we've got and hope for the best? We're using CRM 3.0,
Hi Travis; there's no opti...Calculating time and pay in excel
Hi, i'm trying to make a spreadsheet that can calculate pay per minute
depending on an average length of time worked. Its driving me crazy and
any help would be greatly appreciated! Coloumn A is length of time, at
the bottom is a total time, next to that is an average length of time
worked and this is then multiplied by the amount appropriate for that
average. What would be the best way to work all of this out
Many thanks for any help you can give
wobbleman's Profile: http://www.e...Outlook 2000 shuts down when I click on customize
When I click on customize under Tools my outlook 2000 closes. Does anyone
have reason why this happens and how to stop this action.
"Ivan T" <email@example.com> wrote in message
> When I click on customize under Tools my outlook 2000 closes. Does anyone
> have reason why this happens and how to stop this action.
...Publish Customizations Error
I added some objects to the Scheme Manager and when I assign them to
Contacts and try to publish the changes, I get the following error:
<Server01>: ***Error*** Failed to download XSL template files from Web
Then I check the Event Viewer and find the following error under
Event Type: Error
Event Source: DMSNAPIN
Event Category: None
Event ID: 0
Web exception Status = ProtocolError Error de HttpGet Unauthorized : The
remote server returned an error: (401) Unauthorized....viewing what each button of a custom toolbar does
I'm reverse engineering a database that I've inherited. There's a couple of
custom toolbars, and they open various forms, basically acting as a
rudimentary menu system. What I'm trying to do is view whatever action is
assigned to each button. Have gone round and round with Tools, Customize,
Toolbars, the command tab, etc.
Am sure I'm overlooking something. Can anyone help me here?
click customize on the menu bar
select the toolbar and the button
right click the button and on the pop up menu select properties
on the propertie...Spell check & custom dictionaries
Is there a way of specifying which custom dictionary is used by Excel's
spelling checker for a particular workbook? and getting Excel to ignore all
custom dictionaries when checking spelling on all other workbooks?
Any guidance would be appreciated
...Custom recipients in 2k3
I need to make custom recipients in Exchange 2k3 that allow me to send mail
from a different domain.
My email addy is really
but when I reply to certain people, i need it to say
Customer Service (Drew) Drew@domain2.com
instead of Drew Drew@domain1.com
I used to be able to do this on exchange 5.5 very easily but i cant figure
out how to do it on 2k3, does anyone have any idea what im talking about?
or create another account with the other SMTP address as the default
reply, give yourself SEND AS permissions to i...custom return button
Is there a way to create a custom button to put the return key on the first
screen? There is no internal command for this.
...Customizing Tables and Forms?
I need Help.
I’m trying to create an incident database. The table is called “Incident Log”.
I need the four fields of the table setup like this:
Incident # Patient # Patient # (2) Patient # (3) Patient # (4)
0003-07 0002 0003 0004 0005
0007-07 0008 0009 0010 0011
…and so on
The “Incident #” needs to be generated automatically for every new record
entered and consists of a four digit number ...Custom Sorting (Stumped)
I have 2 colums of data. I want to sort colum B by colum C. Th
problem is my range is about 70 rows, and in that colum there are 3
consecutive rows in the middle that I don't want sorted. I know
could go the long way and do 2 seperate sorts, but I want the sorte
data to be applicable above and below the range I don't want sorted.
Is there a way to do this? Any help would be great.
Message posted from http://www.ExcelForum.com
Maybe pick up those 30 rows and paste them into a different worksheet.
Do your sort (delete those 30 rows if you need to)
Insert the original ...custom trendline confusion
I would like to generate a custom trendline on a graph, but I cannot find
any instructions for how to get the proper syntax, nor can I find what
functionality is possible with this feature.
All of my attempts to make a custom trendline have resulted in XL (XL 2000)
producing a simple linear fit trendline. Thanks in advance, Jay
When you select Chart|Add Trendline, you are given a choice of 6 basic
types of trendlines, most with additional options. Select something
other than the default "Linear", before you press OK.
> I would like to generate a cus...How to custom the scroll bar?
I realized my scroll bar from CWnd, but i found it's difficult to disable
the original scroll bars attached the specified window with style WS_VSCROLL
or WS_HSCROLL, and the original scroll bars always be shown. But when I try
to create the host window without style WS_VSCROLL and WS_HSCROLL, the
scroll infomation will be not got properly.
Hello - I have a large table that I am trying to create some custom
views for. However, when I go to View, Custom Views........the Custom
Views option is grayed out.
I read that you cannot use Custom views for an "excel list", but I
have converted the list back to a normal range, so I don't think that
is the problem.
Does anyone know what other reasons may exist, as to why I am unable
to select custom views?
Thanks for any suggestions.
Perhaps you have more than one sheet selected?
Gord Dibben MS Excel MVP
On Fri, 5 Sep 2008 08:19:17 -0700 (PDT), Mike C <firstname.lastname@example.org...