How to subtract values from textbox in form from Field in table (Access '07 VBA)? -


i developing canteen transaction system in ms access 2007. in "add food item:" form, have series of textboxes , comboboxes, button, "add item" , listbox. names of text , combo boxes follows :

textbox names: txtrate, txtqty

combobox names: cbxicode, cbxitems

on click of add item button, selected item quantity, rate etc. gets tranferred listbox. (i asked asked transfer question here)

now, in tblitems, there "qtyavailable" field indicates available quantity of existing food items. how i:

  • subtract quantity of food item user enters qtyavailable field in tblsampledata?

advanced appreciated.

thanks,

s sandeep

write query def performs task on table. can set parameters in query def enclosing them in square brackets. when ms access not recognize name in square brackets, prompt user value.

once works correctly, search net vba examples on using ado or dao copy of query def in memory, set parameter value(s), , execute query. recordset select, execute insert, update, , delete


Comments

Popular posts from this blog

c++ - Function signature as a function template parameter -

algorithm - What are some ways to combine a number of (potentially incompatible) sorted sub-sets of a total set into a (partial) ordering of the total set? -

How to call a javascript function after the page loads with a chrome extension? -