[karlhaywood]

Hi,

I have a check box on a form called "Paid" when checked i would like Access to give the record a paymentID and also disable the checkbox so i cant be changed. Is this possible?

Thanks.

[OBP]

How will the paymentID be generated, from a "payment" table/form or just a number?

[karlhaywood]

Which option would you suggest?

[OBP]

Well normally when someone pays you enter a "paid" date, at that point you would set the "paid" checkbox to Paid and if required give it a PaymentID as well, but that could just be an Autonumber.
But you may need to allow for multiple payments for one bill, in which a manual click of the paid checkbox would be better.

[karlhaywood]

so should i setup a table with paymentID, JobNo, Client, Payment Date?

but how would i go about multiple payments for one job?

[OBP]

Can you see customers paying in installments or partial payments?
I created a version of your database which had "Accounts" for both incoming stock and outgoing jobs where the setup was for partial payments and it maintained a "balance" for each Supplier or Customer.

[karlhaywood]

Yes they will pay in installments because a 6 month job worth £60,000 will pay £10,000 a month

[OBP]

Take a look at this version of Invoicing. It has a Customer payment table and in the Customer table their overall Balance.
When payments are made/ammended VBA code updates the Customer Balance.
I think there is a copy of it on the forum already, but I can't remember who I posted it for or when .

[karlhaywood]

Hi OBP great work, i think this is abit out of my league. I do like the way it works though! I was just thinking some VBA to generate a number (Just an ID)

[OBP]

What sort of ID though?

[karlhaywood]

THES1
THES2
THES3

That sort of ID would be generated when the box is checked

[OBP]

Where would the last THES number be stored?
You need a VBA Recordset to open the table to look it up to increment it.

[karlhaywood]

It will be stored in the invoice table. I suppose i could just format the autonumber something like

THES "0001"

[OBP]

You could, let me know what you want to do.

[karlhaywood]

I would like to do it with the recordset please. Can we take it easy baby steps lol. I reallt like learning Access :-)