Am I Doing Something Wrong - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Am I Doing Something Wrong

Lee Shastid

5 months ago

I have a Product Form that has five (currency0 fields that I have a text box setup to get the total from all of these five fields. I can redo the text box and sometimes I have to redo one of the other fields also. But anytime I open the DB I have to fix it. I have it =[cost]+[tax]+[shipping]+[fflfee]+[miscellaneousfee]. Any time I open it the total Cost Text box shows #name?. It works once I correct it but if I close the DB and open it back up it does it all over. Note that I have this in another DB exactly same way and it works fine and I never have to fix it.

	Lee Shastid OP @Reply 5 months ago

	Ben Perry @Reply 5 months ago
I can't provide much help beyond this and I am assuming most would suggest/ask this first anyway. Have you run through the troubleshooter Richard provides? At the very least, my first start would be a compact/repair.

	Richard Rost @Reply 5 months ago
Yeah, it definitely sounds like a corrupt database issue. If that doesn't work, instead of doing the calculation in the form, try doing it in a calculation in a query and then using the query to feed the form. That sometimes works more reliably.

	Lee Shastid OP @Reply 5 months ago
Yes I have ran the compact repair Database option. I have not ran the trouble shooter. Richard that is a good idea. I have seen that in one of the videos, can you tell me which one its in?

	Alex Hedley @Reply 5 months ago
Troubleshooter

	Lee Shastid OP @Reply 5 months ago
I got that one for the troubleshooter. How about the one showing how to do a calculation in a query and and then use it to feed the form?

	Alex Hedley @Reply 5 months ago
Access Expert Level 8 - Calculated Query Fields TechHelp: Calculated Fields Legacy Tip: Microsoft Access Calculated Query Fields

	Lee Shastid OP @Reply 5 months ago
Thank you. I think the I can handle the query part of it. But feeding the form will get m, I bet.

	Alex Hedley @Reply 5 months ago
Have you set the Form's `RecordSource` to a Query before or always just a Table?

	Lee Shastid OP @Reply 5 months ago
Okay Alex....its confession time...LOL....I started reviewing things and it started looking a little overwhelming. So I went to my DB and deleted the form I was having trouble with. went to my back up and just copied the original copy to the current db and it all seems fine now. Now that I expect it what ever I did on the bad one I will watch out now. Thank you all for your help.

	Alex Hedley @Reply 5 months ago
Sometimes the nuclear option is the way to go Glad it's working again :-)

	Lee Shastid OP @Reply 5 months ago
Thank you and Happy Holidays to all.......

Ben Perry @Reply

5 months ago

Lee, I also am glad it worked out. I can't remember if it gave me the same #name error but I know something I have experienced is when I have accidentally (or intentionally then forgotten) changed some of the property types. I am guilty of copying a form that I like and modifying it for a new purpose and overlooking a property or two. It has bitten me a couple of times and I usually get weird results from it.

	Lee Shastid OP @Reply 5 months ago
Ben I think we may be doing the same thing....LOL

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View