473,722 Members | 2,337 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2003 pivot-table view gone?!?

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
4 3873
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****@thunder mail.com> wrote in message
news:ae******** *************** ***@posting.goo gle.com...

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
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)thund ermail.com
"Tom Wickerath" <AOS168 AT @comcast DOT net> wrote in message news:<dd******* *************@c omcast.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
"Brian Andrus" <ba****@thunder mail.com> wrote in message
news:ae******** *************** ***@posting.goo gle.com...
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
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*********@ho tmail.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
9934
by: Charles Law | last post by:
I have posted this on a couple of Access and SQL Server newsgroups, but with no answer yet. There seems to be very little activity on the ones I have looked at, so I thought I would post here as well, since I have no doubt that many people here also use Access/SQL Server. Anyway, enough of my rambling and on with the problem/question. I have two queries that I use in Access: <qrySelect> SELECT table2.column1, table2.column2,...
10
5590
by: Mark Day | last post by:
Hi All, I am using Access 2000 to generate over 40 Excel charts and pivot tables using early binding to the Excel 9.0 object library. I am finding that if I show the Excel object while processing the charts, the whole process completes in around 2 minutes. However if I hide the Excel object the same process takes around 27 minutes to complete. I have played around with screen updating and this makes no real difference to the time. Does...
1
1371
by: richmarin | last post by:
I am using VB 6 and Access97. I need to do the following job. I need the ability to create cross tabs on the fly while in VB6. The important thing is that I must control which column is first and where the total column is. What columm lands where is all important. Any suggestions on how to do this ? ...
1
4131
by: Johnny Meredith | last post by:
Dear All, I have an Access database that tracks the progress of income tax audits. When the taxing authorities make a change (an "Adjustment"), I record the pertinent information in the database. At the end of the audit cycle, these adjustments are used to compute the revised taxes due. This computation is done in a fairly complex, but accurate and easy to use, spreadsheet. In the spreadsheet, there is a sheet that lists out all...
18
7340
by: Andre Laplume via AccessMonster.com | last post by:
I have inherited a bunch of dbs which are are shared among a small group in my dept. We typically use the dbs to write queries to extract data, usually dumping it into Excel. Most dbs originated in MsAccess 97 or prior and have been converted to 2003. On occassion user 1 will open a db. When user 2 opens the db it will not let user 2 modify macros and what not. I can understand this and realize we could split the db; it is not worth ...
2
3111
by: Carl Gilbert | last post by:
Hi I have a math kinda problem where I'm trying to split some lines when two or more lines connect two shapes. The reason I am doing this is to make it clear that there are multiple lines connecting the two shapes. http://www.blackwaterbadgers.co.uk/image1.bmp Image 1 shows how if you have a line between two shapes, the line is straight. if you have more than one line, the lines will start overlapping
3
2397
by: Decreenisi | last post by:
Hi, I have to convert an existing spreadsheet for rejects into an access database. My problem is I use a load of lookup tabels in excel. How do I approch this in access. Also, just a general question, can you do pivot tables in access. Thanks
1
2881
by: keliie | last post by:
Hello, I've created a form that contains a single unbound combo box and two subforms. The two subforms display the results of a query (driven by the combo box selection) in both tabular and pivot chart formats. The problem that I'm having is that the Pivot Chart that I've created rounds all of the values down to the nearest integer (e.g., 1.9 is rounded to 1.0, 0.6 is rounded to 0). As you can guess, this is a serious issue when I'm...
2
3333
by: VitorCastro | last post by:
Hello... First, sorry for my bad english... i have generated many pivot tables in Access 2003. and i want the code to export all of them to one single excel sheet and specific cell. i have little knowledge about this export function. i have generated many reports in excel, and save the sheet for information that pivot tables in access. with information in the specifici sheet and specific cell, e generated automatically the reports.. ...
0
1637
by: Demosthenis | last post by:
I am having a form with a pivot chart. What I would like to do is for the chart title to take values according to the selection I am making (criteria) and not be static. Any ideas? Demosthenis
0
8861
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8739
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9383
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9236
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8051
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6681
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4502
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4762
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2601
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.