Whats the best way of counting leaflets

Hi Group (fairly limited knowledge of Access and almost none of
Access
VBA. Using Access 2003).

My company give leaflets out when undertaking home visits. Each
leaflet type is to be recorded and counted. At present I'm using a
lookup table to provide a combo box with names of available leaflets.
This is fine from the point of view that new leaflets can be added to
those available and historical data integrity can remain.

The problem as I see it is that it is a cumbersome method of selection
compared to a tick box. Is it ok to go this route and have a field
for each leaflet type, I'm not sure if its a good idea or not.

Any help and advice is appreciated


Don

Re: Whats the best way of counting leaflets

In one visit, you can give out many leaflets.
I take it you have:
- one table to record the visits;
- a related table to record the leaflets given out on that visit.

It would be a very bad idea to dump the related table, and put a bunch of
check boxes in the Visit table. It will make it very hard to query, and you
will have to redesign your table (and your queries, forms and reports) every
time a new leaflet gets added.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
news:1194523112.863889.12680@e34g2000pro.googlegroups.com...
> Hi Group (fairly limited knowledge of Access and almost none of
> Access
> VBA. Using Access 2003).
>
> My company give leaflets out when undertaking home visits. Each
> leaflet type is to be recorded and counted. At present I'm using a
> lookup table to provide a combo box with names of available leaflets.
> This is fine from the point of view that new leaflets can be added to
> those available and historical data integrity can remain.
>
> The problem as I see it is that it is a cumbersome method of selection
> compared to a tick box. Is it ok to go this route and have a field
> for each leaflet type, I'm not sure if its a good idea or not.
>
> Any help and advice is appreciated
>
> Don

Re: Whats the best way of counting leaflets

If you do not have too many different leaflets for the space available, you
could use a List Box instead of a Combo, with all the leaflets shown. Check
Help on Multi-Select in re: List Boxes -- that might be just as easy as
having radio buttons or check boxes; just click the name of the leaflet you
gave out as you would have clicked the button or box beside the name.

Larry Linson
Microsoft Access MVP

wrote in message
news:1194523112.863889.12680@e34g2000pro.googlegroups.com...
> Hi Group (fairly limited knowledge of Access and almost none of
> Access
> VBA. Using Access 2003).
>
> My company give leaflets out when undertaking home visits. Each
> leaflet type is to be recorded and counted. At present I'm using a
> lookup table to provide a combo box with names of available leaflets.
> This is fine from the point of view that new leaflets can be added to
> those available and historical data integrity can remain.
>
> The problem as I see it is that it is a cumbersome method of selection
> compared to a tick box. Is it ok to go this route and have a field
> for each leaflet type, I'm not sure if its a good idea or not.
>
> Any help and advice is appreciated
>
>
> Don
>

Re: Whats the best way of counting leaflets

On 8 Nov, 13:49, "Allen Browne" wrote:
> In one visit, you can give out many leaflets.
> I take it you have:
> - one table to record the visits;
> - a related table to record the leaflets given out on that visit.

Yes I do.

Thanks for your thoughts I agree. I shall have a look and see if a
multi select list box as Larry suggests will work for me.

Thanks to you both for your replies.

Don