i am struggleing with D lookups, they work on my other database but not on this one. i have a table holding individuals info. so i want to input their initials and there name to automatically populate
=DLookUp("[Name]","[Individuals Details]","[Initial]='" & [Forms]![Comp Subform1]![Initial]...
i have fields in a form and i want them to automatically populate the costs and the discounts when a product is selected. the costs are stored in another table
nothing seems to works
it seems simple
but i cant do it
help
thank you all
THANKS FOR THE ADVICE I FOUND THAT SOMEONE AT AN EARLIER STAGE ASKED THE SAME QUESTION AND I USED THAT INFORMATION AND IT WORKS, MY BOSS IS WELL IMPRESSED THANKS
i only found this page today and it has really helped, got a problem, is it possiable to put passwords on command button, so only select few have access to that form, if so it would really help. Thanks
WELL I THINK I HAVE AN IDEA, I DONT KNOW IF IT WILL WORK, BUT ALL YOU HAVE TO DO IS CREAT A FORM WILL ALL THE STUDENTS NAME ON IT AND HAVE A BOX FOR THE DATE.
then you have a check box next to each name and create a query that will put up all the names not present.
the table will have a new...
got a small problem i have created a mail merge that creates a letter, but i want to put a button on the form that will automatically open the letter on the correct record when clicked
thank you
i have got it on auto number, what happens is when you enter the form it comes up black so you can enter the information. as soon as any data is entered into one of the fields the record is automatically given a number, but if you find you have entered something wrong, or te record is all ready...
I have had a database on complaints, each complaint when logged is automatically assigned a number. The problem is i have created aform to log new complaints but if someone makes a mistake i dont want to delete the record i want to the information to go that they have entered but i dont want to...