Can you calculate on correlated combo boxes in Microsoft Access 2007 - or doctor them so that you can?
I have a table called T_Quote with the following fields:
ID_Quote (an Autonumber field)
Customer_ID (a Foreign key)
QuoteDate (a Date field)
QuoteNo (a Number field)
I have another table called TL_QuoteItem which lists the items that can be quoted on and the cost of each item, with the following fields:
QuoteItem (a Text field)
QuoteItemUnitCost (a Currency field)
I have another table called: T_QuoteItem with the following fields:
ID_QuoteItem (an Autonumber field)
Quote_ID (a Foreign key lookup to the Autonumber field in the table T_Quote)
QuoteItemQuantity (a Number field)
QuoteItemDescription (a Text field)
Item_TL (a lookup to TL_Item in TL_QuoteItem with the following RowSource: SELECT [TL_QuoteItem].[QuoteItem], [TL_QuoteItem].[QuoteItemUnitCost] FROM TL_QuoteItem ORDER BY [QuoteItem];
In the query, Q_QuoteItem I have all of the fields from TL_QuoteItem, except that instead of
so that I could copy it and display the 2nd column instead of the first and call it:
I would like to be able to calculate on those 2 fields (Item:TL_Item and ItemUnitCost:Item_TL) and have a field called:
Is there anyway that these correlated combo boxes can "doctored" so that they can be calculated on?
Thank you for any help.
Keys to the Problem Can you calculate on correlated combo boxes in Microsoft Access 2007 - or doctor them so that you can?
First, I recommend an autonumber PK in each table.
But having an autonumber shouldn't affect formatting another column in the query.
Besides you can form the control on a report.
Should work as the controlsource of a textbox IF the combobox is names TL_QuoteItem and the UnitCost is the third column of the rowsource of that control and QuoteItemQuantity is another control on your form.
By the way, I would have a field in the same table as the quantity for Unitcost and I would populate it from the RowSource.
since costs can change over time and you want to freeze the cost at the time of the quote, you should capture the value rather
then pull it from a related record.
This particular error can easily be resolved with a few simple steps. However, if you are not confident in your ability to use the methods below or they do not fully remove the issue on your computer, you may want to seek the assistance of a qualified repair technician who is well versed in fixing Can you calculate on correlated combo boxes in Microsoft Access 2007 - or doctor them so that you can?.
- Back-up the Registry of your operating system.
- Find the Registry Key: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\OSUpgrade]
- Note: this Registry Key should already exist, if it does not exist, create it.
- Create a brand new DWORD Value that is named AllowOsUpdate
- Set the Value to 0x00000001.
- Close and reopen your Control Panel.
- Restart the Microsoft Windows.
Another Safe way to Fix the Problem: Can you calculate on correlated combo boxes in Microsoft Access 2007 - or doctor them so that you can?:
How to Fix Can you calculate on correlated combo boxes in Microsoft Access 2007 - or doctor them so that you can? with SmartPCFixer?
1. You can Download SmartPCFixer here. Install it on your system. When you open it, it will perform a scan.
2. After the scan is done, you can see the errors and problems which need to be fixed.
3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed
Related: How to Download Toshiba Satellite A205-S5833 Supervisor Password Utility v.184.108.40.206C r2 driver,How to Download Toshiba Satellite C675-S7104 Laptop Checkup v.220.127.116.11 driver,How Can I Update & Download Toshiba Satellite L655-S5117 Face Recognition v.3.1.3 driver,Method to Update & Download Toshiba Satellite L845D-SP4328KL Atheros LAN Driver v.18.104.22.168,How to Update & Download Toshiba Satellite R930 Network Device ID Registry Setting Tool v.22.214.171.124 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.126.96.36.19986,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.188.8.131.520,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.184.108.40.2069,Method to Update & Download ASUS K41VD Intel INF Update Driver v.220.127.116.115,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: How to Fix Error - can i reset my dell inspiron B130 laptop?,How Can You Fix - Can I rollback directX 11 to directX 9.0c if I restore my Vista 64 bit OS from the Windows 7 upgrade??,Solution to Error: Can not find explorer.exe in app tab in task manager.,How to Fix Problem - Can't change time - Can't use System Restore - Load Library failed error 32?,[Solved] Can you repeat 2 rows of a table over pages?,Can I safely remove earlier versions on my pc,Can I rotate a graph so it shows on my page sideways?,Can I safely ignore Office file validation alert message?,Can I send a JPEG file in a PDF form ?,can I review when my computer has been accessed from outside my home?