Search results

My Statement works fine just would to have a label on invoice to say paid, Some times if his invoices come to say 5k he may only pay 3k

Trouble is Client may have 6 Invoices and may only pay say half the owing amount Just wanted to get a paid label on invoices manually Thanks Bob

Just 2 tables tblInvoice tblAccountStatus which both have a ClientID to connect them in a query, Tables are not linked

They are just optional data if you want to enter into [Mode of Payment] or [Amount] of that invoice, Just wanted to have a PAID label on Invice if paid so if at any stage client wanted a copy of old Invoice it would have PAID written on it Thanks Bob

My form

This will be why I can enter anything into my query............Thanks Bob It has a GROUP BY clause. A Totals query is always read-only SELECT tblInvoice.OwnerID, tblInvoice.InvoiceNo, tblInvoice.HorseID, [HorseName] & [ClientDetail] AS HorseNameB, tblInvoice.InvoiceDateInv...

But this information is going to tblAccounts and I'm wanting to go to tblInvoices where this information is showing in my subform Thanks Bob Private Sub cmdEnterHorse_Click() Me.Parent!tbModeOfPayment = Me!tbHorseName.value & " " & tbPercentage.value End Sub Private Sub cmdEnterInv_Click()...

It enters payment descriptions or Invoices numbers into payment descriptions or enter only that invoice total in to Paid amount but all this info is stored in TblAccount and Im trying get Paid save into tblInvoices

Private Sub cmdPaid_Click() Me.[tbSpareText] = "PAID" Me.Dirty = False End Sub This did not update the field The recordset is not updateable Thanks Bob

This is what I would like to do , I actually entered the word PAID into my tbInvoice manually

Option 1 , The recordset is not updateable This is my form with the subform of multiple records

No just one invoice at a time, Like a button to enter "Paid" into tbSpareText that shows on the subform, The subform shows all his Invoices

My Form has a sub form, When I select a client the sub form filters all his Invoice's. I want to add a button in my sub form to enter the word "PAID" to that record in the sub form. The main form has focus to TblAccounts and my sub form has a query to tblInvoices . The query in linked by...

Thanks Tom, had to delete it as the site thought it was spam!

This code works but if the horses name was in a unbound text box could I substitute the horse name "Kenny" to say "tbhorseName" loveracing.nz/RaceInfoSearch.aspx?q=Kenny&s=All&g=All&r=undefined&t=Name#horse Thanks for any help.......Bob Vance

Well nearly did the trick, I am trying to get tbInvoiceAmount to drop its font from 9 to 8 if tbFlag is -1 Conditional Formatting has no option of reducing the text size, Any Thoughts...........Regards Bob

Thanks Tom that did the trick

On my subform of my report I am trying to force access to give numbers more than minus 1 and bold font Is this possible? This is the control source to the text box =IIf([Flag]=0,[AmountSummary],"(" & Format([AmountSummary],'$#,##0.00;$#,##0.00') & ")") Thanks for any help................Bob

I moved my code to OnLoad of my Main opening page instead of my closing button, and now the code is deleting the records thats have the 4 blank fields Thanks for everybodys help :) Bob

Any reason the delete code dose not work When I shut down my database .. Thanks Bob Private Sub cmdQuitSlow_Click() 'Me.ckbUpdate = True 'Forms!frmMain.Requery DoCmd.SetWarnings False DoCmd.SetWarnings False DoCmd.OpenQuery "qryOrphanAddCharges" DoCmd.OpenQuery "qryOrphanDaily" DoCmd.OpenQuery...