Access 97: Writing Calculating data to tables

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

sabotaj

Thread Starter
Joined
Jan 19, 2003
Messages
4
i've got a few calculations for fields based on other fields. I've managed to run these calculations properly in Forms and they are stored in the form:Datasheet view, but not written to the underlying Tables. i there anyway i can create a bound field with calculations in a Form? any ideas please....urgent!! thanks
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Love your name. :D

Ok. Don't do the calcs on forms.

Do a query with your table fields. Add fields and create expressions for your calcs. Create the form based on the query instead of your table.

You don't NEED to store calcs in tables....that's the whole idea. All calcs are done "on the fly" (when you run the query, form, or report), so there's no need to store them in tables. You're just wasting space.

Understand?

;)

Let me know.
 

sabotaj

Thread Starter
Joined
Jan 19, 2003
Messages
4
Hey thanks for ya help, and the suggestion. Name is pretty alright huh? lol
I sorta found another way around it as well. because i'm builing a System for VERY basic users i have to keep the calcs in the form. What i've done is do an update query that initiates after the closing of the form- unfortunately this updates the entire table each time it is run. Any suggestions on that? But yeah- my basic problem is solved!!

:D :D
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Yep. The only better name I can think of would be Self-Sabotaj. I used to do that a lot!

Anyway:

Just the same suggestion, Sab.

Whether you do the calcs on the form or not should not be making any difference to the user.

So either I don't understand what you're doing, or you don't understand what I'm suggesting.

I'm willing to look at your DB, tho.

Tools-Database Utilities-Compact and Repair, zip, ship to [email protected]
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top