Access2002 & VBA

[RoMi]

How could I put a Datasheet on a Form? I shold like to use some buttons for
navigation instead of the standard Access commands like File/Close, Exit...

Is there any better solution? My users are confused when they do not see any
button controls.

Thanks

 

[Ken Snell]

You can use the Datasheet view for the form. Open the form in Design view,
open the Properties window (tool bar icon), click on Format tab, and then
change Default View to Datasheet.

 

[k3dragon]

1) Make form object ("subForm1") and set the default view to datasheet.
2) Make a blank main form and put buttons for navigation to Footer and
insert the "subForm1" to detail section.

To navigate the subform:

Me![subForm1].Form.Recordset.MoveNext

OR ...

With Me![subForm1].Form
.RecordsetClone.MoveNext
.BookMark = .RecordsetClone.BookMark
End with

 

[RoMi]

You can use the Datasheet view for the form. Open the form in Design view,
open the Properties window (tool bar icon), click on Format tab, and then
change Default View to Datasheet.

But this is the same thing I alredy have - Datasheet View and not a
Datasheet on a Form. I need a Form to place additional Command Buttons.

Thanks

 

[RoMi]

1) Make form object ("subForm1") and set the default view to datasheet.
2) Make a blank main form and put buttons for navigation to Footer and
insert the "subForm1" to detail section.

To navigate the subform:

Me![subForm1].Form.Recordset.MoveNext

OR ...

With Me![subForm1].Form
.RecordsetClone.MoveNext
.BookMark = .RecordsetClone.BookMark
End with

Thank you. I just didn't know that one can use a SubForm on a Form for a
Datasheet View. This is what I wanted.

If you don't mind, please, explain me why I do not see a Command Button on a
PageFooter Section while the button on a subform is visible? I should
prefere a Button on a PageFooterSection. It's properties seems to be O.K.
(always visible, ...).

Best regards

 

[RoMi]

news:[email protected]...

If you don't mind, please, explain me why I do not see a Command Button on a
PageFooter Section while the button on a subform is visible? I should
prefere a Button on a PageFooterSection. It's properties seems to be O.K.
(always visible, ...).

Best regards

Sorry. The CommandButton must be placed on the FormFooterSection. It's

O.K.now.

 

[Steve Schapel]

RoMi,

Sorry, you can't put command buttons on a datasheet. You need to use
a form in "continuous" view. If you really like the look of
datasheets, the continuous form can be formatted to look pretty much
like a datasheet.

- Steve Schapel, Microsoft Access MVP

 

[RoMi]

RoMi,

Sorry, you can't put command buttons on a datasheet. You need to use
a form in "continuous" view. If you really like the look of
datasheets, the continuous form can be formatted to look pretty much
like a datasheet.

- Steve Schapel, Microsoft Access MVP

Thanks for understandings. For now I am quite satisfied with the subforms in
a datasheet view. The same thing with a continuous form I'll check later.

Best regards.