2003 subdatasheets

[Access_2003]

I am using 2003 and have curently split my database and
now when I open up a table in the front end I can not view
subdatasheets.. Can some please help?

 

[Tim Ferguson]

Can some please help?

Tables are strictly for storing data, and forms are for looking at and
editing them. Use a form.

HTH


Tim F

 

[Access_2003]

That still will not help my cause b/c I will not be able
to view subdatasheets that are associated with the table
relationships.

 

[Scott McDaniel]

You can setup your subdatasheets in the frontend by opening the table in
design view, rightclicking somewhere on the table and selecting "Properties"
.... from there it's pretty self-explanatory ...

However, Tim's advice is still solid, and there are definite performance
issues associated with the use of subdatasheets in a split application.
Remember that there is NO error handling associated with directly table data
entry. You can achieve the same thing using the traditional form/subform
setup.

 

[Tim Ferguson]

That still will not help my cause b/c I will not be able
to view subdatasheets that are associated with the table
relationships.

Anything you can do with a table datasheet you can do with a form, except
that with a form you have more control, you can help the user, you can
check for errors, you can hide or protect anything that needs it, you can
provide helpful defaults, and you can (cont page 94...)

Forms are not hard to design, and the wizards take away a lot of the work
for you. If you particularly like the grid layout, you can still create a
form that looks like it; and subforms are specifically designed to allow
drill-down type queries from the parent to child data.

You really are (a) doing your users a grave disservice in making them use
table sheets, and (b) putting the data themselves at risk too.

Best wishes


Tim F