Search results

Hi All I am trying to do a search button on a continuous form to search for records that contain some of what is entered in the textbox. Private Sub SearchBTN_Click() Dim strSQL As String strSQL = "[TransDesc] = " & "Like '*" & Me.SearchBox & "*'" Me.Filter = strSQL Me.FilterOn = True...

Hi All Some may know, I am building my stock inventory database and learning as I go. I always believed, or read somewhere that good design is not to hold unnecessary data and to let access calculate data as required. With this in mind, I haven't got a current stock field in my products...

Hi All I have an unpaid invoice screen as shown below My idea was that once approved, the user can tick the yes/no box and then a payment pop up form will open up and list all the ticked invoices to then be paid by the one payment record, a one to many, one payment can pay many purchases...

Hi All. I am having an issue with a subform on my purchase orders side. Funnily I use the same format on my sales side and that works, but on the purchases side I get the following, Cannot add record (s), join key of prodordertb is not in recordset. The main form data come from a query...

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

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

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

Hi Taking advice from here, I am trying to move away from Macro's and use more VBA, although it is a learning curve. I have a main form with two subforms, one showing current products, and another like a shopping cart. The idea is the user picks the product, enters in a text box the quantity...

Hi All I have an unbound form with a subform in it in continuous form layout. The subform lists a query with all products along with the product category. In the subform header area I have a combi box which lists each category, the idea being the user can select a category and the continous...

Hi All I am writing vba to check if a record exists before I open a form and am going back to basics, doing one step at a time before adding the next step. I have a query called [SearchPOQ] which lists all the purchase order numbers already entered. I have a primary key field called...

Hi All I haven't really used Access much for a few years and must be rusty. I have also just upgraded from Access 2007 to Access 21 but don't think that is my issue. I have a main form with a subform which in turn has its own subform. Main form - purchaseOrderForm 1st Subform -...