Search results

Thanks guys thisi informtion has been extremely helpful and made my database work exactly how i needed it to. Its now perfect. Just a quick question. I get lost in visual basic code so can you reccomend a book or website to help me through the use of this code. Also does the change between...

i have a query that has values for account balances, the query consists of balance amount, account id. I need to find the lowest value for each account so each account only has one balance that is the lowest existing balance.

i have a form that has a category field, i need to change what form is opened by a macro depending what value is entered into this category field is this possible. I suspect it may have something to with the arguments field in a macro, is this correct. Thanks to whoever takes the time to answer...

Folks, Im not even sure if this one can be done but don't see any reason why i shouldn't be possible. I have a query which shows payments for courses, course price and bonumbers. The best way to explain is by example. say there are three payments, two for one booking and one for the other. I...

I have a query which shows the balances of various accounts and the dates to which these balances belong. What I need to be able to do if possible is to reduce the balances down to the latest date for each account id so that the most up to date balance for each account is shown. Is this...

does anybody know how to assign if you can, the fn keys at the top of your keyboard to macros, buttons etc. Basically i want to be able to use these keys for the most obvious functions in my database such as new invoice, tender invoice payment etc. Thank-you to anyone that replies to me.

HERE IS MY PROBLEM I HOPE I CAN GET HELP! I HAVE AN INVOICE SCREEN FORM WITH A SUBFORM SHOWING THE DETAILS OF THE INVOICE. WHAT I NEED TO DO IS CHANGE WHICH SUBFORM OUT OF EIGHT BASED ON QUERIES ARE SHOWN ON THIS INVOICE DETAILS SUBFORM ZONE DEPENDING ON WHAT BUTTON IS SELECTED IN THE MAIN...

I have a number of reports, some of these I need to print to one printer @ LPT1 and the others I need to print to a second printer @ LPT2, but don't want to have to select this when they print. Is there anyway to change to default printer or port that the reports print to!!!!!! CHEERS