Multiple selection in CListCtrl on Pocket PC 2002
I am trying to use OnLButtonDown & OnMouseMove to generate multiple
selections in a CListCtrl (on Pocket PC 2002) but the hilite is not working.
There is nothing fancy like drag and drop or subitem selection going on here,
just pen down, move, pen up, to select multiple rows in the control. I've
seen numerous examples that use:
SetItemState( idx, LVIS_SELECTED, LVIS_SELECTED );
RedrawItems( idx, idx );
But this doesn't work for me. If this isn't the right approach on WinCE or
has been superceded by an alternative approach, I'd appreciate some
Hello! Need a little help please.
Question, how do I terminate/close the listbox after the user made one
My code filling up a the listbox and calling a Userform1
Thank's ahead for any pointers.
i = 1
For Each ws In Worksheets
i = i + 1
Private Sub ListBox1_Click()
...Count cells with data
I receive large databases each month. I have been able to format the data
using PROPER. Though when I follow the instuctions from "3 formatting
shortcuts" it calls for dragging the fill handle to the end of the new column
to show all the converted cells. My databases are hundreds of names long!
Is there a way to count the cells with text in them in advance - without
scrolling down to the bottom - and then put the range into the =PROPER (range
of cells with data) command?
Thank you kindly
You are using a second column to convert to Proper?
You can Double-Click the Fill...Counting items from Table
I've created a table that has a number of columns, eg
Item No Open/Closed Type
122 Open Letter
143 Closed Fax
156 Open Letter
234 Closed Letter
253 Open Fax
And what I want to do is add up the number of items that are open and
of type Letter. i.e
Open AND Letter = 2
I've tried COUNTIF but that only works on one column, so any
suggestion on how I can achieve this. This list will be added to so I
would prefer the sum updates to be done automatically over a larger
range than is currently present.
Thanks in advance for...Selecting first value
I am trying to select the first value that comes up
in a row from left to right. The value isn't neccessarily
the highest value or the lowest, thus the MAX function is
out of question. I don't want to write a macro, so I was
wondering if anyone had an idea of how to do this with a
Here is one way
Its an array formula, so enetr with Ctrl-Sift-Enter.
B2:Y2 are the cells being tested, just change to suit.
... looking out across Poole Harbour to the ...Adding text to a listbox from main frame
I am a new poster here, so I hope this is the correct group to put this
I am a beginner to VC++, and I'm trying to accomplish something that
seems like it should be simple. I have a main frame that I've added a
child dialog to, called TabCtrlHolder, which acts as a holder for the
various pages in my tab control.
I then have 6 pages that I can switch through with tab control. On one
of these pages, I have a listbox that I need to add data to every time
an event occurs. But I can't seem to access the listbox! I've tried
mainFrm:...Selective Saving per Email
Is there an option that can be set so that Outlook 'asks' you each time you
are about to send an email as to whether you want to retain a copy or not? I
know how to change the setting to 'save' a copy of all the emain that are
sent, but then you have to keep going back and deleting and purging the ones
you don't want to keep. I also know you can cc yourself and receive a copy
and then keep in a personal folder, but is there a setting that will
automatically prompt as to whether you do or don't want to keep a copy in a
'sent' folder upon sending (works t...Location selection at installation was wrong in Gp9
any idea how to fix the problem? reinstall on each workstation will do?
...Storing values from a listbox
Can someone explain to me the concept of storing values from a listbox if I'm
allowing users to select multiple items? I understand the single select
process and how it stores it but do I need to set up a different table to
store the multiple values? And how do you store multiple values into one
field? Or do you?
Don't use a multi-select list box to try to jam multiple values into a
Instead, create a related table, so one of your main records can have many
related records in the new table. Then use a subform, so the user can enter
multiple records (one per row.)
Al...Human resources -HR- ala carte selection
I am attempting to plug some holes in my HR reporting. I am having trouble
assessing the capabilities of one GP 9.0-10.0 module to another.
Is there a single place to see where advanced payroll stops, Human resources
picks up, Advanced HR enhances, PTO fills a gap, payroll extensions fills a
need? Where any of the afore mentioned overlap?
I can't seem to get a clear view of each module to determine if I need to
acquire more software or modify my business processes and reporting. I would
love to see the capabilities of each module on a concise one-sheet.
I would start with the ...Parameter query to select multiple child records on the same field
I have a parent-child relationship where I want to be able to select all the children of the parent which meet multiple
criteria on one field. For example, for a parent name of "Big Creek" I want to be able to select all the child records
in which the map field contains "Dunsmore" AND those in which the map field contains "Cruso".
I have no trouble building a query which works for one child paramter value, "Cruso" for example, but the multiple
parameters on the same field have got me stumped.
On Sat, 09 Feb 2008 16:09:37 -0500, David Wetm...How do I count # of cells with same value other column?
In column A, I have values equal to either YES, NO or NA. In column B, I
have values equal to either YES, NO or NA. I want to count the # of cells in
column B that equal to their counterpart in column A. For example: A
1 yes yes
2 no no
3 na na
4 yes no
5 Total I want should be 3 as B1=A1 count, B2=A2
count, B3 = A3, B4 ≠ A4
Thanks in advance!
sorry my date is not visually clean...I'll try this:
1 YES YES
2 NO NO
3 NA NA
4 YES NO
B5 should have a result of 3.
&qu...Listbox execute SQL error
My form has 2 list boxes. The left box lists items in a truck the right box
lists items on a rig site. My code for moving from the truck to the rig is
fine but it is not working properly when moving items from the rig to the
I use the following code to move items from the rig to the truck:
Private Sub cmdRemoveOneSite_Click()
Dim strSql As String
Dim strWhere As String
Dim varItem As Variant
Dim rst As DAO.Recordset
Dim db As DAO.Database
10 Set db = CurrentDb()
20 If Me.lstOnSite.ItemsSelected.Count = 0 Then
30 ...1. Selecting field with "enter"; 2. permanently accepting macros
I have recently upgraded to Access 2007 and two characteristics of my former
database are not coming through & I want to get them back. First, in Access
2003, I had set it up so that if I hit "enter" the entire field would be
selected. Now "enter" causes the cursor to jump to the next field. How can
I change this?
Secondly, In my database forms, I had incorporated buttons. Now, each time
I open the database, I am given a warning about macros and I have to manually
tell the program that the macros are trusted. Unfortunately, Access doesn't
accept this an...Counting time ranges
I have a spreadsheet that looks like this...
I need to be able to count how many times each hour shows up, I tried using count if but the range isnt working?
maybe something like
to count the numer of 9 hour occurences
>I have a spreadsheet that looks like this....
>09:...Word Count for Section in W2007?
Does anyone know a way to display the word count of a chapter or
section? I'm currently displaying the word count in the status bar,
selecting the section and recording the words manually.
I've found NUMWORDS, but would like to use several of these in the
same document with each one counting the words in a single section.
This is a multi-part message in MIME format.
Add the Word Count command to your QAT. Make a se...Listbox to control listbox
I have a list box with all phone numbers in it. I would like to be able to
filter the listbox phone numbers by category.
In other programs, I have seen two listboxes side by side and one be
clickable to filter the results of the other listbox. How can I accomplish
Any suggestions on this would be helpful.
> In other programs, I have seen two listboxes side by side and one be
> clickable to filter the results of the other listbox. How can I accomplish
> this result?
2 tables: one containing the categories and on...Multiple selections from a list
Is it possible to construct a dropdown on a form that allows people to pick
more than 1 value from a list? For example, if the values on the dropdown are
"Bill", "Bob", and "Sue", and I wish to select both "Bill" and "Bob", and
have both values stored together on the same record, is this possible?
What version of Access?
It's not possible in Access 2003 or earlier.
It's possible in Access 2007, provided you're using the ACCDB file format.
Doug Steele, Microsoft Access MVP
I don't know if this is a dumb question but how do you programmatically
select and deselect CListView items? I need to do this to single items and
"Peter Simmonds" <firstname.lastname@example.org> wrote in message
>I don't know if this is a dumb question but how do you programmatically
>select and deselect CListView items? I need to do this to single items and
> Peter Simmonds
> Northampton, UK
CListCtrl& lvCtrl= GetListCtrl();
/...Exporting selected data / automation
Like so many others, I am an Excel newbie. I was a mainframe COBO
programmer in another life, but that was a few years back :rolleyes:
My manager would like me to write an app that will take data from a
existing Excel spreadsheet (generated by our system), select only
handful of columns, write out a new spreadsheet with the selected data
and then the new spreadsheet will be used as input to a new Acces
database that I will create.
1) How do I select which columns I want to export? I tried highlightin
the columns and then doing a "Save As..." but that just gave me an ex...Listboxes in Word
I am making a word template and want to put some listboxes in the document.
While this worked well in Word 2007 for Windows, the same template doesnt work
in Mac Word 2008.
In fact the control is locked and cannot be edited at all.
Is there a way I can put listboxes or comboxes in a word document for Mac?
thank you for your help.
What you most probably used is other than one of the legacy controls & is
based on ActiveX which isn't supported by the Mac OS. In Mac Word use the
tools on the Forms Toolbar. They will function in the PC versions.
Bob ...Mutually Exclusive menu selections
How do I group a series of menu items so that one and only one can be
checked? I know how to group a set of radio buttons on a dialog but I am
confused about menu items:
File Edit Setup Window Help
? type 3
This outgoing email was scanned by
Norton Antivirus Corp. Edition
and found to be virus free!
www.Newsgroup-Binaries.com - *Completion*Retention*Speed*
Access your favorite newsgroups from home or on the road
Ron H wrote:
> How do I group a series of menu items so that one...2nd Posting Select Value In Query
My data are as follow
Myvalue value1 value2 value3
100 20 50 70
200 null 100 210
my goal is to divide myvalue with either value 1,2 or 3 whichever is higher
how to put the expression in query
Here is what will go in the SELECT field of your query:
If value1 and value2 and value3 could all be null or zero, then you must
test for that (I am assum...ListBox
I am trying to create one customized ListBox.
1) I have one CStatic as ListBox container and it holds one ListBox
which is object of CListBox and one customized ScrollBar.
2) The picture is like, when I click on one button (which is on a
dialog) , list box appears.
3) I also have some other controls on the same dialog.
Now my problem is whenever I click on the portion of listbox which
is overlapping with other controls it gets hide.
> I am trying to create one customized ListBox.
> 1) I have one CStatic as ListBox container an...Cell Selection?
I have a colum of numbers
What I need, is to be able to select 3. the 198's are not going to be used
in the next part of my equation. That seems simple enough, however all the
numbers could be usable (not 198) and I need to use just the first three. Any
One interp / way, using non-array formulas
Assuming source numbers in A1 down
In B1: =IF(COUNT($C$1:C1)>3,"",C1)
In D1: =IF(A1="","",IF(A1=198,"",ROW()))