Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Access 2003 VBA Programmer's Reference
This is the forum to discuss the Wrox book Access 2003 VBA Programmer's Reference by Patricia Cardoza, Teresa Hennig, Graham Seach, Armen Stein; ISBN: 9780764559037
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Access 2003 VBA Programmer's Reference section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 15th, 2005, 10:32 AM
Authorized User
 
Join Date: Jul 2004
Location: Coimbatore, Tamilnadu, India.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to pannet1 Send a message via Yahoo to pannet1
Default SQL Problem

Dear Patricia,

I am not sure if I can ask this here. I have several tables for my new project. I have had several one-many relationships. Somehow there is a relationship between tables which is one-one i guess. I have not created this relationship, may be, access created this automatically since this relationship is trasitive.

When i include the one side table of the relationship my query does not output any recordset. however, i was once able to use these tables for my query recordset.

i want to know whats is the way to resolve this problem. should i use sub query or its possible to use vba and generate the query recordset which inturn would be the recordsource for my form.

thanks in anticipation.

br karthick
__________________
CJBGUY
 
Old April 15th, 2005, 11:19 AM
Authorized User
 
Join Date: Jul 2004
Location: Sydney, NSW, Australia.
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If the tables are linked by the same field, you will always get a 1-to-1 relationship. Add a different primary key to the right-hand table, to get 1-to-many.

This kind of question (unrelated to the book) should be directed to the appropriate forum. I suggest posting such future questions to the Microsoft product-specific newsgroups. See the following page for instructions on how to connect to the Microsoft newsgroups.

http://www.pacificdb.com.au/MVP/newsgroup.htm

Graham R Seach
Microsoft Access MVP
 
Old April 15th, 2005, 09:23 PM
Authorized User
 
Join Date: Jul 2004
Location: Coimbatore, Tamilnadu, India.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to pannet1 Send a message via Yahoo to pannet1
Default

Dear Graham,

You're right that its not about any specific chapter from the book. However, my question is specifically about VBA.

I am aware of how to create relationship. The problem is this relationship does not appear in the relationship window but appears only the QBE. I have almost completed my project with this bug.

Reg the newsgroup I am unable to connect news.microsoft.com. Outlook express returned the following error.

Configuration:
   Account: news.microsoft.com
   Server: news.microsoft.com
   Protocol: NNTP
   Port: 119
   Secure(SSL): 0
   Code: 800ccc0e

Need your support.

Best Regards
B Karthick
 
Old April 16th, 2005, 07:02 AM
Friend of Wrox
 
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi B Karthick,

PMJIH. Actually there are a number of active forums right here in Wrox P2P. Among them is "Access VBA" http://p2p.wrox.com/access-vba-80/

Should you decide to post your question there, I would recommend you be more complete in your description of the problem. Specifically, I would suggest that you provide the SQL statement you are executing that returns no rows.

FWIW, Access will automatically create relationships between tables if you use the "Lookup Wizard..." when you are defining a field in a table. However, without seeing your SQL Statement I cannot say whether this created your problem or not.

Additionally, any relationships that Access may create behind the scenes will not automatically show in the Relationships form. To see all relationships that exist, open the Relationships form and from the menu select "Relationships" then "Show All".

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org
 
Old April 16th, 2005, 10:03 PM
Authorized User
 
Join Date: Jul 2004
Location: Coimbatore, Tamilnadu, India.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to pannet1 Send a message via Yahoo to pannet1
Default

Dear Graham,

Thank you very much for your patience with me and your prompt reply. My query now returns recordsets but only after deleting the autojoined relationship line.

I guess, I have seen the all relationships, after deleting the join line in the QBE and thats why it did not appear. I will use your reply as the check list for troubleshooting if my query did not work again.

With your help, now I have a completed project. Thanks once again.

Best Regards
B Karthick




Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL problem MArk_dB BOOK: Beginning ASP 3.0 1 December 16th, 2007 07:33 AM
sql problem shrisangeeta Classic ASP Databases 2 May 24th, 2006 09:58 AM
SQL problem Lexus SQL Language 2 January 20th, 2005 09:25 AM
SQL problem Clive Astley Access VBA 4 October 19th, 2004 10:42 AM
SQL Problem tjw Access 1 November 12th, 2003 09:22 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.