Entering text into a table via a query

[mike60smart]

Shouldn't that be Paid ?

Hi Gasman
Yes "Paid" would also be included but difficult to determine as we have no idea of the actual table structure.

 

[turniporange23]

So the Subform for entering Invoice Number information must be based on a query based on Multiple Tables.

The Subform has Multiple Redundant Controls because all you actually need to enter in the Subform is the "Date", "Invoice Number" & "Amount"

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

 

[mike60smart]

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

Hi Bob
Well Gasman gave you the solution as to how you can achieve this.
All I am trying to do is point out that the structure of the Subform is wrong.

 

[turniporange23]

Hi Gasman
Yes "Paid" would also be included but difficult to determine as we have no idea of the actual table structure.

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

 

[turniporange23]

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

 

[mike60smart]

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

This just confirms that your table structure is all wrong.

 

[mike60smart]

Can you upload a copy of the database with no confidential data?

 

[mike60smart]

Hi
Are you able to upload a screenshot of your table relationships?

 

[Ken Sheridan]

Trouble is Client may have 6 Invoices and may only pay say half the owing amount

So how do you determine the distribution of the payments among the six outstanding invoices? If you give priority by invoice date for instance, and the payment covers three with a remainder, then how do you indicate that the fourth invoice is partially paid?

 

[Mark_]

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 ClientID in both tables. Is it possible to enter this text in to the query to up date the table tblInoices ?
Thanks for any help....................Bob

Just to save you a LOT of trouble in the future, I'd replace "Paid" with having a Date Paid in your invoice field. It will save hours the first time you get that abominable entitled client who wants to argue they are always up to date on their account as the invoice shows "Paid" but doesn't include the "Due date" and "Paid date" showing they always pay 30 to 60 days late...

 

[turniporange23]

Just to save you a LOT of trouble in the future, I'd replace "Paid" with having a Date Paid in your invoice field. It will save hours the first time you get that abominable entitled client who wants to argue they are always up to date on their account as the invoice shows "Paid" but doesn't include the "Due date" and "Paid date" showing they always pay 30 to 60 days late...

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

 

[Gasman]

How do you get a payment of zero?

 

[RonPaii]

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

If you think in transactions, then partial payment becomes a transaction including the invoice, payment amount, payment date, etc.. The Invoice is paid when the invoice amount and payment amount are equal.