Saving And Updating A Calculation

Dec 1, 2005

Hi
I'm creating a small stock control system. I want to be able to update stock levels. Simply by entering new amounts of stock when they arrive and adjusting for stock used that day. I've created a form from a query which takes current_stock level and then I enter a value (say 50) and it is calculated (added together). Then i want to save that new value back into the current_stock field?
Can anyone help??

Thanks

View Replies


ADVERTISEMENT

Saving A Calculation Field

Aug 12, 2005

Having some problems with a calculated field on a form. The field came from my table but I typed in the calculation (=[cost_price]+[sale_price]) and it works fine but it wont save to my table so when I run a repot off it doesnt have any of the calculated values because they arent saved in my table??? Can anyone help?

Thanks
Tom

View 2 Replies View Related

Field Calculation Not Saving To Database

Aug 26, 2005

I have the calculation =DateDiff("yyyy",[DOB],Now()) in the Data/Control source properties of a numeric field in a database/form which correctly calculates age in years from a date field DOB. How do I get this field to save to the database?
Georgina

View 2 Replies View Related

Tables :: Saving ONE TIME Calculation To Table

Nov 12, 2012

Access 2003. I am trying to save a calculated field (Item No) from a form to the accosiated field within the Products table

I have a hidden text box (itemNo) which is bound to the relevant field and a second text box with the following formula

="TV-" & Left(CatShort.column(1),3) & "-" & Format([ProductID],"0000") as its source

What I am trying to do is to provide an item number for each item of stock based on the Category short name (Catshort) and the incremented item ID Number, with a TV prefix.

I am aware that its a bad itea to place calculated field into the table if the calculation is likely to change, however once my calculation is stored it has no need to change.

I have tried the beforeUpdate method within the ItemNo textbox

Private Sub ItemNo_BeforeUpdate(Cancel As Integer)
Me!ItemNo = Me!ItemCalc
End Sub

but nothing happens (in that the table is not updated)

Any way of putting together an incremental item number based on the selected category with a "TV" prefix....

View 6 Replies View Related

URGENT HELP PLEASE! Auto-Updating Field Using A Calculation (Complex)

Aug 8, 2006

Hi, im relatively new to access but my problem is fairly complex.

I'm creating a database for a school project, and it is focused on improving the way a flying club runs.
I have been able to solve most problems myself, but this one truly has stumped me.

The basics:
There are two tables - Instructor Details
- Flight Completion

And one form - Flight Completion

On the instructor details table i have a field called 'Hours Flown'
The purpose of this field is to show the total hours flown by an instructor.
On the flight completion table i have a field called 'Flight Duration'
This field is for the duration of the flight the instructor just flew.

I want it so that when the instructor presses a button on the flight completion form, the duration entered into the 'Flight Duration' field is added to the 'Hours Flown' field and then the 'Hours Flown' field is updated with the new total.

I hope that is clear to you, but if not please let me know and i will try and clarify it for you.

I really do need help.

Thanks
Jared James

View 2 Replies View Related

Forms :: Updating Fields Via Code Not Updating Table

Dec 16, 2014

I have a form that has combo boxes and text fields (as well as sub forms). There is also a button linked to some code that says'

Private Sub cmdQuote_Click()
'Creates quote date and prints quote
Me.QuoteDate = Now()
Me.cbAgentID.Requery
DoCmd.OpenReport "Quote", acViewPreview, , "BookingID = " & Me.BookingID
End Sub

When the button is pressed the QuoteDate field (it is bound) should be be populated, but unfortunately it is not. I have played with refresh and requery but cannot derive a solution.

View 1 Replies View Related

Saving A Db

Jan 6, 2006

hi,

thought I was ok at access, obvously not. Think 'briefcase' has messed with my db a bit so started using a backup with ext .BAK. Want to save whole db as another name with ordinary extension. Will only let me SAVEAS on bits of db?

Sorry, I know this is a bit simple but that's about right for me.

Many thanks in advance

Les

View 1 Replies View Related

Saving

Mar 27, 2006

Hi all,
when the users are saving the form, i want to make sure they have filled in certain fields. On previous forms my code has worked, but for some reason on this form it won't, i usually put:


If tankID = "" Then
MsgBox ("Please Enter the Tank ID")
tankID.SetFocus
End If

Can anyone explain why it may not be working, thank you

View 3 Replies View Related

Name Saving When I Need ID!

Feb 15, 2007

Hi there,

I have a table which brings together a number of bits of info from other tables.

Part of the form is acting weird; The user selects an 'applicant', and a 'class'. On the form these are both combo boxes, with info coming from two tables.

Some properties of the two fields:
SELECT Classes.ClassCode, Classes.ClassName FROM Classes;
Bound Column = 1

