Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | 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 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 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
Reply With Quote
  #2 (permalink)  
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
Reply With Quote
  #3 (permalink)  
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
Reply With Quote
  #4 (permalink)  
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
Reply With Quote
  #5 (permalink)  
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
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
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



All times are GMT -4. The time now is 05:21 PM.


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