Hi, im doing a college assignment using Access and i seem to have hit a hard rock thats getting in my way. I will explain my task solution in hope you may be able to explain the best way to do this:
A motorcycle workshop uses a paper based system to store their job records, each new customer has a job card, and returning customers have new job cards.
Some bikes come back with the same problem, but the sloution may have been forgoten, so i want a system that records each bikes problems and has notes on how it was repaired, this way, when a bike comes in with a common problem, a search can be made for same bikes with the same problem to cut back on time finding the problem.
Anyways, i hope this is making sense, so to enter the problem, i want a combo box that has options like: Mechanical, Electronic, Bodywork, Service, MOT. then once a field is selected the combo box below changes it values so if Mechanical was selected the next box would be: Engine, brakes, steering... etc.
If it was MOT, then the second would be: oil, plugs, full service, etc.
So basically like what insurance websites have when the car model combo box changes depending on the manufacturer.
If someone could explain how this is done i would be extremely grateful and i appologise if this is a repeat question (i have searched but i dont honestly know what im searching for), because im a mod on a sony psp forum and know how many n00b questions come up.
But as i said, any help would be awesome.
Kev
3 6222
Click here to learn more. The general concept is called Cascading Comboboxes.
Welcome to TheScripts!
Linq ;0)>
Dude, i cannot thank you enough, i thought i knew a fair amount about computers, i am a worthless nothing around you lol.
Cheers again.
*bookmarks page*
Umm, ok i have a problem now.
I have followed this tutorial as much as i could, but it dosent seem to be working.
Has anyone got a working version of this? If so could it be sent to me, or uploaded etc?
The first box is coming up with the company names i put in but the second is still showing all the employee names.
Thanks
Kev
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Dave |
last post by:
I wasn't sure how to search for previous posts about this, it felt
real specific. Ok so here's the database & problem:
I have 4 combo boxes: cboServer, cboPolicy, cboDB, and
cboApplication. ...
|
by: accesslearner |
last post by:
Hi!
I' m learning access, and now I have a problem. I have a form with two combo boxes, so that one is related on another. I found cases and I know how to do this, but I didn't found the code how...
|
by: Dave |
last post by:
I want to put the information that the user selects in my combo boxes
into a subform that lies on the same form as the combo boxes.
Thanks for your help already,
Dave
|
by: Dave |
last post by:
Hello all,
First I'd like to apologize...This post was meant to be put in my
previous post, but I tried many times without success to reply within
my previous post. Now here goes...
I have a...
|
by: Marianne160 |
last post by:
Hi,
I know there are various answers to this problem available on the web but none of them seem to work for me. I am using Access 2003 to make a form to look up data from a table. I have so far...
|
by: andi111 |
last post by:
Good Morning All,
I am having problems turning my Matter_Creation_Form.DOC into a Matter_Creation_Form.DOT.
Now,
Within Word, I have created a document that contains 2 Combo Boxes which,...
|
by: kmartinenko |
last post by:
Hi everyone,
I have several combo boxes on my form, and while I have designated a column head, I cannot figure out how to default to the column head value. What I really want is for all of my...
|
by: dudeja.rajat |
last post by:
HI,
I'm using a Tix combo box (I call it combo2), the contents of which
are loaded depeding on the selection in another Tix combo box(I call
it combo1)
I have used the commands:
...
|
by: dudeja.rajat |
last post by:
On Sat, Aug 30, 2008 at 2:32 PM, Fredrik Lundh <fredrik@pythonware.comwrote:
Fredrik, Thanks so much. That worked.
Following this, I can now see that my combo2 has no previous elements
and...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |