A
Ann
When importing a 2nd access table & linking them together how do I access my
form that's used in table 1 for the linked tables?
form that's used in table 1 for the linked tables?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
Ann
Define "linking [tables] together".
Define "access my form that's used in table1" (and by the way, forms offer
a way to see the data that's stored in tables, not vice versa).
A standard approach to using forms is to create a query against the table(s)
with the data and use that query as a source for the form.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Define "linking [tables] together".
Define "access my form that's used in table1" (and by the way, forms offer
a way to see the data that's stored in tables, not vice versa).
A standard approach to using forms is to create a query against the table(s)
with the data and use that query as a source for the form.
Regards
Jeff Boyce
Microsoft Office/Access MVP
A
Ann
Both tables have the exact same fields, table 1 is being researched for
company information data. I want to import table 1 into table 2. My thought
was that if I linked those 2 tables together that I would get the combined
tables. I'd rather import table 1 into table 2 if I can. From there I have
created a form that uses table 1, I'd like that same form to use table 2.
You mentioned an append quiery, I'm terrible with writing quieries. how
would I do that?
company information data. I want to import table 1 into table 2. My thought
was that if I linked those 2 tables together that I would get the combined
tables. I'd rather import table 1 into table 2 if I can. From there I have
created a form that uses table 1, I'd like that same form to use table 2.
You mentioned an append quiery, I'm terrible with writing quieries. how
would I do that?
Jeff Boyce said:Ann
Define "linking [tables] together".
Define "access my form that's used in table1" (and by the way, forms offer
a way to see the data that's stored in tables, not vice versa).
A standard approach to using forms is to create a query against the table(s)
with the data and use that query as a source for the form.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Ann said:When importing a 2nd access table & linking them together how do I access
my
form that's used in table 1 for the linked tables?
N
nomadk
Ann,
Make a copy of your database in case something goes wrong. Double-click
table 1 to open it. Use Control +A to select all records. Use Control+C to
copy them to the clipboard. Open table 2. Go to Edit/Paste Append.
Make a copy of your database in case something goes wrong. Double-click
table 1 to open it. Use Control +A to select all records. Use Control+C to
copy them to the clipboard. Open table 2. Go to Edit/Paste Append.
Ann said:Both tables have the exact same fields, table 1 is being researched for
company information data. I want to import table 1 into table 2. My thought
was that if I linked those 2 tables together that I would get the combined
tables. I'd rather import table 1 into table 2 if I can. From there I have
created a form that uses table 1, I'd like that same form to use table 2.
You mentioned an append quiery, I'm terrible with writing quieries. how
would I do that?
Jeff Boyce said:Ann
Define "linking [tables] together".
Define "access my form that's used in table1" (and by the way, forms offer
a way to see the data that's stored in tables, not vice versa).
A standard approach to using forms is to create a query against the table(s)
with the data and use that query as a source for the form.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Ann said:When importing a 2nd access table & linking them together how do I access
my
form that's used in table 1 for the linked tables?
J
Jeff Boyce
Ann
A quick check in Access HELP should give you the particulars.
In general, open a query in design view, select the fields from the table
you'll want to add (append). When the query is returning the records you
want to add (append), stop and make a backup copy of your database!
Then change the query type to an Append query from the default "Select"
query.
How you do that depends on which version of Access you are using...
Regards
Jeff Boyce
Microsoft Office/Access MVP
A quick check in Access HELP should give you the particulars.
In general, open a query in design view, select the fields from the table
you'll want to add (append). When the query is returning the records you
want to add (append), stop and make a backup copy of your database!
Then change the query type to an Append query from the default "Select"
query.
How you do that depends on which version of Access you are using...
Regards
Jeff Boyce
Microsoft Office/Access MVP
Ann said:Both tables have the exact same fields, table 1 is being researched for
company information data. I want to import table 1 into table 2. My
thought
was that if I linked those 2 tables together that I would get the combined
tables. I'd rather import table 1 into table 2 if I can. From there I have
created a form that uses table 1, I'd like that same form to use table 2.
You mentioned an append quiery, I'm terrible with writing quieries. how
would I do that?
Jeff Boyce said:Ann
Define "linking [tables] together".
Define "access my form that's used in table1" (and by the way, forms
offer
a way to see the data that's stored in tables, not vice versa).
A standard approach to using forms is to create a query against the
table(s)
with the data and use that query as a source for the form.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Ann said:When importing a 2nd access table & linking them together how do I
access
my
form that's used in table 1 for the linked tables?
A
Ann
Ok, thanks to you both!
Jeff Boyce said:Ann
A quick check in Access HELP should give you the particulars.
In general, open a query in design view, select the fields from the table
you'll want to add (append). When the query is returning the records you
want to add (append), stop and make a backup copy of your database!
Then change the query type to an Append query from the default "Select"
query.
How you do that depends on which version of Access you are using...
Regards
Jeff Boyce
Microsoft Office/Access MVP
Ann said:Both tables have the exact same fields, table 1 is being researched for
company information data. I want to import table 1 into table 2. My
thought
was that if I linked those 2 tables together that I would get the combined
tables. I'd rather import table 1 into table 2 if I can. From there I have
created a form that uses table 1, I'd like that same form to use table 2.
You mentioned an append quiery, I'm terrible with writing quieries. how
would I do that?
Jeff Boyce said:Ann
Define "linking [tables] together".
Define "access my form that's used in table1" (and by the way, forms
offer
a way to see the data that's stored in tables, not vice versa).
A standard approach to using forms is to create a query against the
table(s)
with the data and use that query as a source for the form.
Regards
Jeff Boyce
Microsoft Office/Access MVP
When importing a 2nd access table & linking them together how do I
access
my
form that's used in table 1 for the linked tables?
A
Ann
I think that worked, thank you! Is there a way to import table 1 into table 2
directly through
directly through
nomadk said:Ann,
Make a copy of your database in case something goes wrong. Double-click
table 1 to open it. Use Control +A to select all records. Use Control+C to
copy them to the clipboard. Open table 2. Go to Edit/Paste Append.
Ann said:Both tables have the exact same fields, table 1 is being researched for
company information data. I want to import table 1 into table 2. My thought
was that if I linked those 2 tables together that I would get the combined
tables. I'd rather import table 1 into table 2 if I can. From there I have
created a form that uses table 1, I'd like that same form to use table 2.
You mentioned an append quiery, I'm terrible with writing quieries. how
would I do that?
Jeff Boyce said:Ann
Define "linking [tables] together".
Define "access my form that's used in table1" (and by the way, forms offer
a way to see the data that's stored in tables, not vice versa).
A standard approach to using forms is to create a query against the table(s)
with the data and use that query as a source for the form.
Regards
Jeff Boyce
Microsoft Office/Access MVP
When importing a 2nd access table & linking them together how do I access
my
form that's used in table 1 for the linked tables?