I have a field called PriceSoldFor and I need to calculate and display this field multiplied by 3.4%. This is what I have tried and reading elsewhere it should work:In the Control Source of an unbound TextBox I have entered the following:
=[PriceSoldFor]*[.034]
Ads: Technewonline is a website that specializes in introducing the latest technologies such as Best Tablet Android Have Price Under $200 and Best tablet of Apple in 2014 and The Best Midrange Smart Phone In 2014 and Top Best Ultrabook Of 2014 and The Best Phones 4G Valued At Under 300 USD is also a website for sharing your tips about computers, mobile phones and tablets, products are available from leading supermarkets will surely satisfy you.
But when I view the form the field displays the following:
I have a field called PriceSoldFor and I need to calculate and display this field multiplied by 3.4%. This is what I have tried and reading elsewhere it should work.In the Control Source of an unbound TextBox I have entered the following:
=[PriceSoldFor]*[.034]
But when I view the form the field displays the following:
I am trying to find away to allow the user to put a calculation in a textbox, like you can in an Excel cell, and have it return the value in another textbox. For example, the user types in the one box "2*20/4" and put the value(10) in another box.
Here is my code and I have tried many things, but here is my latest try:
I'm currently using a Dlookup function to display a calculated field from a query. This works fine when only one record is entered on the many side; however when additional records are entered it doesn't add the additional records. What function/code can I use to add each record's total as it's entered on the many side?
This is what is working when the many side only has one record:
This has been working perfectly fine however the TotalPrice is no longer calculating the UnitPrice x Quantity and the TotalCost isnt calculating as nothing appears in the TotalPrice. However when we click the fields the data is diplayed but only on clicking, if we leave the record and go back its back to blank again.
I have a combo box on a form that is liked to a table (current). That table has a list of available items and a count at the end of it. For example, apples, bananas, strawberries, blueberries, 4. Is it possible to have the combo box on the form subtract 1 from the count when an item is selected from the list? So when apple is selected the count of 4 is changed to 3.
Is this possible? In my invoice form I have 3 different tax rates. I have put a calculation in each of the Control Sources to calculate the invoice sub total:
=[Invoice Sub Total]*0.13 =[Invoice Sub Total]*0.05 =[Invoice Sub Total]*0.09975
I don't always use all the tax rates. I would like to be able to go back into a tax rate field I don't need and delete it.
I am creating a driving school database and have four different tables. Student, Instructor, Lesson and Lesson Type.
In the footer of my subform which works out what lesson type the student has taken and from which instructor, I have created a calculation to multiply the number of hours a student does to what type of lesson they take.
=([LengthOfLesson]*[cost]) (This works ok)
I then want to add all of these options together. I have tried:
=sum([OverallTotal]) in the footer (This doesn't seem to work)
and then
=[Booking].[Form]![OverallTotal] to show it in the form
The name of the subform is correct (booking) and name OverallTotal is also correct but I keep getting #error message.
2 Forms 1) - Employee Details (source control is "QEmployees Extended") 2) - Employee List (source control is "QEmployees Extended")
in Form "Employee Details" there is field named "HireDate" this field is also found in the table (records) "Employees" and "QEmployees Extended".When Form "Employee Details" is ran the "HireDate" appears as it should in the "HireDate" text box.
What I want to do is add a unbound text box to Form "Employee Details" named "txtYrsEmp" (Years Employed). and perform a calculation that will take the "HireDate" (date) and compare it to "Todays Date" and come up with the number of years employed rounded by 2 and show this result in the unbound text box called "txtYrsEmp"
Now I did a Qurey just to see if I could calculate what I wanted- "QYrsEmp" where in the first column I entered in the Field row (top) Expr1: EmployeeID from table Employee and in the second column I entered in the Field row (top) txtYrsEmp: Round(DateDiff("d"'[HireDate],NOW()/365.25,2))
Now the query returns the exact results I want so I know the calculation is possible at least here in the query.
I have a bound form to an invoices table. The form details all invoices raised, all payments made and an outstanding balance. The outstanding balance control is just a basic text box.
On form load, I go to the payment table and select all payments into a recordset, I then add up all payments and use the following calculation:-
Balance = InvTotal - paytotal
The Invtotal is the control on the form that has it's control source set as sum(invoicetotal)
The calculation used to work and the correct balance was displayed, indeed, for one particular client, the calculation works, but for all others, the summed value is blank and so the balance is effectively set to the paytotal value.
I know this is to do with the timing as the form loads and it's records/data are made available, as I have an update button that does exactly the same things as the form load and when pressed, all numbers work.....primarily because the summed invoicetotal value is now available in the form control.
I can see what is happening, but not sure why...I thought that form load gave you all records and would have populated the summed control before triggering the load event....obviously not.....
I'm pretty new to Access. I was wondering if it's possible to make a calculation for a specific row in an Access form.
I placed an example in the attachment (I made it quick in paint, because the actual Access form is in my language "Dutch" ):
Value1 and Value2 come from a database, so the amount of rows can change. When I click on "Calculate" on the first row, it should calculate 12 * 13 and show the solution only on row 1. If I click on "Calculate" on the second row, it should show the solution of 10 * 20 only on row 2.
I tried to solve this by using the following VBA code:
Private Sub Calculate_Click() Solution.Value = Value1.Value * Value2.Value End Sub
But if I click on the first "Calculate" button, it will fill all solutions with the first calculation (12 * 13).. The same happens when I click on "Calculate" on the second, third row etc.
1. I have 12 unbound text boxes in the unbound form in 6 pairs.
2. Text1 receives the arrival date and Text2 receives departure date, Text3 receives arrival date and Text4 receives the departure date and so on.
3. A person may have any number of arrivals and departures between 1 to 6.
4. The person should not stay in this country for more than 6 years.
I need to calculate from the final departure date, the total number of days the person stayed in this country and the remaining allowable years months and days the person can stay in this country ( deducted from the 6 years period ).
5. Please note the final departure date can be in Text2 or Text4 or Text 6 field.
I am trying to create a new macro in my database. I selected the Openform action and tried to choose the name of the form but when I try and select the name of the form from the dropdown menu, I receive the following message: THE SEARCH KEY WAS NOT FOUND IN ANY RECORD.
I am not able to see any of my forms on this dropdown menu.
Can anyone please help. I am using Microsoft Access 2002.
I have created a table in Access 2000 that contains among other things, hyperlinks to .txt files. This is a CD database, and the hyperlinks link to .txt files (local) containing track listings. I have designed a form that displays each record (CD). I can get everything to display except the hyperlinks. How do I tell Access (w/VB) to AUTOMATICLLY display these .txt files (w/o prompting) as users scrolls through individual records? I don't want to manually enter the paths, and I don't want to have to click the hyperlink to display it. Just like the other fields, I would like them to display w/o prompting. Any help would be greatly appreciated.
I have two table data base (Patient Info) + (Referral Info) with one to many relationship.I devised a form to display patients information and their mental health diagnosis. On my referral form (subform) I have I have list box facility with various possible diagnosis. What I want to do is ... if the user selected "Dementia" from the look up/list box...
I want to display a Butterfly next to the patient's name (Main form)
(1) I don't want the picture to be in C drive rather I want the picture to be part of the database
(2) How can I put the conditional display (if Diagnosis is = "dementia" then Butterfly)
the [EFS] and [CB] is one of the team for handling the project but after I execute the query as below , it just show -1, 0 as the picture but they are orginally Yes/No box from the table, how can I display the result as a Yes/No box instead of -1 ,0
-------------------------------------------------------------- SELECT Projects.[Project Name], Projects.[EFS],Projects.[CB] FROM Projects WHERE (((Projects.[EFS])=Yes) AND (([Forms]![A]![EFS])=Yes)); UNION SELECT Projects.[Project Name],Projects.[EFS], Projects.[CB] FROM Projects WHERE (((Projects.[CB])=Yes) AND (([Forms]![A]![CB])=Yes));
I've got a form about personal attendance list (table: ATTENDANCE) where I need show their photos (these OLE images are save in another table PERSONAL)
How I can show photos in the attendance form ? Thanks