SELECT Applicants.ApplicantCode, Applicants.ApplicantName FROM Applicants;
Bound Column = 1

Now, I want it to store the ID's of both (rather than the name). Both of these combos have the same properties; however when I look at the table, the applicants ID is being stored, but the class NAME is being stored in its field instead of ID>

Ant idea why this is happening for the class?

View 11 Replies View Related

Saving Value Of List Box

Apr 20, 2006

Hope someone out there can help.
I have a form (frmNewExceptionRepot) where the record source is a table (tblExceptionReport) there are a fair few controls on the form from this table and some controls that are based on queries etc

I have a cmd button - that takes the value of text boxes from a subform on this form and saves them to tblExceptionReport It also saves the record in general

This all works fine, however I am having a problem saving the value of a list box on the form (not subform) List156 to the table tblExceptionReport. The record source of the list box is a query that only ever produces one result, and its always the first row that needs to be updated to the table.

The data is displayed correctly when the form is loaded, but the value will only be saved if you click on the list box before the record is saved. I understand the theory behind this, as its a listbox an item need to be selected.
However is there a way to tell it to select the first row of this list box as the value?
I have tried various ways around this, but just can't figure it out. Should I be using a text box instread?
I had thought about basing the form on a query that contains all the information, so this list box can actually be a text box, but then it makes the recordset not updateable...which means lots more code on the save - if this is the only way round then fair enough!
Any ideas or help much appreciated!

I have highlighted in red the code currently in use to try and do this. (which works if you click on the list box before running the code.:confused:



Private Sub Command242_Click()
'save record
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
'Save the current dates and informaiton to the new record
DoCmd.RunSQL "Update tblExceptionReports set
CurrentVRF = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastVRF],
CurrentLandingSlot = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastLandingSlot],
CurrentPlanComplete = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastPlanComplete],
CurrentReqtsSolWShop = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastReqSolWS]," & _
"CurrentAlignmentReview = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastAlignment],
CurrentDSBBidPictureEvent = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastDSBBigPic],
CurrentCostBenefitEvent = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastCostBenefitWShop], CurrentDSBDetailedEvent = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastDSBDetail]," & _
"CurrentITExecutiveReview = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastExecRev],
CurrentITSupplierPropIssued = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastITSuppPropIss],
CurrentSellByDate = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastSellByDate],
CurrentViabilityReport = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastViabilityReport]," & _
"CurrentProgramBoard = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastProgramBoard], CurrentProposedImplementation = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![Proposed_Implementatation_Date],
OverallRAG = [Forms]![frmNEWExceptionReport]![List156],
CurrentSpendBudget = [Forms]![frmNEWExceptionReport]![List240]" & _
"WHERE tblExceptionReports.ExceptionReportID = [forms]![frmNEWExceptionReport]![ExceptionReportID]"

End Sub

View 1 Replies View Related

Saving Options?

Aug 10, 2005

I'm trying to create a database for a taxi-type service that runs on thursday, friday and saturday nights. My question is: Is there a way to save the database at the end of the night separate from the previous nights, and so that the database is empty for the next night, but reports can be viewed for all of the nights combined?

Any help would be greatly appreciated!

-Rusty

View 1 Replies View Related

Saving Problem

May 19, 2006

Hi All,

I have a annoying problem. Since yesterday whenever i make changes to anything in my database, it doesn't ask me if i want to save the changes, it just does it automatically. It is annoying, as sometimes i am testing things, say on a query and if it doesn't work, i just go out of it and don't save the changes and have my original version.

I have another Access database and this works fine, with the pop up message asking if i want to save the changes or not.

Can anyone help, or point me in the right direction, thanks.

View 2 Replies View Related

Saving An MDB File As MDE

Nov 28, 2006

I seem to be having problems saving my database files (.MDB) as .MDE files.

I have a database that only contains data (tables).

A second database is used as the interface to this data (it contains forms, reports, and uses linked tables to the data database).

This secong database file is then copied and used my a few users, so that everyone is accessing the same set of data.

I am trying to save the second database as an .MDE file, but under the Tools, Database Utilities option... 'save Database as an MDE' is never highlighted as a viable option. Is there some trick (or conditions) to enable this option?

I am basically doing this so that I can distribute the MDE version of the interface so that users will have limited / no access to be able to modify the code (or get into the table?).

Thank you for any advice or directions you may be able to pass on.

-arm1

View 4 Replies View Related

Columns Not Saving Where I Placed Them.

Jan 24, 2007

Hi,

I'm new at access but getting the swing of it. It is a pretty cool toy.

I have a table that I am adding various columns of data. Once added I move the columns to where I want them to be. I am hitting the little save disk on the top toolbar but when I reopen the file the columns are not where I placed them. I'm not sure why this is happening. Any thoughts?

Thanks in advance for your help.

Eddie.

