I am trying to use the list box function from the control
toolbar. I am not sure how to get the listings I want in
the list box. Is there certain VB coding that is needed?
Any help will be appreciated. Thanks.
No VBA code needed. In Design mode, click on your list box and select
Properties from the Control toolbox (or right-click your list box and select
Properties), then scroll down to the ListFillRange Property and indicate the
cell range address that has the items you want to appear in the box (i.e.,
A1:A10). Then exit out of design mode and test your list box.
"Tod...how do i view different mail boxes
I have set up different email accounts in outlook 2000. How do I choose
which mail box I view when I go to outlook?
btoonhoule <firstname.lastname@example.org> wrote:
> I have set up different email accounts in outlook 2000. How do I
> choose which mail box I view when I go to outlook?
Using IMO or C/W mode?
...Concatenate Multi-Select List Box Items
I need to use the chosen items in a multi-select List Box as concatenated
text in another control on a subform. This text will be part of a large
amount of concatenated text. How do I do this? I did find info here about
using such items in a query but it was way over my head and I couldn't figure
out how to convert that idea to this issue so please don't just refer me to
that w/o some other explanation for this novice.
For example, if the user selects: Frt Bumper, Grille, & Headlamp in the
List Box, I want to then somehow concatenate those selections into a sente...Filtering a combo box using a combo box
I am trying to filter the records from a table displayed in a combo
box using a combo box on the same form. I built a query and set the
criteria as Me![FormName]![Combo_box]. This allowed me to filter the
list, but it did not do exactly what I wanted. When the first combo
box is blank, the second one is also blank. Is there anyway I can get
the second combo box to display all of the records when the first box
Thank you for your help.
Try a criteria in the second combo of:
Like Forms!YourFormName!Combo1Name & "*"
Arvin Meyer, MCP, MVP
http:/...colour change of dated box
How can I change the colour of a dated box of excel after the date is over. I
want the programme to read date automatically from pc and change colour.
try Conditional Formatting
1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Cell Value Is from the first drop down
3. Choose Formula is from the first drop down
4. Choose less than
5. In the third box, enter =TODAY()
6. Click the Format button
7. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.
Hope this is helpful
Appreciate that you provide your feedbac...Combo Box on Forms
I am using a combo box on a form that has several items w/ one being
Other. If the user selects other I want them to be able to input what
they want so that it will go into the table instead of just the
"Other". I just am not really sure on how to do that. Can you help?
In design view click on VIEW - Properties and the the combo. Then change
Limit To List to No.
Build a little - Test a little
> I am using a combo box on a form that has several items w/ one being
> Other. If the use...sent box
how do i get the emails in the sent box to show sent to instead of sent from?
> how do i get the emails in the sent box to show sent to instead of sent from?
Add/remove whatever columns you want. Right-click on the header row and
select Field Chooser.
i may have not explained myself too well
i dont want to sort by the "to" column
i want the header on the email to show "to" not "from"
i think the problem might be that this is not the default sent file, its
just a folder named "sent"
its for my boss, he ha...Combo Boxes
Someone sent me an Excel document where each of the cells in I1:I312 are
combo boxes. When you click off of those cells, the down arrow
disappears. The list for the combo boxes are cells AA1 and AB1 (AA1 is
New and AB1 is Existing). Please explain how this was done? Also, can
you please tell me if it is possible to make New and Existing autocorrect
entries. So even though the choices are New and Existing, if you hit N,
New appears, and if you hit E, Existing appears. Thanks!!
It sounds like Data|Validation.
Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlDataVa...Edit box should support languages like japanese,chineese etc
Hi wht im trying to ask is..
1. In my application, all the labels r in english only.
2.If i change the content of one text box in japanese or chineese
[Text box value is the title for another dialog]
4.After i changed the content, i want the title to be displayed in
japanese or chineese language.
Note: I want only that text box to be changed ,,not the entire
so How can i able to support multibyte characters in MFC controls CEdit
They do. You have to be in a Unicode app, and you have to have selected a Unicode font
that has Chin...Separator in combo box
Is it possible to have a line separator in a combo box? I mean something
like a separator in menus?
Nish [VC++ MVP]
http://www.voidnish.com /* MVP tips tricks and essays web site */
http://blog.voidnish.com /* My blog on C++/CLI, MFC, Whidbey, CLR... */
"behzad" <email@example.com> wrote in message
> Is it possible to have a line separator in a combo box? I mean something
> like...Text boxes on graphs
How do you make a text box hide the grid lines behind it on a graph? The
grid lines are still visible and run through the text box, cluttering it up.
right-click text box
choose -- 'Format Text Box' from shortcut menu
colors and lines tab
change fill color to white
remote programming and training
8-part free tutorial that covers essentials in Access
(: have an awesome day :)
> How do you make a text box hide the grid lines behind it on a graph? The
> grid line...Multiple Combo Boxes Highlighted
I have a problem with something in VB6.
I have 4 combo boxes with individual names (not an array) located on an
When I select another tab and then return to the tab these boxes are located
on, each of them appears to be highlighted in blue.
I add values to them only when loading the form so I'm at a loss as to why
this happens ?
Any ideas are greatly appreciated.
"Jennifer Ward" <firstname.lastname@example.org> wrote in message
> I have a problem with someth...HELP !! Combo box to feed other combo boxes
I have a form with a stock list. One field is [Dealer Allocated] so stock
can be allocated to a specific dealer - this is a combo box (combo1) for
I now also want to be able to update this combo box for several records in
bulk. I thought I would do this by having a second combo box in the footer
of the form which the user selects the dealer from and then clicks a button
which looks for first record without dealer allocated and updates the value
of combo1 to the value of combo2. This would then be enclosed in a Do Loop
for specified number of records.
I can...Set Text Box Control To Blank
I have a procedure that executes on the beforeupdate event of a
textbox (text24). The procedure works out the checkdigit for the
number entered and if there is a discrepancy, a message box appears
telling the user the number is wrong. What I'd like to do is modify
the code as such so that when a discrepancy is found and the user
clicks ok on the message box, focus is returned to (text24) and set to
blank so that the faulty number is gone. Here is the code I am
using.... It's quite crude as I'm only at beginner level, but hey, it
Private Sub Text24_BeforeUpdate(Cancel As Int...Populate field based on combo box
I know this shouldn't be so hard - but I'm having a brain ... or something!
On a form, I would like to select a District Number from a combo box and
have the District Name appear in a text field. My form is based on a query. I
know somehow I need to add criteria to my query to point to the info in the
combo box but I'm not sure exactly where to put this criteria. Should the
combo box field for the District Number on the form be based on the
Districts table or is this the field that comes from the query? Or is it the
District Name field that comes from the query? I have neve...Flag box
Is it possible to add some flagbox in a column?
Depends on what you mean by a flagbox.
If you mean some sort of indicator, you could put Y or N in a column (X or leave
empty??) and use data|filter|autofilter to "flag" certain entries.
> Is it possible to add some flagbox in a column?
I meant the square with the x on it ..sorry if my explanation wasn't
I find this technique pretty easy...
Select the range
Format|cells|number tab|custom category
In the "type:&qu...text box margin settings
I've changed the text box margins, saved the file and
closed the file. But when I reopen the file, the changes
are not there. What gives?!?
The text box margins in an EXISTING text box have changed?
Microsoft Publisher MVP
>I've changed the text box margins, saved the file and
>closed the file. But when I reopen the file, the
>are not there. What gives?!?
This issue is unknown in Publisher any version.
If you mean it is not saving the defaults on next Text F...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:
[Forms]![frmMainForm]![sfrmSubfo...Combo Box Selection 06-18-07
I have a form that has 3 subforms.
The main form has a combobox with selection for Groups. According to
the selection of the Group - the subforms should show info for that
In the Second Subform - this shows Group Details - there is a combo
box for Section - where stock from the group will get transferred to
the selected section. The choice for Section here should also show in
the next subform.ComboBox Section.
As inthe next subform this shows Section Details.
At the moment - the Section Selection in SectionDetails subform is not
updating the value that has been selected. Please hel...combo box
Hi: I have a combobox which shows two values: name and age, after I
choose "the value", the combo box just shows the "name". I need to be
able to print both values. How can I tell the combo box to leave the 2
You can only display one column in the Combo Box.
Is this Combo Box on a worksheet? If so, the TextColumn is the one that is
displayed and the BoundColumn is the value returned by the combo box.
You could make the TextColumn 1 (Name) and the BoundColumn 2 (Age). Then set
the Linked cell to an adjacent cell just to the ri...How do I control a text box via another combo box
I have read through dsome o the other answers and I just can't seem to get it.
I have a table called employee information.
Within that table are two fields. Retail Title and Retail Incentive.
I have a form with a combo box for the the Retail Title.
This field looks to a table called Retial titles which is two fields...Title
What I want to do is have it so when I choose a title in the form it
populates the incentive in another text box.
The combo box column count = 2
What should by settings be for my text box?(That of course if I should be
using a t...Using Concatenate function to generate text in Text Box
I would like to have a text box on my chart, whose text is generated by
concatenating the values from two different cells (B4 and B6) on a specific
worksheet in my Excel file. I was able to use a reference to cell B4 to
generate the text for my text box using the following formula:
However, when I try to enter either of the following formulas for the text
='SSTyp-AllD'!$H$4 & 'SSTyp-AllD'!$H$6
I get the error message "The text you entered is not a valid refe...Requery of combo box
I have a form (input) with 5 combo boxes (registration, location, notes, time
& date) and 4 Yes / no check boxes. It writes to a table (Data file)
The combo boxes do update with the after event function but as soon as I
type into any of the combo boxes a new blank row is added to the form which
is set as dataenty "yes"
The problem is that the updated combo box content list is always 1 row
behind where the data is being entered. Is there a way of changing when the
new row is added to the form please?
...Save as Msg box
I have the follwowing to save as a form:
ChDir "V:\Netshare\Item Master Creation\2005 Item Request Submission"
fName = Application.GetSaveAsFilename
Loop Until fName <> False
ActiveWorkbook.SaveAs Filename:=fName, FileFormat:=xlNormal
1. It doesn't go to the directory that I have above: "V:\Netshare\Item
Master Creation\2005 Item Request Submission"
2. I want to enter a message box that confirms that yes they want to save
after they have entered the name in the save as box. In the Excel hlp I was
just ...Answer YES to Dialog boxes in Excel macro
I have set up a macro that does a lot of sorting, subtotaling, text t
columns etc. Each time I run the Macro the same dialog boxes pop u
when I created the Macro using the recorder. The dialog boxes are
1- Do you want to replace columns of the distribution cell. (when I d
text to columns)
2- The dialog box that pops up when one does a subtotal.
Is there a way I can somehow disable dialog boxes in the VB code. Or i
the start of the code write something that says Answer Yes to al
dialog boxes that pop up? Or any other way so that I can run the macr
and not have to sit there to answer yes to e...