Search results

Hi I think I maybe didnt explain myself properly, I have an invoice form which has as you suggest, a main form showing invoice details such as supplier, date, status etc and then a subform which links the invoice items, qty and item cost. This is easily totalled with text boxes as you...

Hi Pat and Gemma, I have just come back and read your comments and will rethink my methods. I cant do a calculated sum on the invoice form because due to the one to many items in each invoice. I have a purchase order main table and then a purchase order items table. To get the totals I query...

Josef your way works better, as you say. searching 'A' returns another syntax error, but your line doesnt. Thanks

Hi Perfect, is working great now Thanks a lot

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

Thank you, no I didnt, was in the recordset but not on the subform, added it now and working as wanted thanks again

Hi Guys I have copied Richard Rost's youtube example but am getting the following error "Syntax error (missing operator) in query expression 'PurchaseOrderID=' here is my code CurrentDb.Execute "Update PurchaseOrderTB " & _ " Set InvoiceStatus = 4 " & _ " Where...

Hi Yes they are separate things, and as I can pay many invoices with one payment I needed a way to tick to select which invoices I am paying. I found on YouTube a way to tick the yes/no by putting a transparent button on the form over the tick box and then running an update query in the table...

That was my view. I initially wondered if I was missing something when the Reddit group suggested it

Hi Yes, that was always my logic.

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

Thank you, will have a go with the button

Im not sure. The recordset for this subform comes from the totals query (Which just gives me totals) and then the purchases table which contains the order date, delivery date, fields etc. Maybe I have designed the totals query wrong. I just have 3 fields in the totals query, purchaseorderID, sum...

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

Thank you Doc Man, I have printed that for future reference. I rebuilt new tables and rebuilt the form with the new tables and new queries and it now seems to work. Thanks All

I used to always use look up fields before just using normal number fields now. If i need a combo box on a form I now add it in design view and then link to it. This one slipped through the net, must have slipped back into that habit. Will ammend it and try again

Private Sub SupConBTN_Click() Dim Supplier As Integer 'The supplier chosen 'set the variable Supplier = [Forms]![POsupplierPickFM]![SupChosen] 'gets supplier from select box DoCmd.OpenForm "PurchaseOrderFM", acNormal, , , acFormAdd...

Hi from the sql link to the query, i did the original query in design view SELECT StockOrderTB.StockCaseItemID, StockOrderTB.FromPurchaseOrder, StockOrderTB.ItemOrdered, [ProductName] & " " & [PackWeight] & [UnitName] AS ItemName, StockOrderTB.CaseQuantity, StockOrderTB.OrderedPrice...

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 Thanks Yes DBguy, the vba is updating fields directly on the subform and one field directly on the main form, which is already open and below the modal form. Pat I will separate each form updates and include the refresh