Customization: disabling built in features
I would like to disable/remove some of the sections on the left hand
side of CRM. For example, on the home screen I would like to remove
the Invoices section since we don't use these. And on the Account
level I would like to remove the Notes and Contracts sections for the
Is this possible?
...Lookup Function in user form
I have a combo box (cboitem1) and a text box (txtprice1). I am using the code
below to have txtprice1 fill with the corresponding price the worksheet:
Private Sub Cboitem1_Change()
If cboItem1 <> "" Then
txtprice1.Value = Excel.WorksheetFunction.VLookup(cboItem1.Value,
Sheets("Pizzas").Range("A1:B65536"), 2, False)
It works perfectly when you enter an existing value in cboitem1. However if
'the user' accidently types a letter that is not the first letter of one of
the existing items VB debugging pops up with error &qu...Which Controls to Build a Parent/Child Web Form
I'm quite new to asp.net, but know exactly how to do this using classic ASP,
but would like some pointers for aspnet2.
I've got data being returned from an SP which looks like this:
I want to display the data like this
A - This is the header record
B - Header 2
In classic ASP I'd write out my header row html when HeaderItem changes
value and then write the Child Rows.
As I've on...addressing envelope from data input form
I don't know where to start to try this.
I have the following fields that make up the entire address:
Fname2 Lname 2
City, State Zip
Is there any way to "push a button" on a form and have it print an envelope
for that record?
Thanks in advance for any help.
Posted via a free Usenet account from http://www.teranews.com
Have you thought of using an MS template as a starting point?
Dave Eliot wrote:
>I don't know where to start to try this.
>I have the following fields ...Viewing xml created in .Net in a ASP form VB6
I have been trying to create an xml document in VB.Net for displaying
on an existing page written in ASP.
im having a type mismatch error in my code. When i view my XML i have
the following included in the <binary> node.
dt:dt="bin.base64">DATA HERE </Binary
My issue is how do i set the datatype of the the node using dotnet so
that i can replicate the same node structure and use my existing ASP
thanks in advance
...Creating a form or template
We scanned in an image of a post it note that has graphics
on it. It is a jpg file. Can we somehow make this jpg
file a form or template in Outlook? Ideally, we want to
pull up a form that looks like the image of a post it note
with the graphics in tact and be able to compose a message
on the email post it note. How do you accomplish this?
...Filtering data by custom fields in pivot tables from Visual Report
I have recently upgraded to MS Project 2007 and like the visual reporting
feature, except I really need to filter and group the resulting pivot table
in Excel by custom fields. For example, for task usage, I cannot filter my
pivot table to show only the tasks that have costs > $0, thus my table ends
up showing too many lines and a lot of 0's. I would also like to group by
department/ function which I put in a custom text field. How do I do this?
I saw related posts about saving the file as an Access database and then
creating the pivot table by connecting to the datab...Keeping Custom Properties When Forwarding or Replying to a Message #2
We have emails saved on the file system, that is kept track of by
another program. These emails have custom properties attached to
them. There is no custom form, just custom properties. These fields
were originally added using objPost.UserProperties.Add. We need it
so that when someone opens up one of these emails through the file
system, and then replies or fowards the message, these custom
properties are kept in the reply. This is so the external program can
track these emails. Is there a way this can be done? We could have
these emails opened up using an Outlook command line that i...Adding BMPs to a form
I use Access 2003. I have a table set up with a field for pictures, this
table sits behind a form to add BMPs, which display on the form and print on
In the past, when I have had to reinstall Access for any reason, the
pictures instead of displaying fully in the form, only show as thumbnails
with the file name. I have in the past resoved this by removing Microsoft
Picture manager from MS Office. I don't know how I figured that out or why it
works but it does. However, I had to reinstall Office yesterday, removed MS
Pictrue Manager as usual and it's NOT working ...Removing gray shading in protected forms (drop down box)
I am creating some contract templates for my company's sales force using
Word 2003. I am using the forms toolbar to insert checkboxes and drop down
boxes from which to select deliverable specifications. The problem is that
when a user selects an option from the drop down box, the gray shading
remains. I know the sales teams HATE the gray shading because they don't
think it looks very good when sending to customers. Is there a way to
disable the shading when an option is selected? Thanks.
You can remove form field shading altogether using the corresponding b...Combo values from query based on form fields
I am setting the values for a combo box in a form(s) via a query that
'filters' the results with criteria based upon the values of other fields on
the form. The combo is a field that is bound. However, this is giving all
kinds of problems ranging from Access completely crashing to being asked for
the parameter values of those criteria fields when closing the form. I have
tried making the combo an unbound field and then setting the value of the
bound field to that unbound field after update, but that still leads to the
same issues. How can I do this?
As example - I have a form w...How do you define a custom paper size in Excel? (i.e. 11x17)
How do you define a custom paper size in Excel? (i.e. 11x17)
Excel doesn't provide for custom paper sizes, but most any size appropriate
for Excel output is already provided _if_ the installed print driver supports
it. Go to File>Page SetUp--Page and open the list of sizes. If your installed
driver supports 11x17 it will be in the list (although it may be listed as
'Ledger' rather than by dimensions).
"Marcin Rembisz" wrote:
> How do you define a custom paper size in Excel? (i.e. 11x17)
...ActiveX vs Forms
I am trying to embed some option buttons on a worksheet. I want to
have two sets of buttons which are mutually exclusive, say A-D and
then 1-3. I want to start with 1-3 hidden and if the user chooses
option D from the first set then 1-3 will be revealed. I did this fine
with the activex option buttons and VBA, however, it is not
recognizing A-D and 1-3 as separate groups. Therefore, as soon as the
user select 1,2 or 3, it will uncheck D and therefore rehide the
remaining numbered boxes. I grouped and named each set of buttons
together, but that did not work. If I try to use a group...Customized Task Views Have Disappeared (Take 2)
I was having an issue similar to this original post and followed the
given. It worked, but as I have worked with it I have found that it will
restore my customized Task views but not my customized Contact views. I can
change some of the Send and Receive setting and it will restore the Contact
views but not Task views. Somehow I am searching for a way to restore both
Task and Contact views. Any ideas?
Tia, Education and Documentation Specialist
Sorry, i posted this in the wrong discussion group. I have posted this
correctly and my question has been answered.
...Refresh Results In A Second Subform In A Form
This could be a tricky one.
What I've done is created a Form named ACCOUNTS SELECT which has a control
being a Comb Box named 'PICK RESNAME' and an embedded subform which returns
all the records according to the particular data from the 'PICK RESNAME'
Thats all fine and well !
But what I need is to pick specific records and to store them in a let's say
temporary Table which I will print out via a Report. For this temporary
table, I have created in the Form ACCOUNTS SELECT another Subform which I
hoped will view all the selections I have made...Continuous Form, Window Top Record Ordinal
On continuous view forms, there should be a form property that has the
recordset ordinal of the top-most record currently displayed in the form’s
window. For example, if a recordset contains 100 records and the
CurrentRecord is 5 and the user scrolls down until the CurrentRecord
disappears off the top of the screen, what is the recordset ordinal for the
record that is now at the top of the window? Left clicking on the scrollbar
slider will display “Record: x of y”, but there should be a property that
contains the value of x for code purposes. Perhaps call it
“WindowTopRecord...Extra pages in form printing
I have a form that exceeds a single printed page. When it is printed extra
pages are produced. The extra pages occur after the first printed page but
before the rest of the page of the form is printed and another extra page
after the rest of the page is printed. The extra pages contain the same
background used in the form. In design view I've made sure to shorten up the
background to be even with the footer but it doesn't seem to help. Any
suggestion on how to get rid of the extra pages in my printout?
I still do not understand why people print forms. For...Printing Form 1096
This function should be included in the software!
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.
T...Creating Custom Dialog Boxex (Popup)
I am trying to create a custom dialog box that will allow me to have the
user clarify an entry when a checkbox is checked. I want them to be able to
select something from a list that I have created. I have created the popup
in Excel but cannot find out how to call the popup into the display when the
checkbox is checked. Can anyone help me please?
Is this a checkbox on the worksheet?
If yes, then if it's a checkbox from the Forms toolbar, assign this macro to the
Dim myCBX As CheckBox
Set myCBX = ActiveSheet.CheckBoxes(Appli...Slow Sales Order form
Several weeks ago, we successfully transferred our database from SQL Server
2000 to 2005. Below are our steps in transferring the database from 2000 to
a) Backuped our SQL Server 2000 database
b) Created an empty database in SQL Server 2005
c) Restored our SQL Server 2000 database to the empty SQL Server 2005
At first, after the transfer, all functions of the application went very
slow. Once I performed the update statistics, the speed of all the
functions went back to normal except for some. This is what is causing me
headaches right now - these functions th...Open one form with different queries
Is it possible to open one form using a different query depending on what
button the user selects. For example:
I should also mention that this form has a subform.
Got it. Below is what I put behind a button on the form for Sort High/Low and
it filters using a query.
Dim stHighLow As String
stHighLow = "SortHighLow"
> Is it possible to open one form using a different query depending on what
> button the user selects. For example...How do i insert symbol in custom footer
I'm working on Excell 2003
I've been asked to create a custom footer in the left column i have to
insert Copyright © 2003.
I can't figure out how on earth to insert the symbol if anybody out ther
knows could you please let me know
one way is to use Insert | Symbol and select the � character and copy it
before you go to View | Header and Footer. Then just use Ctrl-V to paste it
in the Footer
"Den" <Den@discussions.microsoft.com> wrote in message
> I'm wor...blocks of customer database missing
We are running RMS 1.2 and have noticed over the last month a number of
customer missing when looked up they mostly seem to to be recent additions
from the last few months there are some that are one or 2 missing then there
are several with anywhere from 60 -130 in a row missing. there customer
records are just gone the customer numbers are sequential and as a block they
dissapear. the only other thing we have. noticed is several customers
suddonly have duplicate customer numbers when corrected manually it seems a
few days later the duplicate is back. We tried to manually recreate this ...>>>Customer Live Chat Thursday Aug 2nd: Inventory Management <<<
Microsoft Dynamics RMS - Inventory Management
Thursday Aug 2nd 10:00am PST
Have questions about managing your inventory in Microsoft Dynamics RMS? Want
to learn more about item types, tracking inventory, purchasing, or the new
matrix item features? Chat with Retail Management System feature experts
about these or any other inventory issues.
This posting is provided "AS IS" with no warranties, and confers no rights.
...macros on a form
we have a workbook containing serveral worksheets each worksheet contains a
lot of data we have split each worksheet into three pages for print purposes
what we want to do is have a form containing drop down list of names we need
each name to select and run a macro can this be done?
thanks in advance
XL and VBA are capable of a lot. From the generic description of the
problem, I would say yes.
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004