By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,462 Members | 2,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,462 IT Pros & Developers. It's quick & easy.

Access 2003 pivot-table view gone?!?

P: n/a
Ok. I upgraded to MS Access 2003 recently and now I am having great
heartache.

In Access 2002, when I opened a table to view the data, there were
wonderful little "plus" signs that I could click on for each record
that would open up the corresponding record in any linked table. I
could drill down and edit/add records in a most efficient and simple
manner.

In Access 2003, this is GONE! ARGHH!
It is a great pain now opening table one, looking at the ID field,
opening table two, finding the right record, looking at the ID field,
opening table three, finding the corresponding record, edit it.

With the amount of data I deal with, the table layout was ideal rather
than a form or a query that I have to re-run for each record I need to
work on.

Is there a way to turn this feature back on? Or can I create a
pivot-table view that will do this? I have been playing with the
pivot-table views, but the concept hasn't "clicked" with me yet.

Brian Andrus
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi Brian,

Not sure why the wonderful little "plus" signs disappeared, but the correct name for these
is Subdatasheets. A table property allows one to set the Subdatasheet to [None], but it
doesn't sound like you did this. Perhaps you changed a table name and the NameAutocorrect
feature either didn't work or wasn't selected? I don't have Access 2003 available, but it
shouldn't be too hard to reestablish your subdatasheets. With a table open in datasheet
view, click on Insert > Subdatasheet... Pick the related table from the list. You can
also pick a saved query. This allows you to specify a different sort order for the
expanded records, when you click on the plus signs. The primary & foreign keys are
specified in the Link Master Fields and Link Child Fields textboxes, respectively.

Tom

Note: If you ever split your database, and place the back-end on a file server, I
recommend setting Subdatasheets to [None] and disabling NameAutocorrect for starters.

_____________________________________________

"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...

Ok. I upgraded to MS Access 2003 recently and now I am having great
heartache.

In Access 2002, when I opened a table to view the data, there were
wonderful little "plus" signs that I could click on for each record
that would open up the corresponding record in any linked table. I
could drill down and edit/add records in a most efficient and simple
manner.

In Access 2003, this is GONE! ARGHH!
It is a great pain now opening table one, looking at the ID field,
opening table two, finding the right record, looking at the ID field,
opening table three, finding the corresponding record, edit it.

With the amount of data I deal with, the table layout was ideal rather
than a form or a query that I have to re-run for each record I need to
work on.

Is there a way to turn this feature back on? Or can I create a
pivot-table view that will do this? I have been playing with the
pivot-table views, but the concept hasn't "clicked" with me yet.

Brian Andrus
Nov 12 '05 #2

P: n/a
Tom,
Thanks for the terminology correction. It helps.

What I have found is that in Access 2003 you cannot insert
subdatasheets in linked tables! At least that appears to be the case.
Insert->Subdatasheet is greyed out on all linked tables.

Irritating thing is I can create a local copy of the primary table
(CustInfo) and insert subdatasheets to the child table (PayInfo). I
still cannot insert a subdatasheet in PayInfo to another child
(AccessType).

If anyone knows how to insert subdatasheets into linked tables in
Access 2003, please let me know!
Brian Andrus
batman(at)thundermail.com
"Tom Wickerath" <AOS168 AT @comcast DOT net> wrote in message news:<dd********************@comcast.com>...
Hi Brian,

Not sure why the wonderful little "plus" signs disappeared, but the correct name for these
is Subdatasheets. A table property allows one to set the Subdatasheet to [None], but it
doesn't sound like you did this. Perhaps you changed a table name and the NameAutocorrect
feature either didn't work or wasn't selected? I don't have Access 2003 available, but it
shouldn't be too hard to reestablish your subdatasheets. With a table open in datasheet
view, click on Insert > Subdatasheet... Pick the related table from the list. You can
also pick a saved query. This allows you to specify a different sort order for the
expanded records, when you click on the plus signs. The primary & foreign keys are
specified in the Link Master Fields and Link Child Fields textboxes, respectively.

Tom

Note: If you ever split your database, and place the back-end on a file server, I
recommend setting Subdatasheets to [None] and disabling NameAutocorrect for starters.

Nov 12 '05 #3

P: n/a
"Brian Andrus" <ba****@thundermail.com> wrote in message
news:ae**************************@posting.google.c om...
Tom,
Thanks for the terminology correction. It helps.

What I have found is that in Access 2003 you cannot insert
subdatasheets in linked tables! At least that appears to be the case.
Insert->Subdatasheet is greyed out on all linked tables.

Irritating thing is I can create a local copy of the primary table
(CustInfo) and insert subdatasheets to the child table (PayInfo). I
still cannot insert a subdatasheet in PayInfo to another child
(AccessType).

If anyone knows how to insert subdatasheets into linked tables in
Access 2003, please let me know!


As with all table design issues you need to open the file where the table
resides and make the changes there. The refresh your links.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #4

P: n/a
Problem is... they reside on a SQL server.

The subdatasheets showed up automatically when I upgraded to Access
2002. I liked them and got used to them. Never noticed that you cannot
insert subdatasheets in a linked table even in Access 2002. Now in
Access 2003, they weren't even automatically made.

<sigh>Oh well, I guess.

Brian Andrus
"Rick Brandt" <ri*********@hotmail.com> wrote in message news:<bs************@ID-98015.news.uni-berlin.de>...

As with all table design issues you need to open the file where the table
resides and make the changes there. The refresh your links.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.