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
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:
[Forms]![frmMainForm]![sfrmSubfo...Send an e-mail to a distribution list when create/delete e-mail ad
Does anybody know if it is possible to send an automatic e-mail to a
distribution list when an e-mail address is created or deleted, using
Exchange 2000 Server
...Report WRITER legends values #2
I need to modify existing modified report. Where can I find values for
Hello Sofiya, Legend fields are placeholders that may contain pretty much
anything, depending of the report you are working with.
For example, on many reports, they are used to display the range values used
when generating the report. (From-To)
One thing you must remember though is that they are always typed as strings
so you need to convert them if you want to do any arithmetic operations with
In conclusion, if you want to evaluate the legend field values for a report,...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 ...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...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 <firstname.lastname@example.org> 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...Finding Highest Value
Is there a formula that will look at a column and find the highest
If the following column is presented, will a formula locate 2025:
Highest value is column = 2025
Hope this isn't confusing.
Message posted from http://www.ExcelForum.com/
"t2true >" <<email@example.com> wrote in message
> Is there a formula that will look at a column and find the highest
> If the following column is presented, will a formula locat...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...Sort chart values
I have tried Jon Peltier's example on linking table to sort data for charting
by using the LARGE function, to no avail. My data is set up different than
his, which I think is throwing me. Can someone help me sort the following
data for the chart, but not in the data itself? Thanks.
bob mary hank jo sam pam
June 0 5 0 6 11 6
11-Jul 1 8 3 11 4 2
15-Jul 6 11 10 12 9
Too hard to read the data set up. (We all need some way of showing formatted
data in newsgroup messages)
Send me a sampl...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...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()
...Listing Credit Memos on Check remittances
Is there a way that you can list credit memos individually on the check
remittance vs. automatically deducting from the invoices? Thanks
Not sure if this will accomplish what you're looking for, but try going to
Setup | Purchasing | Payables and check off the Print Previously Applied
Documents on Remittance.
Microsoft MVP - Great Plains
"LZBDEL" <LZBDEL@discussions.microsoft.com> wrote in message
Is there a way that you can list credit memos individually on the check
remittance vs. automat...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 = "[...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...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...Define whether to use list 1 or 2
I do have three Insert > Name > Define > lists created on one
How to have either one of the 1st two list activated on a cell when the
neighboring cell a value is choosen from the 3rd list list?
If Yes > List A
If No > List B
Is this used with Data|Validation?
If yes, Debra Dalgleish shows how to create dependent lists:
AA Arens wrote:
> I do have three Insert > Name > Define > lists created on one
> How to have eithe...Rotating a Text Box in a Chart
Is there a way to rotate general text on a chart? There
does not appear to be a way to rotate a text box.
If it is in a cell then you should be able to right click
on cell and goto format cell then click on alignment tab
and you can rotate upto 90 degrees up or down.
>Is there a way to rotate general text on a chart? There
>does not appear to be a way to rotate a text box.
There is some basic capability. Double-click the textbox, and in the
resulting Format Text Box dialog box, click the Alignment...How do I print a list of all formulas in a workbook?
I am working on a projection worksheet with multiple pages and formulas
referencing other pages all over the place. It was developed by my
predecessor and I am having trouble following it. If I could print off a
list of all the formulas and where they are pulling the information from, it
would be very helpful.
I'm doing the same job as yours almost..
Tools > Formula Auditing....might be helpful
Or print out each sheet seperatly using: Ctrl + ~ (located below the
Esc key) to display all the formulas in the worksheet.
I have a list of 100 items in Column A containing many duplicates.
In Column B I have category numbers, 1 to 9, thus effectively grouping the
items into 9 categories.
I wish to create a new 9 by 2 table/list that lists the total number of
items in each category.
What is the preferred way of doing this?
Problem solved using a COUNTIF and then a SUMIF.
Thanks for being there anyway....
A wonderful supporting resource.
"KiwiBrian" <firstname.lastname@example.org> wrote in message
>I have a list of 100 items in C...Filtering a form with a combo box using left function
I have a table named "TblData" containing 5 field
One field is named "IDProcedure" (text field)
This field contains information like "M-41-25" or "P-1000" or simply
I have a form with "TblData" as records source
As I want to filter the form, I create a combo box with 3 choices
"Manuals"; "Procedures" and "Process"
Now I have to put some code on the after update of the combo box
"ChoixCat" to filter the form
The only way I can manege it is using the first left c...make a list from the beginning and the end
Please help me with this problem if you can.
I have 2 numbers of a range, the first one and the last one.
I have to find out the numbers in the middle of these 2 points.
eg: I know
1 is the first number
20 is last number.
I have to know which numbers are in the middle: 2, 3, 4, 5, etc... 19.
And they should be written in different rows under each other.
So, I have a range of numbers, I know the first and the last one, and want
to find out the numbers in the middle.
Please help me to solve this problem.
Thanks a lot for your help, if you have any questions, just ask me.
Best Reg...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:
...Linking Same Tables (Current/Previous) in a Query / Sum is multiplying value results
I'm trying to link two tables in Access...both tables contain the samefields with YTD totals. I need to subtract YTD Total between the two,to determine the difference. I have the tables linked via 2 fields.I group by the two fields, and sum on YTD. It is multiplying thevalues and I'm ending up with numbers in the 200,000 instead of max ofabout 5,000.I've tried doing queries separately, doing the sum, and then linkingthe two new queries...only to have the same results.I've tried turning them into Make-Table Queries, creating the tablesand running the new query off of the 2 ta...Users does not show up on Global address list
I have Exchange 2003 and windows 2003 configured for
testing. I have like 10 created users and the last 5 does
not show up on global address list, only on All Users
address list. The recipient update services is working, i
have used ADSI to verify all that Microsoft says but...
Also i do a preview of the Global address list and it
shows the 10 users, but on the clients Outlooks does not.
If working with Outlook 2003 in cached mode, remember that it is using an
offline address book. This means that an outlook 2003 user will not see the
changes until Exchange 2003 regenerates the offline...