Search results

Many thanks That explains a lot

Hi bob Thanks for your help I have now solved the prolem it was due to me putting the wrong name in However I always have trouble when dealing with sub forms .Is there a reason for this or is it just me (which is vary possible)

Hi everyone Every time i try to get info from a sub form or its table ,Things never sem to work.Is there something special you have to do for eg maybe going via the main form? I am trying to use dsum as an alternative to multiplying info in the sub form This is the code...

Thanks for your help I need to store the invoice grand total can you explain how i would do this using a query

Hi i have an orders form with aorder details sub form I need a grand total of the order that i need to store in my orders table Cant seem to make anything to work is this becouse my form is a sub form Basically i am doing a dsum quantity *sold at price with a where id information Doi i have...

THanks for your help

Hi thanks for getting back. Been away on business hence not resonding Gettting back to my problem of not being able to store calculated fields into a table I have reloked at allen browns post on the internet ,he explains how to store a caculated field in a table using access 2010 ,using the...

Hi all can any one explain to me how to store a calculated field into a table I know you are going to say dont .But i realy do need to I am preparing an invoive and , I have a field called deposit .Now this field calculates %40 of the total of the order .but if the user wishes they can enter...

Re: SOLVED Thanks for every ones help The problem was an extra space in the table field (typo)

When running the following code I get RunTime Error 2471 The expression you entered as a query or parameter produced this error [phone no 1 ] All the code works great except the last bit it should put a phone number into the field TelNumber Private Sub Command60_Click() DoCmd.OpenForm...

Hi cj Many thanks ,that helps a lot

Hi all Needs some help with design . I have a fully functioning orders database ,and it works really well ,Now to complete things I need to add an invoicing method .and a way to keep track of payments. I have produced an invoice wich is a report based on a query ,however the more i think about...

Gina ,Thanks for your help will give it a try

I have tried various places, above the details section and in the footer section It is currently in the section above the details section But niether .Does it being a sub form have any bearing

Hi Gina The SoldAtPrice Is the Field in the Order Details Table

Hi Gina Im Trying to add up all the soldAtPrice Fields for the various order lines for the order 255 For eg the order 255 has 3 order items with a sold at price .Iwant to add up the total of order 255

Thanks for your help ..Sorry it was my Typo I do have had a square bracket at the end of the table name as in your seco nd example and the idord is a fk does the fact that this is a subform make any odds

Hi Gina Thanks for getting back I don't know how to get the sql.But this what I have typed into a text box That I dropped onto my report =Dsum("SoldAtPrice","[Order Details","IDOrd=255") The soldatprice is a currency field in the order details table which is a sub form of the neworders table...

I am trying to use Dsum in a report Nothing happens It is based on info from a table that is a subform could this be the problem .It seems to me it does not recognize the table name .I have checked everything over time and time again .I have tried all different senarios but nothing All...

Help with code please I have a Products form and a Vat form When I enter a product in the products Form I also Have fields for calculating the vat and profit I used to do this with simple code eg Vat=Sell at price /6 and all worked fine Now I want to use a combo box so that I can offer...