Search results

I do not know what you did, Gasman, but it now works. I've copied it in, compared, confused, don't care. Moving on. Thank you very much.

and neither did I

ya nailed it. It also works in QuickBooks, MoneyDance, Money... Most any credible accounting package.

My controls look like one control because one goes on top of the other. The pink fields are not visible.

https://www.google.com/search?q=access+math+in+field&rlz=1C2JSBI_enUS1094US1094&sca_esv=cd1cd8ba04cfc6b9&sca_upv=1&sxsrf=ACQVn0-lLyqHLsT1l5hqMzztR5PUB1Tp9Q%3A1714680524206&source=hp&ei=zPIzZoXrCbbmkPIPmMGG4AM&iflsig=ANes7DEAAAAAZjQA3EhhxkNw8sAYH6MRUX1RKPxcHPhc&oq=Access+math&gs_lp=Egdnd3Mtd2l6Igt...

I still don't understand need for the text fields. Why not just enter a value into number field Have you ever done data entry? Doing math in a field is typical of accounting software. When you need to quickly split a sum into separate accounts and add sales tax at the same time, a math field can...

Deleted nz fields and replaced with debit and credit. Still do not work unless I delete txtDebit and txtCredit.

Go to one of the white fields, txtDebit and type 1 + 5... Enter. It's for doing calculations to set the debit amount. It works very well. I know the footer sums work when the txtdebit and txtcredit are eliminated. That's my point. Why should they affect it in any way?

If you delete the txtDebit and txtCredit the totals work. They are text boxes for calculations. They work with an eval function. The Debit and Credit fields are not text. The sum does pull from the field and not textboxes.

The attached database has a form called frmsubCategory. It worked fine until I got fancy and put in Richard Ross' fields that calculate in the field. The pink fields should not be visible but are attached to Debit and Credit fields and totaled at the bottom. The totals in the footer return...

I wasn't paying attention... Did not even realized I had done so. When it asked to save I just gave it a random name. Will NOT do it again! Thank you.

Thank you very much!

So... to be clear here... class modules need the exact name but modules should not have the name of their subs?

AH!!! I get it. It works! Thank you so much!

You make me feel very stupid... but I'm not seeing what you're saying: What is the correct name?

There is a FAYT combo on frmRegister and frmsubCategory. Thank you for looking at it.

Yes, the class module is there. I also assumed the problem was the references but I'm unclear what to do about them. What references would the FAYT module require? If there was a problem with them, wouldn't there be problems in other databases? I'll try to figure out how to refresh them.

I use Majp FAYT in nearly all my databases. Never a problem. (or at least not THIS problem). Suddenly my code won't compile because this is a user-defined type not defined: Public faytCategory As New FindAsYouTypeCombo Right after Option Explicit I've check all my references and they are the...

Thank you! Exactly what I needed!

ok! on the same page! So... using after update to assign the control Source? and leave it blank in the properties? Will that work?