Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Old 06-29-2015, 12:55 AM   #1
Join Date: Jul 2012
Posts: 126
Thanks: 23
Thanked 0 Times in 0 Posts
Moore71 is on a distinguished road
Update, Append other tables from sales form using VBA

I want some vba codes to update Item table from sale table using criteria
fields to update are Item.QtyAvailable [Item Table] deduct sales quantity from Available Quantity in Item table

Customer.Account [Customer Table] debit this account of total Amount ordered from sales table

my sales table fields are [sales.QtySold, sales.Amount]

remember multiple items are ordered in one transaction with InvoiceID as criteria

Append sales transaction to table ABC with vba code.

Please your help is important because i have been using query and sometimes it worked or sometimes not, I don't know why.

Moore71 is offline   Reply With Quote

append , inventory , update , vba

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use append query to update data in three tables? Garindan Queries 8 02-04-2011 04:56 PM
Performing Update and Append Queries on Linked Tables in Access jumadenice SQL Server 3 07-12-2010 07:02 AM
Stock and Sales Form/Sub/Append!?? Help james_IT Forms 9 11-10-2006 06:15 AM
Update an Append Query as tables grow teresap Tables 1 05-12-2004 07:30 PM
Using Append Query To Update Tables mrssevans Queries 8 06-09-2003 07:29 PM

All times are GMT -8. The time now is 10:51 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World