Search results

I solved my problem by creating a new text box and pointed to the form to create the control source. Thank you all for your help.

Also - I tested the 2 pieces of the formula returning the #Type! error: =[AdPkTot]*funGet..." The fnGet... returns a "1" when I remove the [AdPkTot] from the formula. However, when I remove the "fnGet..." and leave only the [AdPkTot] (which points to the APperMix box on the form) I get a small...

Just to be sure - you saw a funny little square too? Strange that the same function is called in another calculation and it works fine...

Gotcha! The main problem is that NO ONE in this company knows how to use Access - they all use it by selecting buttons on forms to enter data and print reports. The company fired its IT people and outsourced the job to an outsider who comes in 2 days a week - he doesn't know Access either, which...

I will give this a shot and get back to you - this may be it!

Since it isn't my database, I don't know which Query it is. I have tried clicking on Object Dependencies, but it doesn't work. It says it may take a few minutes, but I never get the option of choosing the "to or from" option. (I read where if you use code, it won't work.) I have gone through...

I teach Access, but it has been years since I used it in a business. I am helping a company convert from 1997 to 2010. The conversion itself wasn't too difficult, and I have solved several small issues, but I have one that stumps me. On a report, instead of the answer to a simple calculation...

I teach Microsoft apps, but do not consider myself to be a programmer. I will sometimes look at code when I have to to try and figure out the source of an object.