Search results

yes kindly look to the database and tell me what i miss and there's error appears when i try to select value from the grade combo box before doing any other thing

i add the tblgrades to the query and once i add it it create relation between the tblModelsGrades tabel ( idgrade field ) and the tblGrades table (grade field) but it's not working at all

how to replace the id by the name look to this please it works well but in the grade combo box i want the name for the grade to appear not the grade id note: there's table for the grade and tabel for the models and i made table as joining table between them called tblModelsGrades...

i get it but just one last thing ok ok i make the grade combo box reflect the submodels for the model combo box but it load the id for the grade not the name please someone check it i'm so close

??? the problem is that when i select the model the submodel combo box not load the data so do the following select toyota from the make the model combo box will load all toyota models so select model from the model combo box like corolla then the grade combo box should load the...

This what i do until now ... ( database 2003 version) i create the table which contains ID primary Key the Models key ( i insert all the models id) the submodels key ( i insert all the submodels id which met the models) so i put in the criteria for the ModelsId [forms]![my form...

Joining Table ok what i get is to create what they called joining table or associative table ... so i create the table as u told me with this fields one field for the models table Key one field for the Submodels Key so how they become the new table key ( you mean make both of them the...

hope everyone doing well i have two tables one for Models ( Camry - Avalon - Corolla ) and one for SubModels (XL - GL - Sadaan) How to make a query between these tables i can make one to many --- but how to make many to many for example The camry has the subnodel XL and the Avalon...

correct the mistakes it will be very kind of you if you make any modification

first .... really my words can't thanks you enough second .. it's very near to what i want when the user press button price i want the record of the price from the tblall appear in the from in atext box or something like this not to open the query i also wanna say sorry for my stupidity...

one tabel against many tables thnaks for your advise and help what i get from ur explain about the structure that you want me to put the make and models all in one table but if i do that how i will make the models table reflet the make models EX: when choose toyota the model combo box...

Database in 2003 ok .. i uploaded it in 2003 format thanks.

i sent my problems many times and no one try to really help i need this very urgent ... please my job depend on it i upload my Database (Access 2007) as i explain before i just want to test values the user chooses it from combo boxes to values exist in atable so if there's a match make a...

i Hope i explain more i have a table contains all the information Make - Model - Grade - Kilo Meter - Price and have many other table so the user select the value from it i want when the user select all teh valus from the combo boxes compare this valus to the values in the table which...

i have 4 Combo boxes 1- make 2- model 3- transmission 4- year the user choose values from this combo boxes EX. Toyota - corrola - Manual - 2005 so what i wanna do is make a button when the user push it after selecting all values compare this values to values stores in another table so if the...

NOt Get It can anyone please descirbe it in simple way to me how to do it in steps sorry but i'm new to access and need this urgent

ok .... can you gice me a clue how to do it

dear i made the same thing like u do here what i do create many combo boxes cboMake - cboModel - cboYear when select from cboMake like toyota - honda - bmw the cnoModel reflect the models for this make here the code i wrote Option Compare Database Private Sub...

i have 4 Combo boxes 1- make 2- model 3- transmission 4- year the user choose values from this combo boxes EX. Toyota - corrola - Manual - 2005 so what i wanna do is make a button when the user push it after selecting all values compare this values to values stores in another table so if the...

i really finished my Database the result i have 5 Combo boxes 1- make 2- model 3- transmission 4- year the user choose values from this combo boxes EX. Toyota - corrola - Manual - 2005 so what i wanna do is make a button when the user push it after selecting all...