Database Discussion - help on access and excel

Print Page | Close Window

help on access and excel

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=5501
Printed Date: 30 March 2026 at 3:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: help on access and excel

Posted By: rhon101
Subject: help on access and excel
Date Posted: 03 September 2003 at 8:31pm

i have created a database in access that contains tables that has the number of tickets i have, the business that supplied the tickets and the contact person. i have also created a purchase order form in excel for when tickets are purchased. i want the database in access to be updated when i complete a purchase order. the number of tickets avaliable should change when one is sold on the purchase order. how do i link the two together. i had a class in vb6 a few years ago and i remember something about an ado data control. i don't remember much though can someone help?