I Need To Update Data In A Table With Information From A Calculated Field In A Form

Oct 12, 2006

I've read over and over that calculated data is bad, that's fine with me... but here is my dillema...

I have four fields that interact with my calculation in a single form. There is only one table in the database.

AmountF (The stored data in the table) (amount financed)
FC (calculated by =[amountf]*.25) (finance charge)
Amount Paid (used in calculation of total due)
total due (calculated by =[amountf]+[fc]-[amount paid])

The math already works, everything works. I can choose to print the form and it looks great. However, I would like for it to (when I'm done printing the form) somehow save the total due data to the AmountF column in the table. AmountF is in the same line as all the other information, so I would like it to not create a new record just update the old one.

All four of these fields have a text box in the form for themselves.

View Replies


ADVERTISEMENT

Calculated Data In Text Box Update To Table?

Mar 29, 2006

I have a textbox on a form that displays a calculated number with regards to input from other text boxes.

I need this calculated number to update to a corresponding field within a table.

I have a button that updates the information, but the calculated field will not update.

I have an "=" expression written that does all of the calculating. When I put this in the 'control source' it calculates and displays on the form perfectly, but will not update the table. If I change the control source to the field within the table and then move the "=" statement/expression someplace else....the field is blank on the form, but I can manually input a number and it will update to the table.

Follow?

View 1 Replies View Related

Use Calculated Fields In Form To Update Table

Nov 29, 2005

I have a form created from a table and I had to use calculations in some of the fields to automate certain processes. Now, if I pull a report based on the fields in the table - I am getting all except for the fields with the calculations. Is there any way to update the main table - since most of the calculations were done with text boxes?

View 1 Replies View Related

Forms :: How To Update Main Form From Calculated Field In Subform

Aug 21, 2013

I have a subform embedded in a main form, the subform has a field (text box) that is doing automatic calculation so no manual entries are needed from the user. I have tried to pass automatically the final result to a text box in the main form, but all events are not working (afterupdate, On change, On Dirty), etc.

I have a button to do the above mentioned in the main form, but I don’t want to use that button, I want to do all the process from the subform.

Also, from the subform I was able to do click on the button on the main form (programmatically), however MS Access is too quick and the value extracted from the subform is always empty (zero); Acees is finishing before the calculation is done.

I am using MS Access 2010.

View 4 Replies View Related

Save Data From A Calculated Control To A Field In A Table

Sep 14, 2006

i have a total in an invoice with is a tabulated form with totals in the detail footer I want to post the calculated total (control) to a table. How ia this done.

View 2 Replies View Related

General :: Changing Data Type Of Calculated Field In Table

Jul 18, 2013

I am trying to change the data type of a field in a table from calculated to something else. It gives me the error "this data type cannot be changed once the field has been saved"

Is there any work around to this?

View 2 Replies View Related

Calculated Form Data Not Populating Table

Aug 11, 2005

Hi all ... been awhile since I have had to create a database so I have gotten a little rusty. :eek:
I have a form where some of the fields I have formulated to calculate an amount. Example... =[GrossAmt]*[FeePercent] This is calculating into the form correctly but not writing to my table for that field. What am I doing wrong or missing here?

View 5 Replies View Related

Writing Calculated Data From Form To Table

May 22, 2006

Hi Guys, I don't know Access very well but I know enough to generate a 2 dimensional database. The problem I have is that I have been asked to look at a travel agents database to create some additional letters. The problem is that they use a form which has an underlying data table called customers. When they create a record in the form all fields in the customers table are filled in except those on the form which derive their data by calculating two or more fields i.e Date Due is [Date of Travel]-70 (days), Balance Owing is [Cost]-[Deposit]. None of these derived fields fill in their corresponding fields in the customers data sheet.

I would welcome any ideas please. Thanks in anticipation

PompeyFC

View 3 Replies View Related

Calculated Field From Form To Table

Sep 18, 2006

Hello,

I have been reading various threads about this subject and I know that one shouldn't store a calculated field in a table.

I believe this may be an exception to the rule (but I could be wrong).
I am making a pricing database that will use a few manual inputs and the rest of the fields will be calculations (gross/profit margin, expenses) based off these inputs. We need to have these calcuated fields stored because they are essential to the pricing decisions and we will have to go back and access these fields at a later time. Another reason for this is because there will be at least one report that will be used to compare prices and calculated fields associated to a certain product by company, program, item type, ect...


Any help would be greatly appreciated.

View 2 Replies View Related

Save Calculated Form Field To Table

Oct 3, 2006

I have a form which calculates alot of numbers. Im trying to figure out how to save the calculation to a table field. Is this possible? Can someone help me with a solution please

View 2 Replies View Related

Tables :: Calculated Form Field To Be Inserted Into Table

Jan 3, 2013

i want to insert a calculated value of a e.g field6 (field4 * field5) in forms into the database table. by using expression builders in my forms. i have made that feild and on click it shows the calculated value but on filling in the rest of the form and clicking on Insert button does not update this calculated field but iserts all other fields.

View 3 Replies View Related

Forms :: Updating Table With Calculated Field On A Form?

Apr 13, 2013

A textbox on a form concatenates 2 strings. I want to insert that resulting string into a table .how can i do that ?

View 1 Replies View Related

Queries :: Find Data In One Table And Put In Field Of Another Table Then Update

Nov 7, 2013

I have an "order details" table that needs to populate a field called "Voucher" with data from another table called "codes". The "codes" table also has a true/false field called "allocated" because once allocated the code cannot be re-used.

I am trying to work out how to automatically allocate the next unallocated code in the "codes" table to each record in the "order details" table when that order details record has a DiscountID of "92".

Order Details Table Fields and conditions/criteria:
ID - primary key
DiscountID - only when the DiscountID = 92
Voucher - only populated when Discount ID = 92

Codes table Fields and conditions/criteria:
ID - primary key
code = text field with a code like "einstein01", "einstein02"
Allocated = False

Is there a way to put the next available code into the order details record then mark that code as allocated in the codes table. Then, move on to the next order details record that has a discountID = 92, input the next unallocated code and mark that code etc. etc.

Ideally, I would like to do this to happen via an event when the Order forms button "Close" is clicked.

View 1 Replies View Related

Tables :: Update A Field Of Table A By Entering Data On Table B

Sep 14, 2012

Some days ago I made it by using "query", but now I forget it how I make the relation on this situation. Here is my problem.I have 3 Table on mdb file, named Table: A, B, Status.Table Status have One Filed with 1 Data: Dishonor

Table A have three fields

Sl Number: (Auto Number)
Status: Lookup wizard-data of (Table-Status)-Default Value is "Honor"
Amount:Number

Table B have two Fileds
Sl Number: Number
Status: Lookup wizard-data of (Table-Status)

After Entering Some data on Table A it's Look like as:

Asl numberstatusamount
1Honor5222
2Honor855
3Honor988
4Honor7777
5Honor777
6Honor9999

[code]...

Now I want to change the Status of SL Number Honor to Dishonor so I fillup data on Table B is as like following

sl numberstatus
5Dishonor

Now how I can get the result as following by using query:sl numberstatusamount
1Honor5222
2Honor855
3Honor988
4Honor7777
5Dishonor777
6Honor9999
7Honor6666
8Honor7777
9Honor666

View 1 Replies View Related

How To Update Field Of Table A By Entering Data On Table B

Sep 14, 2012

I made it by using "query", but now I forget it how I make the relation on this situation. The Sample file is attached.Here is my problem.

I have 3 Table on mdb file, named Table: A, B, Status
Table Status have One Filed with 1 Data: Dishonor

Table A have three fields

Sl Number: (Auto Number)
Status: Lookup wizard-data of (Table-Status)-Default Value is "Honor"
Amount:Number

Table B have two Fileds
Sl Number: Number
Status: Lookup wizard-data of (Table-Status)

After Entering Some data on Table A it's Look like as:

Asl number
status
amount

1
Honor
5222

2
Honor
855

3
Honor
988

[code]...

View 3 Replies View Related

Update Data From One Table To Another Only If Field Matches

Aug 28, 2014

I have to two tables and I was add data to second table only if the field matches. Lets I have two fields site and recid on both and I want to update site on the second table only if recid from the first table matches the recid from the second table.

View 1 Replies View Related

Calculated Field 2113 Error (After Update)

Nov 16, 2006

I got a problem, I have a calculated field which is sometimes empty due to no information being put there. Here is what I have in the afterupdate code:

FUTURE DATE = Me.Box123

The Box123 is my textbox and the FUTURE DATE is the datasource field.


When the field is blank I get the following error message:


I get a Run-Time Error "2113";
and the message "The value you entered isn't valid for this field"

View 10 Replies View Related

Modules & VBA :: Update Field With Calculated Result

Mar 19, 2014

I am trying to update a field with the result of what is in the field plus the contents of a unbound form field.

So if crm_order_det.Qty contained the number 5 and the form field (labelled qty) contained 7 I would like the field crm_order_det.Qty to end up with 12.

The code I am using

sql = " Update crm_order_det SET [Qty] = (" & _
frm!Qty + crm_order_det.Qty & ") where crm_order_det.part = '" & frm![SearchResults] & _
"' and order_id = " & frm![order_id] & ";"
DoCmd.RunSQL sql

However I get the following error

Run-time error '424': Object required.

View 3 Replies View Related

Update OnHandQty Table Field Based On Qty Field From Another Table / Form

Oct 30, 2012

I have a table called Inventory (table1 - PK=INVID) that contains all inventory ID numbers and descriptions. I have another table called Inventory Transactions (table2 - FK=INVID) that gets updated through a form. When a new transaction is made in table2, I want the transaction amount to get added or subtracted to an OnHandQty field in table1. I tried having table2 (transaction table) as the main form and then table2 as the subform, but I couldn't get table2 to update.

View 5 Replies View Related

Forms :: After Update Event Information To Table Not Getting Recorded

Apr 16, 2013

I have an after update event that populates, Date, Time and User into corresponding fields when the record status changes to closed.

However... Whilst the information is recorded on the form it does not record to the underlying table is there any reason for this, or anything that I am not doing correctly?

View 2 Replies View Related

Using Append Query - Update A Table By Replacing All Existing Information

Dec 6, 2013

Can I use the append query to update a table by replacing all existing information with updated information while at the same time adding all data that isn't currently in the table?

Right now every time I run the Append Query it just adds the same information as a new row instead of replacing the existing row with the updated information.

View 8 Replies View Related

Form Event (Before And After Update) Copy Form/Field Value To Another Table/Field

Aug 17, 2006

Group,

I thank you in advance for considering this inquiry.

From within a Form.field (based on a master table query), I desire to trigger two events; one before update and one after update.

This function will serve to document specific form.field value changes to a "log" table for review prior to being committed back to the master table.

What I'm looking for are functions, which I can use in a Macro or VBA code to facilitate a field read and copy before change and a read and copy after change triggering.

I'm sure this is absurdly simple.

View 2 Replies View Related

Forms :: Update Table If User Add New Data In Combo Box Field

Jan 9, 2014

I have a combo box that get its values from another table the problem i am having is when a user don't see the info they have in the combo box then enter the new data into the combo box field but it don't update my table with the entered values. How can i fix this to update my table if the user add new data in the combo box field.

View 3 Replies View Related

Forms :: Update Data From One Table To Another Table Using Form - Access 2010

Dec 16, 2013

How to update data from one table to another table using form.

I have data coming from design team in Database 1 and using form i want search data and assign the job to a person and store it in the database with his name. I have to do this because database from design team is read only.

View 1 Replies View Related

Forms :: Access 2010 Auto Update Calculated Date Field?

Jan 21, 2015

I have a database to track temporary decertification's. I have the expiration and max dates calculated out from the original dates at the top of each box. The temp expiration date is calculated by adding 267 days from the first date . When we enter an extension, the new expiration date is 30 days from the extension date. My question is, how can I make the expiration date update when a new extension is put in.

For ex.

Temp Decert Date: 05 Dec 2014
Temp Decert Extens 1:
Temp Decert Extens 2:
Temp Decert Extens 3:
Temp Experation Date: 31 Aug 2015
Max Temp Date: 04 Dec 2015

how can I make the expiration date update to go 30 days from what is in the extens field 1, 2, and 3 (respectively) instead of 267 days from the original date?

So I want it to look like this after updating a field

Temp Decert Date: 05 Dec 2014
Temp Decert Extens 1: 30 Aug 2015
Temp Decert Extens 2:
Temp Decert Extens 3:
Temp Experation Date: 29 Sep 2015
Max Temp Date: 04 Dec 2015

View 14 Replies View Related

Queries :: DSum - Update A Field In Specific Table With Info Form Another Table

Aug 5, 2014

I have a table products with a field "id_product" and "total" (Total items in stock)

I have a query with the fields "id_product" and also the field "total in stock"

I want an update query to update the field 'total' in table 'products' with infos from that query

For each id-product in table products, replace the field total with the field 'total in stock' from the query

So I want to update a filed in a specific table with infos form another table.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved