Search results

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...

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 :(

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...

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

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 ?

is there a way to put more then 8 button's operation in a navigation screen ?

i build a query that filter names. i want that when the user start to write the name he want to find in the query , he will get a list of names that starting with the same letter he wrote how can i do this thing in access ?

hey i want to use the format mm/yyyy in my date field. how i can do this ?

hey i have a main form ( there is link to my forms and my reports). in one of my forms , i have a id field. i want to do a macro or something like these that will do this things : 1-go to the form 2-go to the id field 3-push ctrl+f (search in a specific field - the id field) how can i...

hey i have a simple form , based on a simple table. i build a imple query that take the date between today and the date the user want. but the query doesn't work :(

hey i build a navigation screen the problem : i want to activate this in the tools-operation , but i can't (i dont see the name of the navigation screen there ...

i build a report , based on query. when i want to print this report , i see that the first page is ok , but the second page is little curved -the records as u can see not under the titles

i have a report. one of the parameters on that report is "amount" i want a query that ask the user "enter amount" and then the user get only the records that low then the amount that the user fill-in.

hey again... i try to build a query based on table and some other queries. when there was only a table - it was ok (all the records were in my query). but when i combine some queries - it wasn't ok... i didn't see all the records. why ???

hey i have table. it's define as a Short Date (XX/XX/XXXX) i want that my date will be like this : XX/XX/XX how can i define the date ?

how can i define that when a user pass over a command button , he will see some words (that define the button)?

can i take a text box from a form and put it on a report (or on a table ) ?

i have a form. i made a query , and i can see the query (there are 2 fields , and i want to see one of them) only in a subform , but i want to see the query in a simple textbox. how can i do this thing ?

hey i have 2 tables : big one - deals table , and small one - bookkeeping . every deal has many records of bookkeeping . in the bookkeeping table , i have this fields : date , credit , debit and balance. i want that in the form , the balance will take the former balance+credit-debit how can i do...