Recent content by dobseh

We tried this, parents only paid one invoice because they thought the other was a duplicate. This doubled the workload of the club co-ordinator and made lots of people very unhappy. What's that saying about "if you design something to be idiot proof, the universe will design a better idiot"...

I fully agree that this is the best approach, and it's the one I have taken in the invoices/orders of physical items section of the DB(I forgot to include the payments table for this in the schema screenshot). The reason I can't take it for this piece is the need to be able to refund individual...

Sorry, but we are going to differ here. This isn't taking automatic payments, there is always going to be user input to enter amounts that have been paid. The money in the bank doesn't go anywhere and is always there as a transactional record of payments that exists in a fully auditable form...

Hah, I worked in PCI compliant companies and been part of a PCI audit - this ain't that, not by a very long stretch. There's no need at all for an audit trail or anything even close, although I fully appreciate that best practice should be to do it that way anyway. This is a very small club...

I think you are saying the process I posted originally with this? Payments entered get validated to ensure that amount_paid is not greater than the amount_oustanding Happy to post the schema, but could you explain what the value of the child table is? I'm not sure why it would be needed, I...

No, the fees go into the feespayable in descending order of price, so that ordering by the ID always gives you the most expensive first. Also end users can't allocate a payment to an individual fee, the form for adding payments just allows them to enter an amount and the database is expected to...

There is an indexed ID field in tblfeespayable that links the child to their fee for that term. This field is written into tblpaymentsmade when a payment is made.

There is a payments table. Your solution is fine but it's really just moving the problem from when the data is written to the table to when it's read. I'd still need to have make sure that if they need to refund then the amount paid for that child is pro-rated rather than just the total amount...

It would be much easier if I could do it like this, but the club has a policy where if a child is leaves then they get a pro-rata refund based on what they have paid and the number of weeks into the term. This means the per child payments need to be tracked so the correct refund can be given...

I've got what I think is a fairly standard order/invoice system in db I look after for a children's club. This club has a term based fee for membership, and each term an order is generated for each parent containing the fee for each of the children they have attending. In the db this populates a...

So I had another little play with this; try going into Design view and resizing the large unbound WebBrowser control so it's smaller. Mine looks like this: means that you can see the buttons on the form view. There must be something funky in the way that later versions of Access render the...

Which one? I clarified that I should have said "Which was cancelled" originally, that is a fact that roadmap was cancelled. Everything else I've said is my (very jaundiced) opinion on the situation.

I've been playing with this today, I really like it. I've reached out to the author to see if they are planning to move it out of "maintenance updates only "and back into active development as Monaco(regardless of it's roadmap status) doesn't appear to be along soon.

Copium springs eternal, like the second coming, it'll be along real soon, we just need to be patient... I'm a cynic through a lifetime of disappointment.

I played with it a bit and couldn't get the dropdown to show up in Access 365, I didn't persist with it because Access SQL Editor suggested elsewhere in this thread seemed to do everything I was looking for, apart from the intellisense aspect.