[AccessD] Make Multiple Selections on a Form and Create a Recordfor Each

Drew Wutka DWUTKA at Marlow.com
Fri Feb 27 17:42:35 CST 2009


Ok Tina, I put the sample at http://www.marlow.com/treeview.zip

Going to take a break for a minute, and I'll come back and post an
explanation of how it works.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Friday, February 27, 2009 4:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Make Multiple Selections on a Form and Create a
Recordfor Each

Hi Drew,
No, I'm not at all averse to using it - I just don't know much about how

to.  Would you care to expand on the subject?
Tina

Drew Wutka wrote:
> Tina, are you averse to using a treeview control?
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> tinanfields at torchlake.com
> Sent: Friday, February 27, 2009 12:22 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Make Multiple Selections on a Form and Create a
> Recordfor Each
>
> I hope the subject line isn't too confusing :)
>
> Here's the situation:  volunteers fill out a paper form indicating
which
> skills they have and at 
> what level (1 to 3, with 1 being high).  When this database was built
> (1999), the developer crafted 
> a macro that added one record for every possible skill (32, so far) to
> the table of volunteers and 
> skills.  The data-entry person then went down the rows, clicking the
> ones that were to be selected, 
> and entering the skill level number.  This results in lots of empty
> records.  Since then, the 
> database crashed and the macro no longer works anyway.
>
> I want to craft a form with a checkbox for each skill and a drop-list
of
> the skill-levels, so the 
> data-entry person can click the checkbox and select the skill level -
> then click a button that will 
> place one record for each skill selected into the table of volunteers
> and skills.  This gives the 
> data entry person the same ease of entry, but does not create lots of
> empty records.  I saw 
> something in the ADH that captures the number of selections made, and
> I'm guessing I need to start 
> there, but I could sure use some inspiration on this.  If three skills
> are checked, I want three 
> records entered for that volunteer in the volunteers and skills table
-
> each one referencing one of 
> the selected skills.  
>
> Thanks for any ideas.
>
> Tina
>
>
>   
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.





More information about the AccessD mailing list