Recent content by ChrisLeicester

Hi I.already have the form set up with also a subform that lists the products along.with a qty button and an additional button I have an option to ammend price and qty once a supervisor has logged in so read only wont do. The barcode reader was another input method. Think I will work through...

Hi Thanks, I will look again at a totals query, I did try building a totals query but the results didn't produce what I expected. Will play around and see

Hi All I am working on a POS/orders system and have a transaction main form, and transaction items subform. I have a barcode reader which looks up the products. An example could be; Duck, 1, £1.50 Duck, 1, £1.50 Chicken, 1 £2.00 Chicken, 1, £2.00 Chicken, 1, £2.00 Currently, my subform would...

Hi Thats working perfectly now, thank you

HI Thanks, I will try that. Was also googling and another place was showing code to add a new record, forcing the record to save and then deleting the new record created, seemed a long winded way to do it, although I get the logic

ok. I get that now, i have been thinking its saving the record. Will saving the subform object also save the change made to the actual record

AH, Private Sub PriceChange_Click() Dim NewOne As Currency NewOne = [Forms]![PriceAdjustFM]![NewPrice] [Forms]![NewCustOrderMainFM]![CustOrderListSub]![RetailItemPrice] = NewOne DoCmd.Save...

Hi all I have an orders main form with a 'cart' subform The query behind the subform has a calculated field [LineTotal] which calculates QTY*RetailPrice for the subtotal 'Column' and then the textbox in the footer can also calculate an order total. When adding the records it calculates well...

Hi Thanks I am not really experienced in using sql so I built the update query in design view and then clicked the sql and copied what access showed. I will copy your code and go through it line by line and try to understand it. I did try it with a macro but kept getting a record not saved...

Hi All I have a main orders form with a order items subform in it. The order items has fields for the product, the QTY ordered and the selling price, linked to the parent form by order number. I have an unbound pop up form which comes up if the selling price is double clicked for price...

Thanks for all those examples, I will go through each one, digest them and understand them. I need to rethink the format as I have now realised I can't use the unbound text box in the products subform due to it putting any typed value in one box into every box. So that idea is out the window

This is what I am trying to achieve, I know I could use a simple cart subform with a combobox on each cart record but thought this would look better. I will take on board your comments, they make sense and will have a rethink,

Hi Thanks everyone, progress is being made. using the ? in the immediate box, I can see the SQL line and checked each variable and each shows the correct value, so far so good. This has brought up another problem I didnt see coming due to my lack of experience. In the unbound subform I list...

Hi I have taken the " off the value section and that now passes. I now have the Current DB.Execute strAppSQL, dbFailOnError line showing red and a syntax error I also tried your debug.print line in the immediate area and it didnt show anything after pressing enter. I must be doing something...

Hi I will give that a go. Learning something new every day. Thanks I am getting this line as red; strAppSQL = "INSERT INTO SalesTransactionItemsTB ([ItemPurchased],[ItemQTYpurchased],[RetailitemPrice]) Values ("ProdOrdered & QTYordered& ProdRetail")" the error is expected end of statement...