tick box filter to produce report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dance Vinyl Masters - 24 Jul 2005 13:49 GMT

I have a form that when a new product is created the tickbox called Print
Label is set to default to true and also have the ability to tick any
previous products just incase i need a label for restocks.

This tick box tells me that a ID label needs printing for the product. I am
wanting a form that acts as a filter so it will produce my labels from all
records that have a tick in the Print Label box.

I have managed to do this on a date created no problem but for some reason i
can't seem to get the tick box function to work. I have changed all
parameters that are required and i just keep getting the no data message.

Any help on this would be much appreciated..

PLease let me know if you require any other information.

Reply to this Message

Al Camp - 24 Jul 2005 14:33 GMT

DVM,
PrintLabel should be defined as a Yes/No field in your table.

>>I am wanting a form that acts as a filter

Since you have a form already that allows you to add/delete/edit
products, you don't need another form to produce the report you want.

>>I have changed all parameters that are required and i just keep getting
>>the no data message.

More detail in this regard would have been helpful... You shouldn't need
any PrintLabel "parameters" at all,
so I suspect this is your problem. Parameters for your DateField is OK, but
not needed for the PrintLabel criteria.

The query behind the form should be all you need to determine which
records will be selected for the report.
The PrintLabel field in that query shouldhave a criteria of
= True.
and that's all you need.
hth
Al Camp

>I have a form that when a new product is created the tickbox called Print
> Label is set to default to true and also have the ability to tick any
[quoted text clipped - 13 lines]
>
> PLease let me know if you require any other information.

Reply to this Message

Dance Vinyl Masters - 24 Jul 2005 14:44 GMT

Flipping heck of course it is.. Was looking to do it the complicated way...lol.

Thanks for that.

By the way do you know the code to globally set all the Print Label fields
back to False once i have printed the report. Just a simple button would be
good on a form.

Reply to this Message

Al Camp - 25 Jul 2005 23:39 GMT

I had a sneaking suspicion you'd be wanting that! :-)
A simple "Update" query run against the whole table will do the trick.
You'll set the criteria value of PrintLabel to = True, and the "update to"
value to = False.
hth
Al Camp

> Flipping heck of course it is.. Was looking to do it the complicated
> way...lol.
[quoted text clipped - 5 lines]
> be
> good on a form.

Reply to this Message

Dance Vinyl Masters - 26 Jul 2005 04:04 GMT

> I had a sneaking suspicion you'd be wanting that! :-)
> A simple "Update" query run against the whole table will do the trick.
> You'll set the criteria value of PrintLabel to = True, and the "update to"
> value to = False.
> hth
> Al Camp

Ahhh right.. I could do that yes but i wanted to make it simple for anybody
else to reset them.. I was thinking of a form that when a radio button or
tick box was clicked and then submitted using a button it would then reset
the values to false.. I havn't got a clue where to start on that at all..

I will do your way as a temp measure for sure and thanks for the
information.. Much appreciated.. However :)) lol do you think the above is
possible and if so how..

Cheers mate

Reply to this Message