Question about Microsoft Office Access 2007 for PC
Hi, I have created a form in access 2007 called customer deliveries which is linked to a table called customer deliveries. On the form I have created a text box (called date delivered) which has a calculation as the control source based on another field in the form. After the calculation is done on the text box I want the value to be updated to the customer deliveries table in the relevant column of that table (date delivered). I have tried several types of insert into statements but have had no success in the table being updated. Can you please help me with this? Thanks Meagan
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Hi Raul from your description it is very unclear what you are trying to do. First we need to know what information is on the first form, second unless you are trying to do a subtotal of all orders in the subform there is no real need for you to create a subform. Now if you are trying to create a subtotal form for all records, you will have to set it up in the record source of that subform with group by: 1. Right click on an empty space on the subform 2. Click on properties 3. Choose your table(or query) which is the record source of the main form. 4. Select Payment and items(or what ever you are trying to calculate). 5. Press the group by button 6. In totals instead of group by choose sum. 7. Exit and save 8. Now when you will select the control source you will see "sumofpayment" etc... just select them for each textbox. 9. To create the third text box you will have to use the Expression builder and just do [textbox1]-[textbox2] * for some reason the nz function does not work in this case. I hope that helped you I will be able to give you a better answer if you give me more details... Let me know what happend Good luck Daniel
Posted on Sep 06, 2007
If you select the correct table from the drop down, the fields should be shown in the box. or keep the table open and try creating form. or create a blank form and on the right side you will get tables and fields, you can just drag and drop required fields
Posted on Aug 22, 2009
If field A1 is the old value and A2 is the new value, then the formula for A3 (% change) is:=(A2-A1)/A1*100You can remove the *100 if you want to format the field to the Percent type.
Posted on Oct 11, 2011
Assuming that the Original Value is in cell A1, and the New Value is in cell B1, then the formula for % Change pin Value is =(B1/A1)-1.Format the value in % style and you're done.Rgds,Scott
Posted on Nov 23, 2011
Tips for a great answer:
Nov 25, 2013 | Computers & Internet
on Jan 21, 2010 | Computers & Internet
Jun 16, 2009 | Microsoft Visual Basic Enterprise Edition...
May 14, 2009 | Microsoft Access 2003 for PC
Feb 10, 2009 | Microsoft Office Professional 2007 Full...
Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...
Nov 11, 2008 | Microsoft Office Standard for PC
Aug 23, 2007 | Microsoft SQL Server Standard Edition for...
37 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: