Using a view like the table datasheet on a form.

Newbie

I would like to display certain columns from a table on a form.

One of my columns that I want to show is a Yes/No field so that my
users can pick their players for a fantasy football week.

If they could use the table directly, the datasheet view allows them a
check box to set yes and no for the player in that row. However, I
don't want them to access the table directly.

I can't find a contol that will let me use the datasheet view on the
form.

Please tell me how to use the datasheet view on a form or what control
to use. Ideally, I would just like to have a Select statement for the
form that shows that shows the results like the datasheet table view.

Thank you.

Oct 8 '06 #1

Larry Linson

"Newbie" <xy******@yahoo.comwrote

Please tell me how to use the datasheet
view on a form or what control to use.
Ideally, I would just like to have a Select
statement for the form that shows that
shows the results like the datasheet
table view.

Using the Wizard, Create a Form containing all the columns you want to
display, in "Tabular View." Then in Design View of the Form, rightclick the
upper-most lefthand box, choose Properties, and on the Format tab of the
property sheet, set Default View to "Datasheet."

Larry Linson
Microsoft Access MVP

Oct 8 '06 #2

Newbie

On Sun, 08 Oct 2006 17:02:30 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

>
"Newbie" <xy******@yahoo.comwrote

Please tell me how to use the datasheet
view on a form or what control to use.
Ideally, I would just like to have a Select
statement for the form that shows that
shows the results like the datasheet
table view.

Using the Wizard, Create a Form containing all the columns you want to
display, in "Tabular View." Then in Design View of the Form, rightclick the
upper-most lefthand box, choose Properties, and on the Format tab of the
property sheet, set Default View to "Datasheet."

Larry Linson
Microsoft Access MVP

Thanks, Larry.

After I got it working, I wanted to put a button on the form, but when
I try to run the form, the button does not show up?

Can I use buttons with a datasheet view of a form?

Thanks.

Oct 9 '06 #3

Larry Linson

"Newbie" <xy******@yahoo.comwrote

After I got it working, I wanted to put a button on the form, but when
I try to run the form, the button does not show up?

Can I use buttons with a datasheet view of a form?

No. "Datasheet" means just that... display the information in datasheet
format. It might be a more useful feature if it would display the datasheet
in the detail section of the Form, along with the Form Header and Footer,
but that isn't the way it works.

That's why I haven't ever used that option, except to demonstrate that you
_can_. I create a form in continuous Form view ("tabular" per the Wizard)
and fiddle with the formatting in Design View until I get it sufficiently
compressed to show the data I want. Actually, I really don't ever get it
"nearly all the way" to Datasheet View, because my users appreciate a little
more separation between the Fields.

Larry Linson
Microsoft Access MVP

Oct 9 '06 #4

Arno R

"Newbie" <xy******@yahoo.comschreef in bericht news:sp********************************@4ax.com...

Can I use buttons with a datasheet view of a form?

What is wrong with a subform ??

Display your datasheet in a subform.
You can have all kinds of buttons in the form.

Arno R

Oct 9 '06 #5

phnz

Newbie wrote:

I would like to display certain columns from a table on a form.

One of my columns that I want to show is a Yes/No field so that my
users can pick their players for a fantasy football week.

If they could use the table directly, the datasheet view allows them a
check box to set yes and no for the player in that row. However, I
don't want them to access the table directly.

I can't find a contol that will let me use the datasheet view on the
form.

Please tell me how to use the datasheet view on a form or what control
to use. Ideally, I would just like to have a Select statement for the
form that shows that shows the results like the datasheet table view.

Thank you.

How about using a List Control with the multiselect propery set to
'simlpe'. You can define the columns you want to show and their width.
You can have meaningful titles for each column. The user can select the
rows they want by clicking om them and you can manipulate the result
they select in many ways. Just an idea i have used in some situations.

Phivos

Oct 11 '06 #6