Toner Qty
 |
 Genuine Ricoh Savin Lanier Toner Type MP 4500 8045e LD345 Qty 6 841346 4500  US $239.00
|
 V7 C9700A C9701A C9702A C9703A 2500 TONER QTY 6 NEW US $199.99
|
 Kyocera TK 867 Black toner Qty 2 US $160.00
|
 Kyocera Yellow TK 867 Qty 2 Toners US $160.00
|
 New OEM Lexmark 1382625 Black Toner Cartridge SEALD Qty US $125.97
|
 New OEM Lexmark 12A0825 Black Toner Cartridge SEALD Qty US $122.47
|
 Panasonic FQTA 20 Black Laser Toner Bottles Qty 6 New US $89.99
|
 RICOH 889317 COPIER TONER QTY 4 BRAND NEW FT2010 FT2050 US $89.99
|
 New OEM Lexmark X8302KH Toner Cartridge SEALED Lg Qty US $69.97
|
 MINOLTA 3050 4050 COPIER TONER 401A 650g QTY 1 BOTTLE US $53.99
|
 IBM 1348349 BLACK TONER IBM 3812 PAGEPRINTER QTY 2 NEW US $52.19
|
 Genuine IBM 1402680 Toners 3160 Infoprint 60 5 QTY US $50.00
|
 Toshiba TK 05 Black Laser Toner Cartridge Qty 3 NEW US $44.98
|
 TOSHIBA T68P BLACK COPIER TONER BD 9100 QTY 3 US $44.09
|
 TOSHIBA T68P BLACK COPIER TONER BD 9100 QTY 4 US $41.39
|
 Qty 2 GENUINE KONICA MINOLTA PC UA950 414 BLACK TONER FOR 7033 7040 7045 OEM US $39.95
|
 Qty 6 New Ricoh FT Type 5000 Toner US $38.00
|
 RICOH FT TONER TYPE 5000 RICOH FT TONER QTY 8 BOTTLES US $35.99
|
 Canon FX3 L4000 4500 Toner Qty 2 Compatible US $34.00
|
 Genuine Gestetner 3225 Toner Qty2 9925DP 5025 889617 US $29.00
|
 SHARP SF 230NT1 COPIER TONER QTY 1 NEW COPIER TONER US $26.99
|
 KONICA 947109 TONER NEW QTY 1 US $26.99
|
 NEW Panasonic DQ BFK10 Toner Bag Qty 4 for DP 8130 6530 Genuine US $25.00
|
 GPR19 TONER FOR CANON IR 7095 QTY 2 US $24.99
|
Help with MS Access?
Hey everyone.
Im creating a simple database for toner management, currently have a table that records the issue of toner, but now I have been asked to enable a stock control part to it. I know I have to create another table for toner qty of toner in storage. How would I be able to get access to update the qty table when one toner is issued?
Tables used are TblTonerIssue and TblToner, I know they would have to be linked via relationship and know that it would be the toners own model number as primary key in TblToner and a foriegn key in the other. Can anyone help?
Yes you would use a relationship between the two tables to help update it, but you will also need to creat an update query.
Go to Queries in your access database, the click "Create query in Design view". Add the tables that you want to work with in the query. Then from the Access menu bar click Query, then Update Query. What an update query does is looks for certain records then updates those records with the data you want.
You'll want to specify the fields you are using to filter the list and that you are using to update your data. Right click in the criteria section and click build to help you set up the criteria for filtering. The update to section tells Access what value that you want to update that field to. You can right click and use build for that to, so you can pick the value from a form, table, query or whatever.
After you build the update query, go to the form that you will be working off of and add a command button to the form. Make sure to have the magic wand clicked/selected so Access will help you with setting up what the command button does by starting the command button wizard. Go to the Miscellaneous category then select the run query action. Select the query you just created then work your way through the rest of the wizard. Once your done with the wizard, all you have to do is pretty much click that command button to run the query and update your records.
dtango09 - Welcome to dtango09 Eumora Shop
You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
Comments are closed.