it worked
thanks alot the example was exactly what i wanted to make. thank u very much:)
but i find some difficulty in doing that with three combo boxes. for example: i want to press on the company name in (combobox1) to see it's related employees in (combobox2), then i press on the employee to see his achievments in (combobox3)
so how can this be done ? i have 3 tables only 2 tables r connected with...
kurai hikari
Last Activity: Feb 2 '10, 07:25 AM
Joined: Oct 10 '09
Location:
-
is it possible in access to make asub combo box from amain combo box?
itis like menus and sub menus .
for example i have acombo box with 5 selections in it. and each selection has it's own 3 sub selections . now i want the sub selection appear when i click on the main selection in the combo box.and so on with the rest of the selections
is this can be done in access? -
good XD
yeah itis my mistake srry i should have made anew thread
thanks so much i gave ur answer to my boss and it was a valuable thanx if there is another question i will come to u defenitly :)Leave a comment:
-
Access Security
hay iam back . so itis shotokan too? weired i dk but here brown belt is 2 and 1 kius blue one is called 3kiu , green, orange 6 and 5 kiu, yellow 6 and 7 . that is the system here and shotokan too, but anyways itis just amartial art, and yap keep ur self strong :)
i have another question for u (told ya u won't get rid of me XD)
this time i don't have adata base or something complicated i just want to ask about the access programme... -
yeah
no here itis not 3 kius itis only 2 grades of brown belt then black yeh it wsan't easy my sensei( captain) is so cruel =( i think u learned another karate school style i learn shotokan style XD. and yes i got the first grade wich means i practice now for the black belt. don't stop training itis very usefull. =)Leave a comment:
-
it worked
it worked , i don't believe it it really worked finally when i press on the selection in opens the related report omg iam so happy , thank u thank u. hahahaha u r the best . u were right about the where condition , i didn't think itis the recordsource i thought itis the selection that i select to open the report. u r my hero . yes yes yes . yattaaaaaaa, yahooooo i made it no actually u made it thank u sooooo much so much....Leave a comment:
-
you just hit the right point
hay iam so sorry i was late in replying . i had no time at all to sit on my pc becouse of my karate training for the exam so sorry.
you just talked about value. i want to tell you this
i used that code in combobox1 code sub
and it worked but before the report...Code:DoCmd.OpenReport "Mj", acViewPreview, , "[managers]=" & Me![combobox1], acWindowNormal
Leave a comment:
-
XD easy , iam just a biggener girl but not for long =)
i understand u and i did from the start . i know that i have to make aconnection between the selection and the report but with my data base i didn't know how
and howcome i didn't say what i want i told many times that i want to select aselection from the combobox and then aspecific report opens i said that in all my posts already but i don't know how to do that or...Leave a comment:
-
ok the last try
i understood from your questions that you don't get my database at all. and no matter how much i explain and try to give you any details it won't work so here an example from my data base with access 2003 open it see it and answer all your questions.
you can answer your first question from the data base i sent you
but the second question is what iam asking...Leave a comment:
-
oh oO
iam so sorry i bothered you i appologize so much so sorry my friend iam just trying to satisfy my boss and iam so used to use the abbreviations and i really preview my reply before i submit it okay
you needed to know where my reports are stored ?
first i use access iam sorry i didn't tell you that before i thought you already know
so my reports are stored in reports in access and so are my forms are stored...Leave a comment:
-
we r making aprogress but i have an idea
what do u think if made it only one table wich means i will join the specialsation table and iti's fields to personalinforma tion table so that way i don't have to add afield or make any connections only one table will be the source of reports and my combobox and that is how my db will look like
prsonalinformat ion table with these fileds[firstname_ job_iD_section_ section2_number ofsection]...Leave a comment:
-
ok here is every thing in details i hope
okay iam gonna explain to u in details okay forget what i said earlier let's focus on this
i have 2 tables( personalinforma tion) table and (specialization) table
personal information table has these fields [firstname_ job_iD_section]
specialization table has these fileds[section_numbero fsection]
now i have a form in the form there is acombobox...Leave a comment:
-
iam quiet lost here?????
okay i didn't quiet understand all what u said but i want to say that in this db i have 3 tables and the relationship between them is one to many in access. and i have only one column in my combobox itis name is (career)
so what logic do u mean and what do u mean by the correct related data in my combobox? i need acode to put it in the combobox .so that when i select any selection from...Leave a comment:
-
How to structure an access database
i have a combobox from table( specialization)
and i have a reports from table (managers)
the combobox name is( combo1)
the selections in the combo box are
managersjob
governorsjob
presedentsjob
employeesjob
the reports i want to open are
mj
gj
pj
ej
now i want to select managersjob from the combobox then the report... -
what about 2 different tables?
ok but what if i have two tables for example : the combobox is from table1 and the report i want to open is from table2.i tried that code u wrote. but amsgbox appeares before the report shows asks me to enter aknown value ofcourse i don't know what to enter so i just press ok then the report shows up but with out data so can u help?
report i want to open is called(mana...Leave a comment:
No activity results to display
Leave a comment: