Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 June 1st, 2004, 08:01 AM
Registered User
 
Join Date: Jun 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default All rows in a table when in forms

I have two tables, tblCustomer and tblJob, with many jobs to one customer. tblJob contains JobNo and CustomerID which relates to a field of the same name in tblCustomer. All the fields are Numbers. I have a form to maintain each table. On the job form I have a Command button to add a job, but I cannot see all the job numbers in use because they’re restricted to the jobs for the current customer, which is open in a form in the background. How do I see ALL the job numbers in use please?
Regards,
Nigel.
 
Old June 2nd, 2004, 09:21 AM
Friend of Wrox
 
Join Date: Jun 2003
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

If you want the jobs in the subform to reflect all jobs and not just the one for that customer, you must go to the properties of the subform (in design view) and remove any parent/child links from the form to the subform.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 2nd, 2004, 03:48 PM
Registered User
 
Join Date: Jun 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by SerranoG
 If you want the jobs in the subform to reflect all jobs and not just the one for that customer, you must go to the properties of the subform (in design view) and remove any parent/child links from the form to the subform.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 2nd, 2004, 03:52 PM
Registered User
 
Join Date: Jun 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your contribution, but I didn't make it clear what I wanted. I want to add a new job with a new jobNo that's not been used before by any other customer, and for that I have to 'see' jobs regardless of customer. The other alternative, I suppose, is to keep the last used jobNo in a master table then the next jobNo would be 'last_used_jobNo + 1' each time. Generally speaking, the relationship between customer and jobNo is useful to show what I did for whom. Hope that makes sense. Nigel.





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to move rows in a table bucky483 Javascript How-To 10 March 27th, 2017 12:57 AM
insert rows into the same table nik SQL Server 2000 1 October 26th, 2005 07:28 AM
Comparing certain rows in one table MrHicks Access 2 November 8th, 2004 04:00 PM
creating a table and inserting rows. sasidhar79 Classic ASP Databases 2 July 28th, 2004 03:09 AM
Q:Read two rows from table LegoMan ASP.NET 1.0 and 1.1 Basics 4 October 14th, 2003 01:22 PM





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