A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

The problem with calculated text boxes



 
 
Thread Tools Display Modes
  #1  
Old July 27th, 2004, 10:02 AM
external usenet poster
 
Posts: n/a
Default 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  
Old July 27th, 2004, 02:50 PM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default 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  
Old July 28th, 2004, 04:53 AM
external usenet poster
 
Posts: n/a
Default 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  
Old July 28th, 2004, 06:07 PM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default 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  
Old July 29th, 2004, 04:44 AM
external usenet poster
 
Posts: n/a
Default 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  
Old July 29th, 2004, 07:24 AM
John Vinson
external usenet poster
 
Posts: n/a
Default 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  
Old July 29th, 2004, 10:29 AM
external usenet poster
 
Posts: n/a
Default 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  
Old July 29th, 2004, 10:29 AM
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 04:24 PM


All times are GMT +1. The time now is 01:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.