By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,479 Members | 2,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,479 IT Pros & Developers. It's quick & easy.

Programatically Update Multiple Tables from one entry Form

P: n/a
PMB
Thank you in advance for any and all assistance.

I'm running a form/table that tracks transactions and I want to update a
daily and monthly table at the end of each transaction based on the
CustomerID <> CASH or <> CCARD. Which should give me only the accounts that
charged products or services.

I would like to do this as transparent as possible as not to alert my clerks
to the update procedure. Is there a way to programatically open more than
one table and update the same fields in them?

Michael
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"PMB" <pm*****@megavision.com> wrote in message news:<Kb****************@news.uswest.net>...
Thank you in advance for any and all assistance.

I'm running a form/table that tracks transactions and I want to update a
daily and monthly table at the end of each transaction based on the
CustomerID <> CASH or <> CCARD. Which should give me only the accounts that
charged products or services.

I would like to do this as transparent as possible as not to alert my clerks
to the update procedure. Is there a way to programatically open more than
one table and update the same fields in them?

Michael


normally you'd use update queries...

docmd.setwarnings false
docmd.openquery "myupdatequery"
docmd.setwarnings true
Nov 12 '05 #2

P: n/a

Michael

Forgive me if I have mis-understood you, but I suspect what you propose
is over complicated.

If you want to track transactions on a daily or monthly basis how about
putting the date and other required data in you main table and then,
when you want the information do a report based on a query from that
table.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.