Data Validation Boxes #2
I used the list option under Data Validation and can only see the
dropdown boxes, when I click on the cells.
How can I make the dropdown boxes visible all the time.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
The Data Validation dropdown arrow is only visible when the cell is
active. You could use fill colour or a comment to indicate that the cell
has data validation.
> I used the list option under Data Validation and can only see the
> dr...HELP!!! Need to add a Local Field from Modifier to a Report!!!!!!
I added two fields to a window. Now I need those fields in my report. How
do I add these fields if they are not Global fields??
Where are the values for these two fields stored when the window is saved?
All you need to do is create blank calculated fields of the correct data
types and then you can use VBA to read the data back and populate the
calculated fields you have added to the report layout.
I have a VBA example like this using the DUOS (Dynamics User Object Store)
to store the added fields. If you are interested, get your partner to email
me ...Protect Form issue
I have templates created for a user workgroup that are protected without
passwords. Occasionally they have to edit the form itself, and my habit has
been to include a protect form icon in the template on the toolbar so they
can "unlock" the form, make their edits, protect it back, and then fill in
All has been working until very recently. Now the icon is nonfunctional
(grayed out). They can still unprotect the form from Tools menu, but the
icon was easy and they'd like to continue using it. I can't seem to get
around it at all.
Does anyone kn...combo
have placed a subform, which gives the Price. It is based on the Query. I
have given a criteria in the query like [forms]![mainform]![productid].
So, when I select a product from a combo box, on the main form, I should see
the price on the subform. The problem, is it does not refresh. It still shows
the same price for the earlier product. But, when I move, it gets refreshed.
Can I have a code , so that I should see the price as soon as I select the
product from the combo box .
On the After Update event of your combo box put the following:
I have been using forms I created for contacts.
Outlook now won't recognize my forms and has reverted back to its own form,
so I can't see a lot of the data I created for contacts, unless I create
It will recognize the forms for new contacts.
When I try to republish the forms, I get a message about the object can not
be found do to a MAPI error.
How can I apply the custom forms I have to the existing data??
The first step is to tell us what version of Outlook, where the forms are
published, and exactly what happens when you try to open an item using one
of these for...sum combo box based on other combo box
Hi can anyone help
i have two combo box which are Customer Number and Period Posting Date
coming from the same table,
what i'm after is after combo box which will give me all value for each
Customer in a specific posting Date month
if some select Customer Number 0001 in combo box 1
and then select 2009/07 in Combo box 2
i want combo 3 or a text box to sum the values in thee amount column and
display the total in combo 3 or they text box
thanks in advance
If you don't have to store the total (and you shouldn't store calculated
results), a s...do not duplicate date values in form
I have a table called weeklysummary. It contains a field called EmployeeID
and WeekEnding. WeekEnding is a date field. I want to prevent a user from
entering a duplicate date based on Employee. There will be duplicate dates in
the table, one for each Salesperson but again, I must prevent duplicate dates
I found this:
Store the identifier in two fields: one for the main number and one for the
suffix. In table design view, click on View > Indexes to open the Indexes
window. Create a multi-field index that is unique on the two fields taken
together. To do this, assign ...Form/Procedure question
I am new to access and am trying to create a simple application that will
allow a user to type in two store numbers and then I will search the database
for the stores and return some correlation values. (I have a script written
in sql to find the correlation) but am going to have to convert it to access.
Can this be done, any suggestions on where to start. Do I create a form and
then somehow link the procedure to it?
Can this even be done and is this the best way to do it?
You may not need a procedure to do it, depending on what it is you're
actually doing it could be ma...I get a "MS LAPD Directory" dialogue box asking for a password.
What do I do? My end goal is to send fliers in the body of an email - not an
attachment, and I was told my Outlook is not set up yet, though I can get my
sammyj <email@example.com> wrote:
> What do I do? My end goal is to send fliers in the body of an email -
> not an attachment, and I was told my Outlook is not set up yet,
> though I can get my hotmail emails.
If you don't need the LDAP directory, remove it in Control Panel's Mail
applet with E-mail Accounts>View or change existing directories or address
Brian T...advance filter excluding record
I have a speadsheet like following:
Cust Name, Date
My Name1 Monday
My Name2 Sunday
My Name3 Friday
I wanted to use Advance filter out which date equals Sunday.
How I should write my criteria?
Thanks millions in advance,
If it is the Word Sunday and Excel is reading it as text, use this as your
Date (for the Heading)
<>Sunday (for the criteria
If the date is being read as a date, you can use this as your criteria:
This example assumes the first date is in B6. When using a formula, there is
no Heading - you simply select the blank cell a...Modify Recorded Macro
I recorded the following macro, which basically Merges 2 cells and Alignes
the text to the left.
However, when recording it always records the cell
How can i adapt the cell address to something like:
ActiveCell - ActiveCell.Offset(0,1).select instead of the particular cell
I need to run this macro about 1000 times
' MergeCells Macro
.HorizontalAlignment = xlCenter
.Vertic...Bank of America fixes long payee fields!
Saw this in the Quicken group. I think someone here had the same issue.
or for the link wrap challenged
Linux market penetration statistics:
Geeks living at home in parent's basement 99.9999%
...Combo box in Visual Basics
I'm fairly new with Visual Basics.
I'm creating a form and I'd like to add a combo box (drop down Lisyt), and I
can't seem to figure out how to validate the list from there.
Does anyone know how or have a reference to this?
Thank you in advance.
Next time you're in the VBE working on your userform, click on the combobox and
hit F4 (to show its properties).
Then change the style to fmStyleDropDownList--this allows only the items in the
Then you can use the .rowsource property to point at the range that should be
used for validatio...Print Footer with Last Print Date field name
How do you create a Footer to print the Last Printed Date and Last Revised
Date? Its not as obvious in Excel as it is in Word.
this is only possible with VBA inserting this information within an event
> How do you create a Footer to print the Last Printed Date and Last
> Revised Date? Its not as obvious in Excel as it is in Word.
...2nd search box not sort properly after using 1st search box
I have 2 combo boxes on a continuse form. One to search name and Other to
Private Sub cboFind_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Me.OrderBy = ""
Set rs = Me.Recordset.Clone
rs.FindFirst "[Last Name] = '" & Me![cboFind] & "' AND [First Name] = '"
& Me![cboFind].Column(1) & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Me.cboFind.BackColor = -2147483633
Private Sub cboDepartment_AfterUpdate()
...can't record a new macro or insert module in editor
When i try to record a new macro it tells me it is unalbe
to record. When i go into the VB editor and go to the
insert menu all the items are greyed out so I can't
select module and so create a new macor that way. I have
changed the security off from high (tried on both medium
and low). Does anybody know why I can't make new macros?
Unfortunately the "Unable to record" message has several potential causes.
Suggest you wander through these google search results dealing with this
issue. Perhaps something will do the trick.
The Personal.xls file ...Chart sizes with window frame check box frozen in the checked stat
I am running Excel 2000 under Windows XP on my laptop. Under the
Tools:Options menu there is a check box for "Chart sizes with window frame".
It is currently checked. If I uncheck the box the check mark disappears, but
when I click on "OK" nothing changes and the zoom box on the toolbar does not
activate. When I open the Tools:Options menu again the check box is still
checked. It will not turn off. I have tried uninstalling and reinstalling
without effect. I have compared settings with my Excel 2000 installations on
my desktops at home and at work (where thing...Form changes contents on a timer
The code below is for a form that changes contents on a timer. The contents
are received from a series of queries
Is there a way to make it so that if a query has nil results/records that it
automatically skips to the next Case/Query?
Private Sub Form_Activate()
Me.TimerInterval = 5000
Private Sub Form_Load()
Me.Child4.SourceObject = "Query.DisplayOrdersEURGBP"
Me.Label5.Caption = "EURGBP"
Private Sub Form_Timer()
Select Case Me.Child4.SourceObject
Case "Quer...On Click from a List Box
I have an unbound list box on a subform that displays specific records from
my table. Following some advice from here on what I wanted to do which is
Click on a record and have it open up to main form and go to that record. I
am having a little problem. It opens up the main form correctly but it goes
to the first Record, not the one I clicked.
I have the following code on my Open Record button on my subform:
On Error GoTo Err_cmd_open_record_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmSENESarLog2008"
stLinkCriteria = "[...customizing printing from lead form
We have added a custom button on the lead page (on the
left), which then displays a custom aspx page in the right
hand frame (where the tabs usually are).
We want to be able to somehow modify CRM to print this
aspx page instead of printing the default page tabs when
we click the print button.
Does anyone know of any methods to do this? Has anyone
development? I'm having a hard time finding any
information on how to do this.
...Help: New dialog box when opening Word or Outlook
Starting in the last week or so I get the following message when
opening Word or Outlook (which I have set to use Word as my mail
The document contains macros. Macro language support is currently
disabled. Features requiring VBA are not available. Would you like
to open this document read-only?
OK Cancel Help
I am not opening a fil...Creating entity record in inactive view using crm 3.0 sdk
I want to add entity record in inactive view by using crm 3.0 sdk.Already i
created a record by using sdk but it was added in' active' view records,but
my requirement is to add record directly in 'inactive' view records.
Can anybody suggest me how to solve this problem ?
Pls provide code samples if anybody have.
Waiting for replies.
you will have to create the record (which you have already done), and then
set it's state/status as a separate operation.
"prabhakar.penugonda" <prabhakarpenugonda@discussio...Using the combo box from the forms toobar
When using the combo box from the forms toolbar I get text that is a specified size. I can increase the size of the drop down arrow and box but I can't change the text size. How do I change the text size?
> When using the combo box from the forms toolbar I get text that is a specified size. I can increase the size of the drop down
arrow and box but I can't change the text size. How do I change the text size?
You can't. The combo box from the forms toolbar is a fixed font. If you need a different font, you'll have to use the combobox
from the control toolbox.
Re...record count issue
I use recordcount to check my DAO.recordset is empty or not.
The recordcount returns 1 when the resordset is empty.
Are there any work around for this?
Your help is great appreciated,
"iccsi" <firstname.lastname@example.org> wrote in message
>I use recordcount to check my DAO.recordset is empty or not.
> The recordcount returns 1 when the resordset is empty.
> Are there any work around for this?
I've never heard of such a thing, and doubt your results. Please post your
...Locking combo boxes
i have a worksheet with several combo boxes an drop down=20
lists. I have succesfully managed to lock and unlock=20
the "normal" cells that i want, but it is impossible for=20
me to unlock the combo boxes and drop down lists. Does=20
anyone know how i can do that? I have tried to=20
set "Locked" to "False" under Properties, but it doesn't=20
help. (Sorry for my english, i'm norwegian)
Is the linked cell locked? If yes, try unlocking that. (Maybe hide the
row/column it's in to keep it safe.)
K�re Brynildsenq wrote: