Access2002 & VBA

  • Thread starter Thread starter RoMi
  • Start date Start date
R

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
 
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.
 
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
 
Ken Snell said:
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.
Click to expand...
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
 
k3dragon said:
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
Click to expand...

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 said:
news:[email protected]...
Click to expand...
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
Click to expand...
O.K.now.
 
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
 
Steve Schapel said:
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
Click to expand...

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.
 
Back
Top