hello to all
My form has 2 comboboxes:cboCategory and cboPriceRange, with the important
columns being CategoryID and PriceRangeID respectively. The item showing in
cboCategory determines the choices available in cboPriceRange. All of this
Now, I want to use these 2 selections to filter my records to show ProductID
and ProductName when a button (cmdFilter) is clicked. It the user selects
Power tools and $100 - $200, I want to filter my records to show only
Products matching these criteria.
I'm new enough to coding that I can't seem to get the code for this bu...Cascading Combo Box
I have figured out how to creat cascading combo boxes, however once i update
the second combo box it changes all records on the form.
How do i get it so all records are independent from eachother?
I am somewhat new to this - any help is appreciated!
On Sun, 22 Nov 2009 19:29:01 -0800, Sarah <Sarah@discussions.microsoft.com>
>I have figured out how to creat cascading combo boxes, however once i update
>the second combo box it changes all records on the form.
>How do i get it so all records are independent from eachother?
>I am somewhat new ...save a document where fields be used but not altered
I have careated a documents that need to be saved but not as read only. The
feilds are needed, such as a form. How can I save this material so the
format remains but text box alterations and movement areno longer on the page.
There isn't a surefire way of locking the form, but you might want to try
this as a workaround. Once the form is complete, group all elements
together. Then reduce the viewing size down so the entire pasteboard area is
visible on your monitor. Draw a single line from the top of the pasteboard
area to the bottom and then a second line from side to side. Move t...Printing after using column auto fit
There seems to be a funky disconnect between my printer and excel. I've used
column auto fit to make sure all columns are large enough so that I don't get
the ####. It looks great on the screen, but when I do a print preview (and
actual print), I still get the ####. Therefore, I then have to go to each
column manually to adjust the width and keep checking the print preview to
make sure all the ### are gone.
Change the font to something slightly smaller or increase the columnwidth (like
WYSIWYG ain't necessarily true!
Caroline Lackey wrote...about filtering
can i specify a field as criteria in query
On Fri, 26 Mar 2010 22:04:55 -0700 (PDT), soha <firstname.lastname@example.org> wrote:
>can i specify a field as criteria in query
Yes, just enclose its name in square brackets.
A clearer question will get a more detailed answer. A field from the same
table? some other table? which record should provide the field?
John W. Vinson [MVP]
On 26 =D9=85=D8=A7=D8=B1=D8=B3, 21:45, John W. Vinson <jvinson@STOP_SPAM.Wy=
> On Fri, 26 Mar 2010 22:04:55 -0700 (PDT),...Last records from a Group By query
I would like to write a query to find the last (most recent date) records
only from two different fields. No problems using MAX in the ‘Date’ field,
the problem being with the ‘Player’ field. I’ve tried using LAST but it seems
to throw up incorrect results.
SELECT tblMain.Team, Last(tblMain.Player) AS LastOfPlayer, Max(tblMain.Date)
FROM tblMain RIGHT JOIN tblCurrent ON tblMain.Team = tblCurrent.Team
GROUP BY tblMain.Team, tblCurrent.ID
ORDER BY tblCurrent.ID;
Message posted via http://www.accessmonster.com
See if this helps:
Getting a...Filtering without Filter
I just don't get the following. Any ideas?
"A" row I have two different values I use: "Contact" and "Not a contact".
"B" row I have the person's name (employee).
"C" row I have a quantity, just one number.
Now what I need is to output quantities of how many Contacts Employee1 or
Employee2 or Employee3 have.
Also what I need is to get the number of contacts - which can be found on
Should I use COUNT.IF ? Row A can have 2 or more different values so should
there be somekind of conditional IF function included?
T...searching for a given record
I have to think there is a very easy way to do this, but I've been
struggling for a couple of days now and I could use some help.
All I want to do is search for a particular record using a form. I
don't want my users to have to right click and even think about
filters or anything like that. I want them to be able to type in a
partial name and press a button on the form and have the matching
records pulled into the form.
What's the best way to accomplish this?
Open the relevant form in design mode and make some room in the form's
header. With the wizards enabled, draw ...Handling Enter Key in a ComboBox Edit Box
In my continuing saga of making a variety of controls responsive to the
Enter key, I have encountered a new problem. I have now created the
CEnterEdit control which works like a charm. I wish to extend this behavior
to other types of MFC controls, in particular to the CComboBox. Through Joe
Newcomer's generous help, I have developed a new class CEnterComboBox based
on "extracting" the component EnterEdit and List Boxes. That's not a
The problem arises in making CEnterComboBox respond to the Enter Key. When
I type in the edit box portion of my control, the Edit ...verify all subforms have records
I have a form called f001ProjectReview (PK ProjectID) it has several
subforms linked by ProjectID. Sub1, Sub2, Sub3.
There is a button that activates a pop up form called fClosureApprovalPopUp
linked by ProjectID.
On fClosureApprovalPopUp I have an approval button. When user clicks the
approval button I need to verify that all subforms on f001ProjectReview have
records. If there is a subform that does not have a record then display
message that required data is missing and exit without saving.
Your help is greatly appreciated!!
You could u...Using Uninstalled Fonts in Windows 7
In prior versions of Windows OS (XP, Vista) I was able to use uninstalled
fonts with programs by simply opening the font and minimizing it to the Task
Bar. The font would then be shown in the list of fonts available for use.
This is an extremely helpful option so that it is not necessary to install
an excessive number of fonts to the Windows>System>Fonts. It also made it
unnecessary to use a font manager.
This option no longer seems to be available in Windows 7. Even though I
open a font and minimize it to the Task Bar it will not show up in the list
of fonts availab...Filter Switches vs Macro?
Excel 2000 ... I have Filter Switches which I activate
with various recorded Macros (1 Filter Switch per
Macro) ... this is working fine as long as there is not a
Filter Switch already activated.
Above said ... I need a little Macro instruction I can
paste into my recorded Macros that will set any activated
Filter Switches back to ALL before activating the Filter
Switch I am calling for???
This so I do not get multiple Filter Switches activated by
my Macros ... Thanks ... Kha
resets all filters
> Excel 2000 ... I ...How do I use the Lotus Transition Keys?
I have tried to engage the transition keys but it does not work as outlined.
Anyone with ideas I'll be so grateful
What do you want them to do and what is "does not work"?
Gord Dibben MS Excel MVP
On Tue, 10 Jan 2006 14:57:02 -0800, "projectsclerk"
>I have tried to engage the transition keys but it does not work as outlined.
>Anyone with ideas I'll be so grateful
...Can PUblisher 2003 send email using Office 2002?
I have Office 2002 and am trying to send a Publisher 2003 doc as an email.
The file menu/send email doesn't have "send this page as email". It only
gives "send as attachment" option.
Embla5 <Embla5@discussions.microsoft.com> was very recently heard to
> I have Office 2002 and am trying to send a Publisher 2003 doc as an
> email. The file menu/send email doesn't have "send this page as
> email". It only gives "send as attachment" option.
Publisher 2003 requires Outlook 2003 or Outlook Express 6 to be the default
email ...Filtering & 'Show all' when w/book protected
I have a workbook which is password protected and shared.
Users can use the filters set up across the top row, but often it'
hard to be sure that there isn't a filter in place. What would be grea
(1) the 'Show all' button worked when the book is protected. Why i
this disabled? :confused: It's not doing anything more than removin
the filter which the users _are_ able to do! At least the users coul
just hit the button and be sure that all filters are de-activated.
(2) Failing that - is there an alternative? e.g. a macro? Or is i
possible to change the colouring of...Custom filter
I have a report created but I would like another report that shows the
calculated text box "InvoicingPercentage": show records w/less than 100%
in this field and
From a subreport text box "SitesComplete": show only sites that are less
than 100% complete
full name: [Sites].Report![SitesComplete]
...Using CString object in non MFC programs
How to use CString object in non MFC programs ??
"Ash Jings" <email@example.com> ha scritto nel messaggio
> How to use CString object in non MFC programs ??
Since VC++7.1 (Visual Studio .NET 2003), you can just #include <atlstr.h>
and use CString/A/W classes in your non-MFC programs.
It is not possible with VC6.
"Giovanni Dicanio" <firstname.lastname@example.org> wrote in message
>> How to use CStri...VBA change filter match from INCLUDE to EXACT,
I expect my macro to set a filter by exact match based on a value in
The (part of) macro goes like this:
Sub Search ()
On Error Resume Next
On Error GoTo 0
UserVal1 = Range("G2").Value
If UserVal1 = False Then
Selection.AutoFilter Field:=1, Criteria1:="*" & UserVal1 & "*",
However this macro dont find EXACT match - but INCLUDED match
Question 1: What correction do I have to make to instruct the macro to
...Using a CFormView within a CDockablePane
I'm having trouble getting my head around how to use a CFormView
within a CDockablePane. The closest thing I've seen is the
CDialogPane, but that clips the controls on the dialog. I need the
scolling that you get with a CFormView.
...Cascading Combo Boxes in Form and Subform
I've been trying to work the bugs out of a form that has an attached subform.
I have a combo box on the main form where the user can select from a list of
Law Firms. Based on the Law firm selected, I would like the user to be able
select related attorneys from a combo box on subform. I would like the user
to be able to only select those attorneys related to the Law Firm selected.
I am having a hard time figuring out how to make this work. Jeanette
Cunningham has given me great advice on this but I haven't been able to make
it work. Any suggestions on what I'm doing wr...Automating a task list
I am in need of some ideas. I am attempting to put together an automated
cleaning list for one of our locations. What is the best way to do this? The
tasks fall daily, weekly, etc. and may change. Once they are in their
respective catagories (daily weekly etc) what is the best way to get them to
fall into their right times? It has to be able to take changes as well, ie.
today I am wiping the dining room tables, but in a month I would like to
change it to Fridays instead.
Any help / direction would be greatly appreciated!
Outlook or even Access would be much better o...Filters
I am receiving email that is flagged as spam by my ISP's email server. It adds
"*** SPAM ***" to the subject line.
I created a "rule" to move such messages to the deleted items folder and to mark
them as "read". However it's not working.
I also cannot seem to find where I can edit the rules or filters. I can only add
a rule to an existing message in the inbox which as I said, doesn't seem to
work. I'm still seeing them.
When I looked at an existing rule it seems to be filtering on the entire subject
line rather than the spam bit. When creating t...Custom filter
I am using the autofilter, and wish to Customise a data set in one of my columns.
A column has a listing of numbers 1-32. I wish to undertake a filtered selection of of only cells wish contain the numbers 1,2,3 & 7. How do I do this using the autofilter option? I have tried the 1-3,7 option but it didn't work w/ the 'contains' mode.
Can anyone advise? Thanks,
Unfrotunately Autofilter only allows for a limited number of criteria.
I appears that you now need to use advanced filter. That allows for a
lenghtier criteria lsit like 1, 2 ,3 , 7.
Message posted from http://ww...using macro to send e-mail
Is it possible to send a table from my spreadsheet to a colleague vi
outlook from within the macro that creates the table
bob777's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2850
View this thread: http://www.excelforum.com/showthread.php?threadid=48100
Hope this helps
> Is it possible to send a table from my spreadsheet to a colleague via
> outlook from within the macro that creates the table?
...Company does not display in the list
I've created a new company uing the GP Utilities, but id does not disply in
the list of companies.
Did you give users access to the new company under User Access?
> I've created a new company uing the GP Utilities, but id does not disply in
> the list of companies.
The company does not display to even alow user access setup.
"Andrea Smiley" wrote:
> Dennis -
> Did you give users access to the new company under User Access?
> "Dennis" wrote:
> > I've created a new company uing the GP...