View 6 Replies View Related

Updates To DB Not Saving

Jul 2, 2007

Hi

Have a bit of an odd problem with the DB im using at work. I have 1 DB on a shared drive that is accessed by 4 of us from our desktop PC's (password protected via 1 password that we all use - no separate logins).

The problem comes that we make changes to the data, exit via an exit button that uses a save all macro (that all works fine), however when we go back into to DB there are some times that the changes made have been lost and the data has reverted back to the previous version. There doesn't seem to be any specific pattern to this, it happens at random times and to random people.

Does anyone know what may be causing this, or anyway that i can prevent it happening?

much appreciated.

View 1 Replies View Related

Saving Time

Jul 4, 2005

Hi,
I have been tasked to create a database that will be accessed through a dial-up connection to our server.
What I want to know is which is faster
1 Using a seperate table for dropdowns or
2 Using the lookup facility of a table.
cheers

Gordon :confused:

View 2 Replies View Related

Saving Lists

Jan 23, 2008

Hello,

I have a main form where the user can click on a button that opens another form. In this form, the user can make selections from one listbox and they are copied to another listbox.
How can I save the contents of the listbox into a field that is part of the record on the main form? Can this be done?
I have a listbox on the main form where the selected items will be displayed and each record of the main form will have different values for the listbox.

Any ideas?

Thanks,
Mike

View 1 Replies View Related

Saving Forms

Feb 24, 2005

I have created Several Forms but I am not able to save any new records in them.
When I click the add new button the records are added alright. but when I exit the form and reopen it all the new data added to the form is lost.
I even tried the save button but that doesnt help.
anyone has ideas what happening here..

Regards
Rahul

View 2 Replies View Related

Saving Dates

Jun 13, 2005

I have a form in which an individual has to input a date then choose a category. This is for keeping an individual's time. I want the date that user user first inputs to be the default date that is shown automatically unles the user changes the date, at which time, I want the new date to be the default. Can anyone tell me how I could do this?

View 2 Replies View Related

Saving Keys

Jun 27, 2005

I have a form in which a user uses multiple combo boxes to choose certain items. each item in the combo box has a key attached to it in the table that the form was created from. I would like to save the appropriate key on my form next to the combo box. If this is possible, how do I go about doing this?

Thanks.

View 3 Replies View Related

Check Box Not Saving

Sep 3, 2005

I just spent all day redesigning a form and putting in check boxes from the tool box, but when I saved the whole thing and tested it by clicking in the check boxes to put the check marks in the boxes and then clicked save, it did not save the check marks! AARGH! When I went back to the form all the check boxes were empty. Why won't it save the check marks? Please help. Thanks.

View 10 Replies View Related

Trouble With Saving Changes

Oct 26, 2005

:confused: Hi,

I've put a button on a form (lets say form 1), that when clicked opens up form 2.

Both forms are connected to ONE table each.

There is a sub table on form 2 that displays records with the same Id as on form 2.

The Problem is when I open The table that feeds the subtable. If I change the A to Z ordering on this table, whenever I close form 2 (not from design view, from user view), it asks me whether I want to save the changes to the design of the table feeding the sub table (the subtable that is on form 2, that is)?

When form 2 is closed there are calculations that are made and data is updated on form 1. I don't know if this is part of the problem? or perhaps I have set up the subtable incorrectly?

Please help!

Thanks

Peter

View 5 Replies View Related

New Record On Saving

Apr 5, 2006

Hello guys

I have one small quick question. How can get blank or new record after saving

Cheers

View 3 Replies View Related

Saving Data

Oct 12, 2006

I have a form "release_details" having fields date, version, cksum ,comments,labels, and is link to a table,
it has a button "mai"l ,on clicking this button a new form is open which has a button "send mail" on clicking this a mail is sent and pops a message "mail sent".I need when "send mail" is click it should also save the fields of form
"release_details" to the table.

Thanxx

View 6 Replies View Related

Saving Records

Dec 20, 2006

I have a form that shows entries based on other parameter values they are changing when new searches are used. I created another form that shows the entries I would like to save and they are bound to the other form. I can view the data in the second form one by one based on what happened in the previous form but when I close the first form the data goes away in the second and leaves me with a #Name?. I am trying to come up with a way to save every different entry and create continuous records on what was entered. Is there a way to have the text boxes be bound but still save the record and just create a new record for the next entry? I tried the save record option in the records menu but when I close out it is gone. Thanks.
Mitch

View 1 Replies View Related

Saving Data

Oct 5, 2007

Hello, I'm new to this whole microsoft access program, so I'm learning from scratch. My question is I can't figure out how to save the database, so that I can go back into it later. This is a tutorial that I'm working off of in my online class, so once I exit out and go back in, all the info that I inputed is gone.

View 2 Replies View Related







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