If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
The problem with calculated text boxes
Hi guys,
I have a calculated text box that uses 2 other text boxes to make a calculation. I have the form set to appear as a continuous form. The problem that I have is that when I enter the textbox, the calculation is done as it should be, but then the value of all the textbox of all the records changes to the result. Is there any way around this except to actually store the result in the table? Thanks guys. Kenny |
#2
|
|||
|
|||
The problem with calculated text boxes
Try using Calculated Field in the Query used as the RecordSource for the
Subform. -- HTH Van T. Dinh MVP (Access) Kenny wrote in message ... Hi guys, I have a calculated text box that uses 2 other text boxes to make a calculation. I have the form set to appear as a continuous form. The problem that I have is that when I enter the textbox, the calculation is done as it should be, but then the value of all the textbox of all the records changes to the result. Is there any way around this except to actually store the result in the table? Thanks guys. Kenny |
#3
|
|||
|
|||
The problem with calculated text boxes
Hi there,
Ok......I tried it and it now displays the correct result, except now I can't enter data, as the original record source was my table. Kenny "Van T. Dinh" wrote in message ... Try using Calculated Field in the Query used as the RecordSource for the Subform. -- HTH Van T. Dinh MVP (Access) Kenny wrote in message ... Hi guys, I have a calculated text box that uses 2 other text boxes to make a calculation. I have the form set to appear as a continuous form. The problem that I have is that when I enter the textbox, the calculation is done as it should be, but then the value of all the textbox of all the records changes to the result. Is there any way around this except to actually store the result in the table? Thanks guys. Kenny |
#4
|
|||
|
|||
The problem with calculated text boxes
Do you meant you can't enter data in the Calculated Field or other Fields?
You cannot enter data in Calculated Field and you should not store the Calculated Value in the Table since this violated the Relational Database Design Principles. -- HTH Van T. Dinh MVP (Access) Kenny wrote in message ... Hi there, Ok......I tried it and it now displays the correct result, except now I can't enter data, as the original record source was my table. Kenny |
#5
|
|||
|
|||
The problem with calculated text boxes
Hi,
Yup, the query won't let me enter data in the other fields.......am I using the wrong type of query. It is a select query. Thanks Kenny "Van T. Dinh" wrote in message ... Do you meant you can't enter data in the Calculated Field or other Fields? You cannot enter data in Calculated Field and you should not store the Calculated Value in the Table since this violated the Relational Database Design Principles. -- HTH Van T. Dinh MVP (Access) Kenny wrote in message ... Hi there, Ok......I tried it and it now displays the correct result, except now I can't enter data, as the original record source was my table. Kenny |
#6
|
|||
|
|||
The problem with calculated text boxes
On Thu, 29 Jul 2004 05:44:55 +0200, Kenny wrote:
Yup, the query won't let me enter data in the other fields.......am I using the wrong type of query. It is a select query. Please open the Query in SQL view and post the SQL text here. Not all select queries are updateable; someone may see why this one isn't. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#7
|
|||
|
|||
The problem with calculated text boxes
Hi John,
Thanks......based on what you said, I went and redid the query and now it works. Kenny "John Vinson" wrote in message ... On Thu, 29 Jul 2004 05:44:55 +0200, Kenny wrote: Yup, the query won't let me enter data in the other fields.......am I using the wrong type of query. It is a select query. Please open the Query in SQL view and post the SQL text here. Not all select queries are updateable; someone may see why this one isn't. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#8
|
|||
|
|||
The problem with calculated text boxes
Hi John,
Thanks......based on what you said, I went and redid the query and now it works. Kenny "John Vinson" wrote in message ... On Thu, 29 Jul 2004 05:44:55 +0200, Kenny wrote: Yup, the query won't let me enter data in the other fields.......am I using the wrong type of query. It is a select query. Please open the Query in SQL view and post the SQL text here. Not all select queries are updateable; someone may see why this one isn't. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linked text boxes containing tables | Gary McGill | Tables | 3 | June 9th, 2004 11:57 PM |
Linked text boxes containing tables | Gary McGill | Page Layout | 3 | June 9th, 2004 11:57 PM |
Too many hyperlinks? | [email protected] | Powerpoint | 7 | May 25th, 2004 02:19 AM |
More alternatives to text boxes. | David Young | Page Layout | 2 | April 26th, 2004 04:47 PM |
Excel wrap text problem | Ellen Kemper | Setting up and Configuration | 4 | December 2nd, 2003 03:24 PM |