var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Run two Query at the same time when press single button
My Project is in MS Access 2002.
I want to know how can I Run Two Differant Queries at the same time when I press Submit buttom?
OR can I Insert values in two different table using single query?
Last edited by billy_pit; 01-30-08 at 14:42.
Can you just run them one after the other?
DoCmd.RunQuery "some sql.."
DoCmd.RunQuery "some other sql.."
Can't see why not. There is no benefit to running two queries at EXACTLY the same time.
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
Ideally you'd want to run it as a single transaction; but I'm not aware of these in Access so this is your best bet!
Just remember to hanlde errors!