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:/...How to prevent list item selection
I'm having one of those blond moments (no offense to any blonds). I have a
simple list box to display information. I want to immediately unselect any
item that is selected. None of the obvious items I've tried worked. Any
Set the value to -1
"Robert Flanagan" <firstname.lastname@example.org> wrote in message
> I'm having one of those blond moments (no offense to any blonds). I have
> a simple list box to display information. I want to immediately unselect
> any item that is sel...When i read an email in outlook, why will it not show as read?
Depends on how you configured Outlook to mark messages as read in the
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, bingobones asked:
>You have to configure this. In Outlook, go to Tools,
click Options, then click the Reading tab. Click on the
box that says "Tell me when all messages have been ...How to show dialog behind parent?
This is not a big deal, but I am curious whether it is possible. I have
an application that I created a modeless dialog for. It works fine,
but I would like to have the dialog go behind the parent when the user
clicks on the parent form. Since this is a modeless child dialog I am
wondering if this is possible and if so how would I do this.
If I understand what you're trying to do I think you could make the parent
of the non-modal dialog GetDesktopWindow() and then it can float anywhere,
however one problem is that if it goes behind another window it may be
difficult to ...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...Need help finding the right function, please
The cells in Col A contain one of four values. The cells in Col D
contain dates. I want to return the highest date for each of the four
values. I'm having a difficult time understanding how the different
look up functions work to allow me to get =(MAX(all dates in Cold D
where Col A = "x")).
The Help files for both LOOKUP and VLOOKUP indicate the values in the
column to be searched must be sorted in ascending order. That can't
happen in this sheet. I'm stuck with them as they are.
A drop-kick in the right direction would be much appreciated!!
=MAX(IF(A1:A...messages i receive show html formatting sentences not formatted ht
messages i receive show html formatting sentences not formatted html, so i
get lots of html writing and a few words of plain text spaced through the
message. How do I get the html formatting to operate.
...Excel prob = Compile error cant find project or library
when i open excel 2002 on my xp pro pc it opens up with te
Compile error cant find project or library
then takes me into the VB, the section it takes me to is
talking bout setlanguagestrings?
but when you close this screen excel works fine.
any help please
thanks in advance
Maybe an add-in with a programming error is bothering you.
1 Tools, Add-ins
2 note which are checked
3 uncheck all (but one)
4 restart XL
5 if no error, check the next one and repeat from step 4
Got the error? uncheck the one you last checked.
Not an add-in? It will be a (hidden) workbook t...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...Zip code loses leading zero Mail Merge from Excel to Word Labels
Even though formatted as zip codes, I cannot get the leading zero to show in
my zip codes when using Word mail merge to create address labels.
Example: 04103 shows up on the label as 4103
Debra Dalgleish posted this to a similar question:
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:
abou...I need help uploading my site on to the internet using Microsoft .
I have no idea how to upload a site to the net, can some one help?
Email @ email@example.com
(1) We don't do personal responses. That defeats the purpose of a public
(2) There is a group specifically for web issues -
(3) It's going to depend on where your site is being hosted. Have you asked
them any questions about how to upload files to their server?
MVP Microsoft [Publisher]
"Kay_swa" <Kay_swa@discussions.microsoft.com> wrote in message
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...Wrong Due Date on APAYs
My APAYs show the wrong due date on the Bills Summary page. For example, a
monthly mortgage payment shows the next due date being Mar 2007. A monthly car
payment, with only five payments left, shows the next due date being in 2011!
The next payment on the Bill Calendar is also missing -- sometimes one or more
-- not necessarily related to the missing payment dates from looking at the
This was a problem in Money 2003 before I upgr^H^H^Hchanged to Money 2007.
After I installed M2007, I did the File Repair and also the Remove All Bills
Data options. This seemed to correct the p...How to stop Outlook 2003 sp2 showing a message?
How to stop Outlook 2003 sp2 showing "Are you sure you want to permanently
delete all the items and subfolders in the "Deleted" folder" every time I
Either turn off the setting to empty the Deleted Items folder on exit or =
turn off the setting that prompts the user when items are deleted =
permanently. Both are found in the tools | Options dialog.
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators...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" <firstname.lastname@example.org> wrote in message
> Is it possible to have a line separator in a combo box? I mean something
> like...Expense Item not in Budget View
Does anyone know how I can view transactions that have been entered but are
not currently in my budget. The only budget views I can find are the actual
budget and the budget vs spending report, but no where to view transactions
that I need to put into the budget.
You could let autobudget decide for you, although you might want to review
it's suggestions before you do so. This is under the 'expenses' part of the
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny or
http://money.mvps.org/faq ...Device Cannot Start (Code 10)
XP Pro on Dell XPS 630i
After fruitless searches for my problem I come to this group. My Nvidia 8800
GT Card (1 year old) will not start no matter what updates I get. Still the
constant "This Device Cannot Start-(Code 10)" I've pulled it out put it back
in, Nanda! The lines are driving me nuts!! Any help in this matter? I've
uninstalled the device, re-installed it. The card works on my other older
Dell...Everything was fine until I wiped the drive and reinstalled Windows XP
Pro. Anyone else out there have this problem?
Try asking them here.
...area chart doesn't show values
in excel 2003 i have created a area chart, based on values per day. If
i point the mouse on a data point, a flag will show the data and date
of this value. after open in excel 2007, this will only work, if i
change the chart type from area to line-graph, so do everybody know,
how to show the values in an area chart?
thanks and greetings from switzerland
...Show Daily Price Change Statistice in Portfolio
Since there are many people who use MS Money Plus Deluxe might find that the
Options to show the Price Change and Percentage change from previous days
activities has been ELIMANATED in the latest version of Plus Deluxe.
I would be interested in having this option and feature returned as an update.
Since the holdings in many company profit sharing plans, IRA's and 401k
don't have TICKERS, the need to compute the needed information already exists
in the price histoty data downloaded from the Non Microsoft Web Site.
This post is a suggestion for Microsoft, and Mic...Outlook version of CRM is showing inactive account as well when se
We have a client who has an issue where when you are in Outlook version of
Microsoft CRM and do a search on account, inactive accounts come up as well.
The machine are online all the time, they are not laptops, they are just
network desktop machines with Outlook Sales CRM client installed.
But this doesn't happen on web version of MSCRM, web version of CRM only
list active accounts when searching.
Has anybody come across this before?
I need to know the simplest way to show the last update of a sales tracker
for individual locations in the master tracker for the region that all
individual spreadsheets link to.
...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" <email@example.com> wrote in message
> I have a problem with someth...Report works but then fails when used as a Sub-Report source
Hi, sorry if this sounds too easy or stupid, I've been trying for a couple of days now to get this to work and I've read a lot on here so hopefully didn't miss anything.
I have a report that basically draws fields out of a table and displays them, nothing fancy. I need it to print 8 and then page break, again no problem as a report - it works. Now the main report has 5 of these sub reports and I figured I would work with it one at a time to get it right and eliminate re-doing a lot of work. When I use the report as the sub report source there are no page breaks and the report i...Help needed in print
I am displaying lot of labels and progress bars in side form view. I want to
print all the label and progress bar as it looks in the form view.
thanks in advance
You might be interested in Joe Newcomber's site, here:
where you'll find code for screen copying and bitmap printing.
Abstrakt Mekanik AB
"Harish" <harish.k at sify.com> a �crit dans le message de
> I am displaying lot of labels and progress...professional service tools library download
Hi, can somebody tell me where I can download professional service tools
library? I have contacted microsoft, but they didn't answer my questions.
Is there a demo version for GP 7.5?
You should be able to search for it and find it. I think it's also on the CD.
If not, send me a message. You can use it with the sample company.
> Hi, can somebody tell me where I can download professional service tools
> library? I have contacted microsoft, but they didn't answer my questions.
> Is there a demo version for GP 7.5?
Hi, allen. I have tried search...