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:/...Macro to add text to a Message
Although I have used VBA in Excel, I have never used it in Outlook. Using
Outlook 2007, What I would like to do seems simple enough but I have no clue
how to do it. All I want to do is add text to the body of a message. I
thought something like this would work but I get the error message "Sub of
Function not defined". I know I'm missing an event or something but I'm not
sure. Can someone please help?
Dim Aprvl_Text As String
Aprvl_Text = "Your approval is requested for the following contract
renewals. Please a...Command Button Text Resizes
I have Office XP on a Windows XP OS. For some reason, the text on my command
buttons, when clicked by the user, decreases in size on each subsequent
click. until it is very teeny. What is happening and how can I fix it?
...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...convert number to text #4
How can i convert a number to text format without then editing that cell to
force the cell to except the format change.
I need a numbers to convert to text because a download from another program
is already in text format with SS# in the cell. Then using at templet sheet
with a VLook Up formula to pull information off the first workbook.
To convert number to text, select the area you want to convert, right-click
on format cells and choose "text".
> How can i convert a number to text format without then editing that cell to
> force the cell to ex...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...recurring Windows Configuration box appears since installing Publisher 2007
I am very frustrated with this problem and hope someone can help.
Ever since I installed Publisher 2007, I have been having trouble with my
Outlook 2003. I was not happy with the entire suite of programs on Office
2007 Enterprise but since I had already designed my business cards with
Publisher 2007, I needed to load it on my desktop. (My Office 2003 version
didn't include Publisher). Ever since installing the Publisher, from time to
when Outlook (2003) downloads email, a windows installer box appears saying
to configure Office Enterprise 2007; the dialogue box says "...How to write text file
How to wrote a field (memo) content to a text file. Before write to text
file I want to remove the <div> ,</div>. How to do that?
"SF" <firstname.lastname@example.org> a �crit dans le message de
> How to wrote a field (memo) content to a text file. Before write to text
> file I want to remove the <div> ,</div>. How to do that?
>parler francais ou espagnol
Are you using Access 2007, with the .accdb file format, and a rich text
fo...New Excel Comment Box Issue
My Excel comment boxes are showing up as a solid black box. On the
surface, it looks like the same issue as all the other posts that I
have read. I'm running Office 2000 on Windows 2000 desktop. This has
suddenly stopped working in the past week or so. I'm having problems
with all spreadsheets with comments. I can access the spreadsheet on
different computers without problems - all with the same setup. I have
tried the following to no avail-
Reinstalling Excel (2000)
Checking the settings for the comment boxes - my settings are
fill color: automatic
style is set to 3/4 pt
...= Text formula problem
I am using an excel spreadsheet as a linked table in an access database for
an update query. I had it working very nicely for a period of time. I am
not sure if some Microsoft update caused a problem or what. The field I use
t o update my database didn't work until I used this formula to make a new
I have a column of numbers which was retrieved from a data miner program
it's called Acct. For some reason Access doesn't like the formatting so I
insert a blank column to the right and call that PtNum. In the first cell
of this column which is C2, I type ...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...convert text to Date..
How can I convert my text field ( read from CSV file) to show the Date as
01/05/2010 instead of long date..
Can I use CDate()?
rundate =Tuesday, January 05, 2010 12:45:11
I used the following..
'Dim date_tested As Date
'date_tested = Format(rundate, "Short Date")
'date_tested = Format(rundate, "mm/dd/yyyy")
Message posted via AccessMonster.com
Try this --
'date_tested = Format(CVDate(run...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...Automatically inserting text into cells which already contain text
Operating System: Mac OS X 10.6 (Snow Leopard)
I need to insert a particular text into the same selected cells in 145 separate rows. The selected cells already have text within them and I need to insert the new text at the beginning of each cell without damaging the text already in the cell.
One way to do this is to use the ampersand as follows: <br><br>if A1 = dogs, then in B1 enter: <br>
="Cats and "&A1 <br><br>This will result in B1 being equal to: <br>
Cats and dogs <br><br>So ...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...Opening a text file in excel
Using a visual basic 6.0 I have created a tab delimiated text file, which is
an export of a Query.
I what to then open this file automaticly after it is created in Excel.
I've looked about and can't find anyone with a simple answer. Most questions
involve macros but I'm working from a vb application to excel.
How do I open Excel?
Dim xlTmp As Excel.Application
Set xlTmp = New Excel.Application
I have tried the following but I get the error message:
"User-defined type not defined"
Fname$ Contains the path of the text file.
...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...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...How drop a text file?
I'm designing the error logic for a VB2005 console application that reads
Excel files from a folder, one at a time, and writes a text file for each
when called by a script. I'm using streamwriter to write the text file. If I
trap an error and want to throw the text file away cleaning up all the
associated resources, how do I do that?
I reviewed MSDN on streamwriter's methods but none looked promising. The
closest was dispose, but I had trouble understanding the article and it
didn't feel right.
Please be patient if I don't reply promptly. I am not getting...Problem with Wrap text
I have a problem with wrap text in merge cells.
when the cell is formatted (single cells) everiting is OK.
When the merge cells is formatted (three cells in one merge cells) it
is not OK.
I must manually change height of the cells :(
I get the same result! It may just be a bug in XL. I
even tried merging the cells AFTER formatting them,
and that didn't make any difference. I also un-merged
the cells, and the word wrap was fine, but on
re-merging them it was just like before. I don't know
if there IS a solution!
<email@example.com> wrote in message ...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:
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...