Search results

Hi I now get the save, and changed it but my issue isnt with the save command. As DHookom has mentioned, the issue is with the pop up changing a value on the main form. if i take that out it runs fine and updates and saves the subform record. I need to come up with a way to update a field in...

Hi All i have a main form "RefundShowProdFM" which has a continuous subform "RefundProdTransSub", which lists the 'many' items purchased in a given transaction' If a customer returned one or more of the items, I have a command button on each item line on the subform called refund which opens a...

Hi Thanks, I took out the me. And redid it with the forms! And it works. It did bring up another issue that in some cases the 'And' starts the sql and access didn't like that. I solved that by starting the sale string with a variable that will work everything and then it adds the variable box...

Hi I have a continuous form which lists all my transaction and their values. On the form header I have various text/combo boxes to filter the results and a Command button to filter according to what has been entered in any of the boxes. The user can enter a date, amount, select a customer etc...

thank you, works perfect now

Hi All I have a simple continuous form that lists sales transactions with the following field, [SalesTransactionID], [TransactionDate], [CustomerName] and [TransTotal] In the form header I have two unbound text boxes, [DatePicked] and [TranPicked] with a search button next to each box. The...

Gasman, Thank you, that's works perfect

Hi All I am trying to use more VBA than macros, and have the following code which is coming up with a runtime error saying I must save the record before it can be requery. The yellow line is coming up at the Docmd.save before the requery line. Public Function CashPaymentMade() 'Set new...

Hi The input mask does seem the simplest, and after a few tries, the following works nearly !#aa.aa;0; it even 'scrolls' like mentioned earlier. My only issue now is that due to it being an unbound text box and not bound to a table field where I can control the max length of digits, you can...

HI Thanks, food for thought. I do like the idea of using the me.capture method, i didnt think about that. I do have a back button on the keypad and have it working, and also like the idea to disable the period button once pressed. I don't have the £ sign in the actual form or the text box, i...

Hi All I am designing a 'Key Pad' to be used as a subform within a Till Page, one to ensure only numbers are entered and to ease use on a touch screen monitor. It is a simple form with a textbox to store the numbers entered and 12 buttons, 0 to 9, a back button and a "." button. I have the vba...

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...