Sad Der
accessd666 at yahoo.com
Thu Oct 9 01:47:01 CDT 2003
Hi group,
I've got a question regarding the form
frmMultiPickMSForms in Chapter 07 from the book
ADHK2K.
It uses listboxes and some controls to move items from
left to right, up and down, etc. I need a lot of this
functionality.
It uses a reference called: Microsoft Forms 2.0 Object
Library.
In short: I do not understand HOW it works.
First: when I open a new database I do NOT have this
reference. Why is that?
Second: How can these controls be 'controled'? It only
uses the code below. In wich MultiPikMSForms is a
class and RegisterControls and SetData are methods of
that class. How is it possible that when I click a
button action is taken? There are no events or
something like it connected to the control?!?!?!
Could somebody please explain? TIA!
SD
'------------------------------------
Private mmp As MultiPikMSForms
'------------------------------------
Private Sub Form_Load()
' Using MultiPikMSForms requires
' three steps:
' 1. Instantiate the object
' 2. Register the 8 controls with the object
' 3. Tell it where your data comes from
Set mmp = New MultiPikMSForms
mmp.RegisterControls lstAvailable, lstSelected, _
cmdSelectOne, cmdSelectAll, cmdDeselectOne,
cmdDeselectAll, _
cmdUp, cmdDown
mmp.SetData "tblCustomer", "LastName"
End Sub
'------------------------------------
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com