Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 4th, 2005, 07:10 PM
Authorized User
 
Join Date: Mar 2004
Location: , , Latvia.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default The little "plus" sign

Hello!

I'm creating an MS Access DB. I have two tables linked to each other so that one record in one table can relate to several records in the second table.

When I open the main table (the first one) as a datasheet and fill with some records, I get a very narrow additional column on the left with plus signs in it. If I click on one, a box opens with all the rows from the second table that are related to the particular record.

The problem is, I want to use the queries, but that plus sign doesn't appear for queries, only for tables.

Can someone, please, explain, how can I get them on my query, as they're very convenient?

Thanks!
Janis

Reply With Quote
  #2 (permalink)  
Old January 5th, 2005, 12:48 AM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

janise

The Plus signs you see is showing the relationship between the associated tables.

if you were to create a new query add the two relational tables you will see an automatic link between the two.

another note: when you want to graphically see how you are constructing your tables, queries and views

click on the menu bar and relationships. here you can see and or create your database by adding/creating tables and its relationships, queries and views. It is very useful when you need to see your table structure.

Jaime E. Maccou
Reply With Quote
  #3 (permalink)  
Old January 5th, 2005, 12:35 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Short Answer: You can't.

If you have a single record in the main table and two records in the other table, for example, the query will return two rows, so no need for the plus signs.

mmcdonal
Reply With Quote
  #4 (permalink)  
Old January 5th, 2005, 03:33 PM
Authorized User
 
Join Date: Mar 2004
Location: , , Latvia.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote: Short Answer: You can't.

If you have a single record in the main table and two records in the other table, for example, the query will return two rows, so no need for the plus signs.
Ow, that's bad. :(

I didn't put any columns from the other table, as I was hoping for the plus sign to show them when needed. It's not so convenient to have a separate row for each record from the other table, as all the data from the first table is doubled then. And if you enter the data in this view, you must enter it twice all the time; it's quite disturbing, even if you use [Ctrl]+['].

Thanks, Jaime, for the reply! Unfortunately simply adding the other table in the query's design view didn't help either.

Janis
Reply With Quote
  #5 (permalink)  
Old January 5th, 2005, 05:41 PM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Quote:
quote:Originally posted by janiseWhen I open the main table (the first one) as a datasheet and fill with some records,
Oh, in case you're in the habit of filling data directly into tables, this practice is considered a no-no. You should create forms to accomplish this task.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
  #6 (permalink)  
Old January 5th, 2005, 08:11 PM
Authorized User
 
Join Date: Mar 2004
Location: , , Latvia.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by SerranoG
 Oh, in case you're in the habit of filling data directly into tables, this practice is considered a no-no. You should create forms to accomplish this task.

And why is it considered so? It's very convenient. Easy to overview the data, you can see/edit the previous records, what you've entered recently, and if needed can easily scroll through the records.

AND there's that convenient plus sign. Can you get that in a form?

Janis

Reply With Quote
  #7 (permalink)  
Old January 6th, 2005, 09:16 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Quote:
quote:Originally posted by janise
And why is it considered so? It's very convenient. Easy to overview the data, you can see/edit the previous records, what you've entered recently, and if needed can easily scroll through the records.

AND there's that convenient plus sign. Can you get that in a form?
Yes, you can if you program the form correctly. If you're the only person using the database and you intend on keeping the number of records small, writing into a table is convenient and probably won't hurt anything. But for something shared or where there is lots of data, it's not good.
  • You can't do effective error trapping.
  • Validation of data is limited.
  • Formatting of data is limited.
  • You can't offer help to people readily.
  • Opening other tables and reports based on criteria is difficult.
Data integrity and reliability suffer. And that "convenient plus sign" is correctly handled using form and subforms.

It's just considered bad practice. Anyone else want to chime in?
Reply With Quote
  #8 (permalink)  
Old January 6th, 2005, 09:50 AM
Authorized User
 
Join Date: Mar 2004
Location: , , Latvia.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, there's planned to be quite a lot of data, but it's very simple (as you can see, only two tables necessarry (at least, I think so currently) with only a few fields in each), and it will supposedly filled (and used) by one person at a time.

But I'll take a look at the subform feature. I'm quite a beginner. ;)

Thanks,
Janis

Reply With Quote
  #9 (permalink)  
Old January 6th, 2005, 10:10 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Quote:
quote:Originally posted by janise
and it will supposedly filled (and used) by one person at a time.
Um... "one person AT A TIME"?! This means you're letting a group of people enter data. Yikes! It doesn't matter than they're doing it one at at time. You're asking for major data integrity loss.

I think you better get some training on forms and subforms... and quickly!

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How use plus sign ajabbabahalmigiriha C# 1 December 19th, 2006 01:04 AM
SIGN OUT PROBLEMS.. sarah lee ASP.NET 1.0 and 1.1 Basics 2 October 26th, 2006 10:27 AM
How do you know which page to go to after sign up bekim Classic ASP Basics 8 August 22nd, 2004 07:53 PM
Is it possible to sign a VBScript - Need help ssudhaiyer VBScript 1 September 5th, 2003 05:10 AM
how % sign use in asp mateenmohd SQL Server 2000 2 July 28th, 2003 06:56 AM



All times are GMT -4. The time now is 11:31 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.