Hi John
Ok, I deleted all of the calculated fields from the table. Then I actually
deleted the subform from the page and then replaced it with a new one. I
put in new text box controls that were bound to control source with my
expressions. After doing that I get the following message:
" This expression is typed incorrectly, or it is too complex to be
evaluated. For example, a numeric expression may contain too many
complicated elements. Try simplfying the expression to variables."
There is an ok button and a help button, no placed to debug.
So, I tried removing all of the expressions from the calculated fields, I
get the same message. I checked all of the expressions and they are
correct.
So, then I again removed the subform, and used the wizard to put in a new
one.
Immediately got the same message, but this time NONE of the calculated
controls are there.
The only change that was also made was adding Part_Number to the table for
Parts_Purchase.
When I go from design view to form view that is when the message is coming
up, and after I click OK, there is nothing in the subform box.
Thoughts?
Thanks!
Deb
On Mon, Jul 25, 2011 at 9:13 AM, John Viescas <john@viescas.com> wrote:
> Deb-
>
> Your original expressions are just fine to display the calculated values,
> but
> you should delete the companion fields in the underlying table. They won't
> be
> updated.
>
> You cannot send attachments to the list - you have to upload files to Files
> /
> 2_AssistanceNeeded on the group website.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar