RE: Design Questions

Awesome thank U!

"Clifford Bass" wrote:

Hi,

For question 1, you would create a couple of join tables.

tblVehicleHarnesses
VehicleID
HarnessID
Other pertinent information related to this combination

tblVehicleKits
VehicleID
KitID
Etc.

For question 2, you can use each combo boxes's Row Source properties
and On Change events to populate the succeeding combo boxes.

So the row source for the model combo box on a form named "MyForm" that
also has a make combo box named "cbMake" might be something like:

SELECT Model FROM tblModels WHERE Make = [Forms]![MyForm]![cbMake] ORDER BY
Model;

And the make combo boxes on change event might look like this:

Private Sub cbMake_Change()

cbModel.Requery
' Select the first item in the repopulated list
cbModel.Value = cbModel.Column(0, 0)
' You probably would want to clear out any combo boxes that are
dependent on the model such as trim line, year, engine size, etc.

End Sub

That should get you going in the needed direction.

Clifford Bass

"down in flames" wrote:

I am starting what at first looked like a fairly simple project but I am
hitting some walls that I need some help with. What I am trying to do is
take several excel part number (by vehicle) listings and combining them into
one application in Access. The end users would enter vehicle make, model and
year via drop down boxes then would be shown which part numbers (across
several product lines) fit that specific vehicle.

I have started small by creating 3 tables:

tblVehicleInfo: Contains make, model, year info
tblHarness: Listing of part numbers for wiring kits
tblKits: Listing of part numbers for installation kits

I have entered data into all of the tables and they all use an autonumber
primary key. I am not sure if this is the best way to do it but it seemed to
make sense. The next step is where I have a few questions:

1) tblHarness and tblKits are product lines, how do I associate the part
numbers in these tables to specific vehicles? Almost every part number in
these tables would be listed for more than one vehicle.

2) When creating the drop down form to test the interface, how can I make it
"cascade" to only show entries applicable to the previous drop down. ie If
you select BMW in the "make" drop down box, only BMW models show up in the
"model" drop down box?

I have been using Excel for these types of projects for many years but I
think Access will provide a more space friendly approach if I can get a
handle on these types of basics. Any help would be appreciated.
.

Relevant Pages

  • RE: Design Questions
    ... "Clifford Bass" wrote: ... tblVehicleHarnesses ... And the make combo boxes on change event might look like this: ... take several excel part number (by vehicle) listings and combining them into ...
    (microsoft.public.access.gettingstarted)
  • RE: Design Questions
    ... tblVehicleHarnesses ... And the make combo boxes on change event might look like this: ... take several excel part number (by vehicle) listings and combining them into ... Listing of part numbers for installation kits ...
    (microsoft.public.access.gettingstarted)
  • Re: Todays Metro
    ... |>> Which is one reason why advanced stop boxes without separate phasing ... Even if the advanced stop boxes are the recommended length, ... you need to pull in front of a vehicle that is stopped in a queue. ... and risk being run over by the lorry turning ...
    (uk.rec.cycling)
  • Re: check boxes
    ... I select my client from the drop down list, and then that specific client's vehicle reg details appear in the "VehicleReg" drop down list, where i choose a vehicle. ... This works well, but then if for example I would like to add new vehicle details for the selected client on the "jobs" form, I click on the "add vehicles" button which takes me to the vehicles for that specific client. ... For example, if you have 30 check boxes, then for every record ...
    (microsoft.public.access.forms)
  • Re: Just saw Cars on Blu-Ray... now *THIS* is what high-definition should look like!
    ... there's a larger capacity disc.>> ... certain number of baseballs. ... Let's say you have a vehicle that's ... storing boxes of baseballs. ...
    (alt.games.video.xbox)
Loading