Summing Values On A Form, Then Further Entering In Table
Sep 1, 2005
Hey there, Im currently making a form so users can enter project information. For this particular project, the user must choose from a variety of options, and each option has a number value assigned to it for a rating. Now at the end of this form, I want a sum of the ratings, and then entered into the table. I am using a text box for the sum of ratings, and can get the sum of ratings to work on the form, but this data is entered as a 0 in the table. If anyone could help me find a way to put the actual sum in the table, that would be excellent.. thx a lot.
If it would be any help, here are the names of text boxes that I'm adding:
Health and Safety Rating, Maintenance Rating, Equipment Rating, School Size Rating, Student Enrollment Rating, SD Priority Rating, Project Requested Previously Rating
I am new to VBA, and i need some help in my system..... basically i am creating a appointments Form, and in this i have some txt fields and a listbox which contains the available times ... What i want my form to do is that as the user enters the values in the form and the time selected, as clicking the "set Appointment" button it should add the values to the table.
I have included a word document of my form: Just as some help... Could you guyz help me with the coding... I am not at all good at coding! Thanx alot guys.. I really appreciate your help!!
I have a form for entering Retirement Plan information (frmRRSP) that has tblRRSP as its recordsource. The RRSP Rate is a field with a Number datatype (in the table) and a Percent format on the form. When I enter a value on the form it originally displays the value I enter, until I press the Enter key, then it changes to "####" an enters a value of 0 in the table field.I tried entering a value directly in the table and it changes to 0 when I press Enter.I have an almost identical form and table for Vacation and it does the same thing.
I need to enter workload counts for 10 people, and it is done on a monthly basis. So I have a table of Months (Jan-Dec), a table of names, and a joined table with the months, names and a field for the workload counts.
I would like to make a form where I could select the month and all the names show up so I could go and enter the counts for everyone at the same time. I've attached a diagram to show what it would look like
Would someone be kind enough to look at the following two attached mini databases. I have this recurring problem when I set things up that I cannot get some figures to appear in the table - only on the form.
In Example 1 I am trying to get the Total Score to show up.
In Example 2 I am trying to get the corresponding score to the description to show up.
I think it is something to do with me referencing the field not the look-up table but I really don't know any more.
[AR&R Hours]+[PTO # of Hours]+[Meeting/Calls # of Hours]+[System Issues # of Hours]+[BAU Training # of Hours]+[Exception Processing Hours]+[AIG Related Activities]+[Admin Work Hours]+[Migration Hours]+[Project Hours]
Need the fastest and easiest way to auto calculate the above in a field on a form. i can get it to calculate in a query but need it to do in the form as well.
i have created a table that would calculate the total payments that are being made by a certain contractor. I am assuming that the contractor pays the money in three installments.
In a table I have created three fields which are all checkboxes that would state whether a payment has been made or not, for example, checkbox1 would state whether the first payment has been made. And I also have three other fields that states the amount to be paid on each installment
Now, i want to calculate the total amount that have been payed. For example, lets say that the first installment has been made (i.e the checkbox is checked), then the first payment should be added. And if the second payment has been made it should be added as well, thus finally giving the total amount that has been made.
I know how the logic should look like, but i just don't know the syntax that i should use in the query.
BACKGROUND: I have a query, in which the user decides a customer name. According to the customer name a specific custom price is chosen for the customer from tblInputProductSpecs. Based on this I do the following calculation Total Price:[Price]*[Quantity], where the quantity is already known.
PROBLEM: Since the Total Price is total price for a specific product. I wanted to calculate the TOTAL of all the Total Price/Product. But finding it really hard to do this. I tried to do Total:SUM([Total Price]), but this doesn't work. I get an error. I even tried Total Price:SUM([Price]*[Quantity]), but this also doesn't work. Is there any possible way to find this TOTAL?
I would really appreciate your help with this frustrating problem.
I have three account types (Student, Departmental, and CC). On a fiscal month, each has a certain amount of counts per fee type. I want to find the total number of items among the three account types.
For example: On July 2006, The "Student Account" has 437 "Items Deposited" The "Dept. Account" has 2,691 "Items Deposited" The "CC Account" has 0 "Items Deposited"
I want to find the sum of these three (3128). I have 102 different months and 7 types of fees onto which I need to do this.
I have made a table and I enter data in that table through a form. The form also include two sybchronized comboboxes. When I select a category in one combo box, corresponding items are selected in second combo box. The problem is that when I select the category in the form (with ID+Category Name), it stores only the ID in the table. How can I see the Category Name in the table (which is the control source of the form) instead of ID?
I have a number of fields that hold values (scores - either 0,1 or 2) that need to be summed but in some cases the value is 99 (which is recognised by our stats program as a N/A type of anwer- This occurs when a question is optional and the user hasnt answered it. I did not want to value to be null (since its not like the user didnt answer it because they missed out on it by accident but rather they could not) and it couldnt be 0 either since 0 actually means something different in the context of the questionnaire.Lets say I have Q1 which has a value of 0, Q2 has a value of 1, Q3 has a value of 99 and Q4 has a value of 2I want to get the total of Q1+Q2+Q3+Q4 for a particular entry but if the value of any or all of the questions are 99 I want access to ignore it and just sum the rest of the values i.e. the sum should read 0+1+2+(99)=3 not 102I want to be able to include this sum function in the expression builder if possible since I am using it for a report. Can someone please help?
I have created a report and i am having trouble with the =Sum() function. I would like to sum all the values that are held in a text box which has the expression of '=[BookingSF_Qry subreport].[Report]![TotalSF]*[HowManyDays]'. No matter what i try i cant get a total value of all of these.
Hi!, I am trying to make something to make my job easier. To be honest I am a beginer in this field. I am having a field, when I enter one value ( let that be 10) it should pop up one form and if another value ( let that value be 20) it should pop up another form. or else I can explain in this way If data field value = 10 then it should run macro 1 & if data field value = 20 then it should run macro 2
I have a 1 row table as a result of 2 queries that give me the 'MaxYear' AS 'DefaultYear' and 'MaxWeek' AS 'DefaultWeek' in that year for a selected retailer and stores, from a master table.I want the default Year and Default Week text boxes to display the values of these
I have tried pointing to a table holds the results and pointing to the queries for each box...I have used Form.Refresh and Forms.Requery but nothing picks up my values.
I have a sales form. The sales form has many Call, Meetings and Emails linked to each sales record. I want to total all the number of calls, meeting and email records related to the sales record to give a total- Touches.I've created 3 queries;
These all work fine however when I combine them to attempt to count the results it doesn't produce the correct results.I have a second query as well (no pun intended).
I am trying to sum together a column that has values in Time. The results displays as a decimal. How can I have the result display as a Time i.e. 1:20 (1 hour 20 minutes).
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
I have to admit that I have been staring at this this problem for some time now and can't seem to solve it. Hopefully someone from this form will be able to help...
The attached jpeg of my continuos form has the "traditional" access #Name? error in it. The text box's contain the formula to sum each column they are under i.e: =sum([txtamount]) , =sum([txtFinalForecastCost]), =sum([txtCostToGo]). They are located on the form footer section. If I delete the last text box the other two text box's sum ok, but all three generate the #Name? error. Any ideas on how to get around this so all three sum?
This continuos form is a sub form of the main form and the last column is a calculation of: Forecast - amount = CostToGo
I have run into this problem with several databases I have created. I have my tables all set to store my information. I create the form to enter the information. I try to create the field to calculate a total and every time I enter the amount in the form, I get '?name' or '#name'.
With this particular database, I am looking to track expenses. Expense categories on the left, dates across the top, amounts in the middle, totals across the bottom for dates and down the right for categories.
If there was a way to attach a document, I would send the expense report. If you want to look at it, let me know and I will send it. It's a small xls file.
Could someone check the following code. i've set up a form for creating regular bookings, and have a field, for which you type in the frequency in days you want the bookings for. (ie, 7 days for every week on that day, 14 for every two weeks etc...) and it seems to work, however it just alters the one record, instead of creating entirely new ones. Could someone please help:
Private Sub cmdCreate_Click() Dim date2 As Date Dim period As String Dim cost2 As Currency Dim frequency2 As Integer
Do While year = actual_year
date2 = Date_For period = Time_Period cost2 = Cost frequency2 = Frequency
Date_For = date2 + frequency2 Time_Period = period Cost = cost2 Frequency = frequency2
DoCmd.Close acTable, "tblRegularBookings" Loop
End Sub
Also, one of the other problems i'm trying to solve is for those who want to create a regular booking but on say every third monday of the month for example.
I apologize if this has probably been asked countless times; however, in my search of this forum I could not find something that seemed to work for something so simple.
I have 2 forms. The first form is my main form and the second form is my "popup" form. Both of these forms access the same table. In my main form I have it so people can not enter in a ID so it reduces accidental data entry. Therefore, I created a "popup" box that allows ID entry.
Everything works great except when I close out of the popup form, the newly entered data is not available unless I close the main form and reopen.
Million Dollar Question:
How do I refresh or requery (dunno the correct term usage here) the main form to reflect the addition I made in my popup form. I would like the refresh event to happen when I click the close button on my popup form.
I am creating a log in form, it checks the user name which is unique. if the user has entered a password, it shows only one password text box, they enter the password, if it is correct they enter the database, otherwise they return to the text box.
But if they have not entered a password before the form opens with two text boxes, one for the password and one to confirm the password is typed correct, if the are different a message box shows telling them that they are different, now is where i having problems, when they have typed the two passwords and they are correct i want them to save this password in the same record "Password" as the selected "username" record, I can find the "username" record by doing a Dlookup, easy, but i am stuck how to then save the password from the text box where the selected username record is.
My table "staff" has fields of "IDStaff", "FirstName", "Surname", "Password", "Username".
Purchase Order with main details on (Po Number, Supplier etc) with a sub form carrying the line items to be ordered.
Table PO Form PO Table POSUB Form POSUB
When entering main order details into Form PO, why do the fields in the related table(Table PO) immediately get populated when the the focus gets transfered to the sub-form (Form POSUB). with users quiting the database illegally (not by the cancel records button) the result is unwanted records in the Table PO.
What I want to do is complete the input fields in the main and sub forms without any records being commited to the tables until the "Save Record" button is pressed.
