Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-05-2019, 05:03 PM   #16
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 2,137
Thanks: 3
Thanked 466 Times in 459 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: A query to call in VBA

Quote:
In my carsOwners table I have a complete list of all owners and cars without repeating.

The complete listing of all owners is in tbl_Customers, no? You have set up your database properly. My point is that your current tbl_CarsOwners has information about the cars, one of which is OwnerID and the owner details are in tbl_Customers.


Anyhow, at the end of the day, it's your database and you can call your tables anything you want.

Cronk is offline   Reply With Quote
Old 09-05-2019, 05:34 PM   #17
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,382
Thanks: 87
Thanked 1,648 Times in 1,530 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: A query to call in VBA

Quote:
I am still defending what I have now because a car always has a unique license plate
Just for clarity...

Does your table only apply to sold vehicles? Because in Louisiana, a car still sitting on the dealership floor doesn't have a license plate - but ALL vehicles have a VIN.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
silversun (09-06-2019)
Old 09-06-2019, 07:45 AM   #18
silversun
Newly Registered User
 
Join Date: Dec 2012
Posts: 53
Thanks: 25
Thanked 0 Times in 0 Posts
silversun is on a distinguished road
Re: A query to call in VBA

@ The_Doc_Man
Yes. They are the customers who bring their car to a shop for oil change or services. After a while when more data has been collected then mechanic person can find a customer's name from a combo box and then will see list of the cars that customer has brought to the shop. He clicks on one of the listed cars then stores the carsOwners_ID in tbl_services when submit the form. This way I will have all I want to know about a service, car and its owner.

silversun is offline   Reply With Quote
Old 09-06-2019, 07:46 AM   #19
silversun
Newly Registered User
 
Join Date: Dec 2012
Posts: 53
Thanks: 25
Thanked 0 Times in 0 Posts
silversun is on a distinguished road
Re: A query to call in VBA

@ Cronk
Thank you for your comments.

silversun is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help: Static shell function call works, but dynamic call fails tranchemontaigne Modules & VBA 5 09-04-2013 12:10 PM
How to set call serial number according to call date and time naveen4pundir Queries 2 04-28-2012 04:07 AM
Call Call Audit_Trail Ambigious Error fenhow Modules & VBA 6 07-27-2007 08:26 AM
how to call a public function? call in a query? alienscript Queries 1 09-04-2004 06:49 AM
call (run) a query using VBA ghudson Queries 2 01-08-2003 07:00 PM




All times are GMT -8. The time now is 10:30 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World