Recent content by eran185

hi ! i'm very "fresh" in access , and i want to learn how to build something like vlookup . i have 2 tables : car , general i want to get a query that give me : id number plate color 1 111111 blue 2 222222 black 3 999999 not found i want to see all the id's and all th number plate and the...

problem - vlookup hi i build the query , but the problem is that i saw only the lines that has same id. i want to see also the cars that not match (like in the excel , to get #name) what can i do ?

i'm "fresh" in access - could u explain me how can i do this thing ??

hi in excel there is the function - vlookup. i need to do something like vlookup in the att. file 1-i want to see the details of the car when i give the id 2- i want to see the details of the car in a summarizing table that contain all the details :(

maybe someone else can help ?

hi i try to build an access form . i have "big" table that fill in the name of the product , the quantity , and a minimum quantity. the field : min quantity give us the quantity that is the minimum of the product. i have a "minimum" table that has the list of the product and the minimum...

clarification - what i want ... i want a list of products. every product has date and quantity . also - every product has a minimum (if there is lwss then the minimum - i want to see that product in red) i have a big list (quantity - min) , but not all the products are in the big table (big)...

hey i have 2 problems : 1-i can fill only the first line in the form 2-i want to use "quantity - min" table : i want that if the quantity in the big form will be less then the quantity in the "quantity - min" table - that product will be in red

and if i want to do this field in another form (in that form , i dont have this field) ?

hey there is a litlle example. look at the field "test" in the form

i have a query and i use "count" to get the number of items i have. then i want to see this number in a form , and i put text box that receive this number. the problem : i get "#Name?" in my text box why ?

i build a form when the file will open - the form will show but the form is not on maximize size how can i do the form on maximize form ?

thank's thank's :D

sorry but i dont see the function called "FillOptions()" in the properties of the form what's the name of the ligule ?

? can u explain ?????