Search results

it's doing a calculation there from the control source, the text21....

still doesn't work, gives me £0.00

it still doesn't work :( give me zero I am now putting it in the command button in the subform, so now it reads: Private Sub Command31_Click() On Error GoTo Err_Command31_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Dim x As Currency Dim y As Currency...

Hi again. I want to know, I have made a query and a form of that query. I am wanting to know, is there a way (I know, use the Form Load event) in VBA where you enter the the criteria to search for and it does the search? I know, it would be something like: sub form_load() dim searchwhat as...

ty :) c u at 6pm then hehe

i've nearly got it sorted out, i hope u don't mind me adding u on my msn

ty for making it clearer I appreciate it :) the problem is: I have a button in the main form, this button is suppose to update the price total in the order table because in the subform there is a total calculation and that doesn't update it in the main form, so I put a button on the main form...

yeh i know..it's a long story, but n e way, do u know how to tell the subform (there is a command button i put there) to click a command button on the main, parent, form?

never mind, solved it :) had to create a link between the Order Number from the products purchased table to the ordernumber on the order form table (going from orderform table to productspurchased table) :)

Hi there. I'm building a Query to print out an invoice. I have these tables: Customer Details OrderForm Product Details ProductsPurchased And these are the fields put in the query: *From Customer Details* CustomerNumber Name Address City Country Postcode Customer Discount *From OrderForm*...

hmm...apart from this, it shows a all the product details! :( eg: if I order a bookshelf and a chair, it shows this: bookshelf chair dining table bookshelf chair dining table the dining table is the last entry in the product details table/form. Any ideas on y it does this and how to over...

cool, got it to show only the current record :D but it's still displaying the records 2 times, why?

well, i got the query working. but it shows twice the values! how come? And how do I tell it to print the current record displayed on the screen? (like the first one except it didn't print all the ordering details) The Query has these tables: CustomerDetails OrderForm ProductDetails...

yeh, thanks. aa lol. nearly done all of this and this happens. firstly, can anyone plz tell me the command line on how to tell a subform to click a command button in the main form plz?

hmm..thanks... i can't afford to start over.....

ok, take a look :) ftp://temp:temp@techftpserver.co.uk/mdffc.zip the things I want printed in the report are (In the detail section): Product Number Product Name Unit Price Quantity Required Total I want it so that, whatever customer number (EG. 1234) it is at, it should print out all the...

ok, can't get the query to work exactly :( as soon as I put in the product details table in, it won't show anything at all, when i take it out, great, but it don't have the product item name..

sure, sorry about that :) ty

wait...that won't work :( damn

DUH!!! Queries :p..sorry...that may not work..but anyway: things like Finishing don't get printed out or stored.....aaaaa..confused. I just had an idea: since the order details (or part of it) is linked with the customer details table, I can just make a report from that, fill in the rest of...