How do I create a canned form? 
Author Message
 How do I create a canned form?

(I'm an beginning Access developer; any help would be greatly appreciated.)

I want the user to select a list of items.  The form would contains two list
boxes -- one list box contains a list of all items, the other list box
contains a list of selected items from the first list box.  The function
would look something like:

boolResponse = AddRemoveItems(colAll, colSelected)

where
   colAll is a two-dimensional collection of items (id and description)
   colSelected is a one-dimension collection of ids of the selected items
which is returned
   boolResponse is boolean; if user cancels form then false; otherwise, true
and colSelected contains selected items

I want this function to be as generic as possible so that it can be used in
different applications.

Can you get me started?

Thanks in advance.



Mon, 28 Oct 2002 03:00:00 GMT  
 How do I create a canned form?
Hi Joseph,

Fortunately, Microsoft already had the same idea.

Check the help files for "MultiSelect Property".

Norm

Quote:

> (I'm an beginning Access developer; any help would be greatly appreciated.)

> I want the user to select a list of items.  The form would contains two list
> boxes -- one list box contains a list of all items, the other list box
> contains a list of selected items from the first list box.  The function
> would look something like:

> boolResponse = AddRemoveItems(colAll, colSelected)

> where
>    colAll is a two-dimensional collection of items (id and description)
>    colSelected is a one-dimension collection of ids of the selected items
> which is returned
>    boolResponse is boolean; if user cancels form then false; otherwise, true
> and colSelected contains selected items

> I want this function to be as generic as possible so that it can be used in
> different applications.

> Can you get me started?

> Thanks in advance.



Mon, 28 Oct 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Canned AcctReceivable Module needed!

2. Canned pages....

3. Cans access2.0 engine access btrieve files?

4. Crystal Reports Canned Code

5. Canned objects and/or images

6. Switching from inhouse software to canned package.

7. line graph in vb (canned routine)

8. 'Canned' data in VB program

9. Looking 4 Canned Control

10. VBA - Create Outlook Profiles - Can it be done!

11. ADO thinks DBMS is done, but DBMS ain't done

12. Importing a MS Access form to a VB Project can it be done

 

 
Powered by phpBB® Forum Software