Search results

I have been trying to create a Quote form in my Database. I have a list of products, each product then has a table that details prices based on quantity breaks (i.e 500 to 999 and 1000 to 1999 etc.). In my Form I am unable to create a subform in datasheet view that will enable me to select a...

Yes it is possible that the values could be Null. I have tried with nz, I do now get the line value of the selected record, but I need it to Sum all the Line Totals of all records in the Datasheet! Any Ideas

I hope you can help. I have read for many hours and tried examples to help me resolve my subtotal error on a form/subform, but alas no joy. :( This forum has been an exellent resource and the answers with the posts have resolved many problems I have encountered. But the time has come to ask a...

Thanks for your help. I had already used the wizard and adapted the code, but with Data Entry off it always comes up with an error, I was guessing that this was due to the Data Entry being off! I must admit I didn't realise that Data Entry would stop all records being displayed, again I asumed...

I have a subform and whenever I set "Data Entry" to Yes, all of the records disappear! Can anyone help? I am trying to add a button on the main form that will add a record into the subform table and open a form to add the details, can you please give me some suggestions on how to do this...