Table Updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI
In a Form I have fields that are result of calculation of fields entered on this same form
The problem is that I don’t see these calculated fields on the table related
I tried the following
For the Form_BeforeUpdate event on Event Properties for the Form I set

Me.CalculResult=[quantity]*[tax]*[price], where “CalculResult†is the name of the field on the table

And on the Form for fields based on calculation of values from others fields, for
TEXT BOX
Name: Total Pric
Control Source : =[quantity]*[tax]*[price
LEGEND
Name: Total Price Legen
Legend: Total Pric

And on the Table relate
TEXT BOX
Name – CalculResul

After all these settings I run and #Name? appears on this field. Where does the Name doesn’t match?
Could someone help me please

Another question
How do I write an expression in which I need to list all the pattern, except one called "IN", eg.
In a list of codes like MO, RF, TE, I need to list the registers related to the code IN only. I know where I must use this expression, but I don't know how it is. Could you help me

Thanks a lot in advance
 
Putting calculated fields in a table is considered poor
design. do the calculations when display the form or report.

Jim
-----Original Message-----
HI!
In a Form I have fields that are result of calculation of
Click to expand...
fields entered on this same form.
The problem is that I donâ?Tt see these calculated fields on the table related.
I tried the following:
For the Form_BeforeUpdate event on Event Properties for the Form I set:

Me.CalculResult=[quantity]*[tax]*[price], where
Click to expand...
â?oCalculResultâ? is the name of the field on the table.
And on the Form for fields based on calculation of values from others fields, for
TEXT BOX:
Name: Total Price
Control Source : =[quantity]*[tax]*[price]
LEGEND:
Name: Total Price Legend
Legend: Total Price

And on the Table related
TEXT BOX:
Name â?" CalculResult

After all these settings I run and #Name? appears on
Click to expand...
this field. Where does the Name doesnâ?Tt match??
Could someone help me please?

Another question:
How do I write an expression in which I need to list all
Click to expand...
the pattern, except one called "IN", eg.?
In a list of codes like MO, RF, TE, I need to list the
Click to expand...
registers related to the code IN only. I know where I must
use this expression, but I don't know how it is. Could you
help me?
 
Re: 2nd question, "IN" is a reserved word, so be careful if your data
contains "IN" as a valid filed value and you need to refer to that via an
expression.

Please explain what you want to do - what are the relevant tables, how are
they related, what steps do you want to perform?
 
Well, I have a table in which a field is fille based on a list that opens on the screen. This list, I myselg prepared with some basica information to me. Eg: IN, MO,RF,TE,SC, letters that make sense to me.- This list is the same that the one I use in a form related to this table. I've created the Form based on this table.

But if I need to prepare a "Search", I mean, it is not a Table, it is not a Form- and as my Access 97 is not in English, I don't know how do you call it. Well, I know how to prepare a search with a criteria like "all registers which have this field filled with IN must be shown", BUT I don't know how to prepare one that "shows every registers that doesn't have IN" - I mean, all the registers different from IN, eg.
THis must be very basic, but I didn't succeed up to now.

Thank you for your attention!
AlexP.
 
Back
Top