Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / December 2003

Tip: Looking for answers? Try searching our database.

2003 subdatasheets

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Access_2003 - 15 Dec 2003 16:14 GMT
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 - 15 Dec 2003 17:30 GMT
> 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 - 15 Dec 2003 18:22 GMT
That still will not help my cause b/c I will not be able
to view subdatasheets that are associated with the table
relationships.

>-----Original Message-----
>
[quoted text clipped - 8 lines]
>
>.
Scott McDaniel - 15 Dec 2003 21:50 GMT
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.

> That still will not help my cause b/c I will not be able
> to view subdatasheets that are associated with the table
[quoted text clipped - 15 lines]
> >
> >.
Tim Ferguson - 16 Dec 2003 17:03 GMT
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.