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 4 3865
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
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.
"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
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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...
|
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 ?
...
|
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...
|
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...
| |
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...
|
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
|
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.,...
|
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....
|
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
|
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...
| |
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |