Command Button in Datasheet View

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael - 25 Oct 2007 15:33 GMT

Hi Folks - I'd like to display a list of records in datasheet view. One of
the fields is a checkbox. I'd like users to select the records to print,
then click a command button that runs a report. I thought a form in
datasheet view with a command button in the form header would easily
accomplish this task. However, it looks like a form in datasheet view cannot
display a command button. Do you have any workarounds? Thanks.

Michael

Reply to this Message

benyod79 - 25 Oct 2007 15:40 GMT

Change Datasheet to Continuous Forms. Put the field labels in the form header
above the field's textbox, put all textboxes at the top of the detail section,
make all textboxes the same height, change the height of the detail section
to the height of the textboxes. BAM, you're done! Gives the appearance of
datasheet, but allows use of form header/footer.

>Hi Folks - I'd like to display a list of records in datasheet view. One of
>the fields is a checkbox. I'd like users to select the records to print,
[quoted text clipped - 4 lines]
>
>Michael

Reply to this Message

Michael - 25 Oct 2007 16:32 GMT

Awesome .... Thanks.

> Change Datasheet to Continuous Forms. Put the field labels in the form
> header
[quoted text clipped - 14 lines]
>>
>>Michael

Reply to this Message

Klatuu - 25 Oct 2007 16:05 GMT

Make your datasheet form a subform and put your command buttons on the main
form.

Signature

Dave Hargis, Microsoft Access MVP

> Hi Folks - I'd like to display a list of records in datasheet view. One of
> the fields is a checkbox. I'd like users to select the records to print,
[quoted text clipped - 4 lines]
>
> Michael

Reply to this Message