Search results

You were spot on- again! I figured out the problem. I actually have about 4 other 'optional fees' but I didn't include it in the OP as I didn't want to bore you guys and thought it was the same theory being applied. After your post arnelgp, I was more suspicious of the Null element with one...

Thanks for this oleronesoftwares. This database is still under design with test data, so luckily your last point I won't have to do :) But thank you for clarifying that this should be done at the table level.

I think you're spot on with this but I'm obviously overlooking doing something here. I realized that I need to have a default '0' for 'Additional fee' as like you said, 'Default Fee (not zero) + Additional Fee (null) = Null', so I added a 'Default Value' of 0 in the 'Additional Fee' form field...

Sure. At the moment I'm just using the arrows at the bottom of the form to go to start a new record. I also tried adding a form button to test that earlier too, so the button for the "Add New Record". That does the same thing. A new record doesn't show the 'total', although the 'basic' fee has a...

Hi all, I have a form with a couple of simple fees. One of these is a 'basic fee' which applies to all records. I have put a default value in this field for any new records created (let's for example say it was $1). Then there's an 'Additional Fee' for example, where the user would have to...

This is great. Very slick. I had a quick look at the coding- a bit above my pay grade! But I will try and study it to learn from it. Thank you for your time and this extended effort.

Thank you ShaneMac51. That looks like a simple way to do this- I've not dabbled with ribbon forms before. Appreciate your idea.

Hi arnelgp, Thank you for investing so much time and taking the trouble to creating a demo database that would show and teach me how it works- I'm blown away! I will study your code and try and learn the concepts from it. That's awesome. Thanks again bud.

Hello everyone, I haven't really used Access much in over 10 years. I used to use some of it's basic functionality (minus programming) for years. But now I'm super rusty and have been mulling over this for over 2 days and still blank, so thought I might ask for some input please. :) So it's...