insert data into different tables with one form in code?

  • Thread starter Thread starter paul1941
  • Start date Start date
P

paul1941

I would like to put data from one form into 4 or 5 different tables by
opening and closing my reocord set and connection variable in different sub
statements. I'm trying to do this in a control button sub but the control
buttons' sub program does not seem to want to respond to to having other
subs inside its self. can i open and close the connection in other subs and
then call them from the control button sub? and how would i call these other
subs?
 
You have described a solution ("put data from one form into 4 or 5 different
tables by ...).

Redundantly storing the same data (if that's what you meant) in multiple
tables doesn't sound like a well-normalized use of a relational database
(e.g., Access).

If you'll describe a bit more about what business need is being met by this
solution (i.e., what having 4-5 tables with the same info will allow you to
do), the newsgroups readers may be able to offer approaches that take better
advantage of Access' features/functions.

Or maybe you meant that you have data from a form that needs to be split
apart into 4-5 tables ... and my question about underlying business need
still stands!

By the way, you posted a question that seems to focus on forms and tables in
a newsgroup dedicated to supporting external data ... not sure I see the
connection...

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
iletisinde şunu yazdı said:
I would like to put data from one form into 4 or 5 different tables by
opening and closing my reocord set and connection variable in different
sub
statements. I'm trying to do this in a control button sub but the control
buttons' sub program does not seem to want to respond to to having other
subs inside its self. can i open and close the connection in other subs
and
then call them from the control button sub? and how would i call these
other
subs?
 
[color=black:kk0ytjcb]Of course there is some difference. As a special site for Maple Story, we collect helpful MS(Maple Story) tips and have them organized in regular to help Maple Story players enjoy game Maple Story more easily. For Power levelling Service, we not only level up your account in the limited time, but also maple story mesos[/color:kk0ytjcb][/url:kk0ytjcb].[/ (http://www.ugamegold.com/c_Maple-Story-Mesos/:kk0ytjcb)
 
Back
Top