What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » Please Help - MS Access

Pages: (2): « First [ 1 ] 2 » Last »
Please Help - MS Access
Author: Message:
M73A
Veteran Member
*****

Avatar


Posts: 3213
Reputation: 37
34 / Male / Flag
Joined: Jul 2004
O.P. Please Help - MS Access
can anyone tell me how you make a drop down box (using look up wizard) that when u select a certain one gives u certain fings to choose from in a diferent field ....a bit like a tree diagramm


nokia - model1
            model 2
Panasonic -
                    model XV
                    model XC


(nokia and panasinoic being the choices in the first drop down box) and (model ** being the answers for selecting nokia or panasonic)


sorry if this is confusing

[Image: lost7ru.gif]
09-28-2004 04:56 PM
Profile E-Mail PM Find Quote Report
DJeX
Veteran Member
*****

Avatar


Posts: 1138
Reputation: 11
– / Male / –
Joined: Jul 2003
RE: Please Help - MS Access
Google Search: http://www.google.ca/search?hl=en&ie=UTF-8&q=Java...down+menus&spell=1

Site From Google Search: http://www.searchbliss.com/webmaster_tools/javamenu.htm    (Y)

This post was edited on 09-28-2004 at 10:56 PM by DJeX.
[Image: top.gif]
09-28-2004 10:55 PM
Profile PM Web Find Quote Report
M73A
Veteran Member
*****

Avatar


Posts: 3213
Reputation: 37
34 / Male / Flag
Joined: Jul 2004
O.P. RE: Please Help - MS Access
thanks but dont seem to help.....is there like a button or a wizard in ms access where u can do this?

[Image: lost7ru.gif]
09-29-2004 06:26 AM
Profile E-Mail PM Find Quote Report
RaceProUK
Elite Member
*****

Avatar

Posts: 6073
Reputation: 57
39 / Male / Flag
Joined: Oct 2003
RE: Please Help - MS Access
You could try using VBA.
When you change the selection in the first, it fires an event. In this event, repopulate the second listbox with the relevant items.
[Image: spartaafk.png]
09-29-2004 09:58 AM
Profile PM Web Find Quote Report
CookieRevised
Elite Member
*****

Avatar

Posts: 15517
Reputation: 173
– / Male / Flag
Joined: Jul 2003
Status: Away
RE: Please Help - MS Access
quote:
Originally posted by DJeX
Google Search: ......
Site From Google Search: ......
Javascript hasn't got anything to do with this...
quote:
Originally posted by raceprouk
You could try using VBA.
You even don't need VBA to do this ;)

----

hint: All you need to do is creating the dropdown menu and let it depend on a query which takes its input from the first dropdownbox. Nothing needs to be programmed as this is a basic Access database thingie; this can easly be done by Access itself and some wizard (lookup wizard or whatever, it has been a while since I worked in access and I don't know all the menu's, etc from the top of my head and I haven't got it installed atm to show you)...

This post was edited on 09-29-2004 at 10:36 AM by CookieRevised.
.-= A 'frrrrrrrituurrr' for Wacky =-.
09-29-2004 10:34 AM
Profile PM Find Quote Report
M73A
Veteran Member
*****

Avatar


Posts: 3213
Reputation: 37
34 / Male / Flag
Joined: Jul 2004
O.P. RE: Please Help - MS Access
i NEED this in ms access, do u no the name of this function? thanks cookierevised.....

[Image: lost7ru.gif]
09-29-2004 05:13 PM
Profile E-Mail PM Find Quote Report
CookieRevised
Elite Member
*****

Avatar

Posts: 15517
Reputation: 173
– / Male / Flag
Joined: Jul 2003
Status: Away
RE: Please Help - MS Access
erm, it isn't a single function... it is just basicly how access works....
When you add a dropdown on a form (and you have the wizard thingie on) it will ask you from where you want to get the input:
1) use a table/query/whatever (<= what you need to select)
2) type the input yourself (as in make your list right now)

As I said, it is a bit complicated to explain in words. Maybe you should try and find a tutorial of Access on the web. Or a book in the library. Because working with queries, rerouting the output, using tables, etc.. that's all basic Access stuff...

I'm sorry I can't help you more...

This post was edited on 09-29-2004 at 05:21 PM by CookieRevised.
.-= A 'frrrrrrrituurrr' for Wacky =-.
09-29-2004 05:20 PM
Profile PM Find Quote Report
M73A
Veteran Member
*****

Avatar


Posts: 3213
Reputation: 37
34 / Male / Flag
Joined: Jul 2004
O.P. RE: Please Help - MS Access
i fink i get it...kinda, thanks a lot...its cleared a lot of crap up

[Image: lost7ru.gif]
09-29-2004 05:22 PM
Profile E-Mail PM Find Quote Report
toddy
Veteran Member
*****

Avatar
kcus uoy

Posts: 2573
Reputation: 49
– / Male / Flag
Joined: Jun 2004
RE: Please Help - MS Access
make a new form in design view.
select combo box.
draw in the box where you want it
the wizard will come up and ask if u want to look up the values from a table.
slect yes and then tell it which table to look up.


then to make your second drop down box, u will need to create a relationship between the two table, so that it knows which values to look up.

how this helps !!!! if it doesn't then i will try explain it better later. busy atm and don't have access to access.
09-29-2004 05:24 PM
Profile PM Find Quote Report
M73A
Veteran Member
*****

Avatar


Posts: 3213
Reputation: 37
34 / Male / Flag
Joined: Jul 2004
O.P. RE: Please Help - MS Access
THANKS LOADS toddy....im reli new to this and need it for coursework.....so nefing ne1 knows is helpful!

[Image: lost7ru.gif]
09-29-2004 05:36 PM
Profile E-Mail PM Find Quote Report
Pages: (2): « First [ 1 ] 2 » Last »
« Next Oldest Return to Top Next Newest »


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On