Query to insert from table to table

[Joe via AccessMonster.com]

Hello,
I have a database that I am using to as quality. I would like to know if
there is a way that I can have the user search from a record in an ODBC table
and have the query pull only the required fields from the record and insert
them into a table in the database?

Any help would be greatly appricated.


Thanks in advance.

Joe

 

[KARL DEWEY]

insert them into a table in the database
When you use the term 'insert' do you mean to append records or to update
records?
You would either need an append or update query.

 

[Joe via AccessMonster.com]

Karl,
What I want the search form to do it look for a record by rec id in a link
table and then insert (append) the record into a table in the db.

When you use the term 'insert' do you mean to append records or to update
records?
You would either need an append or update query.

Hello,
I have a database that I am using to as quality. I would like to know if

[quoted text clipped - 7 lines]

Joe

 

[KARL DEWEY]

Create a select query with criteria, run to verify correct record, in design
view change to append, select table for destination, check that fields append
to correct fields, and run.

Karl,
What I want the search form to do it look for a record by rec id in a link
table and then insert (append) the record into a table in the db.

insert them into a table in the database

When you use the term 'insert' do you mean to append records or to update
records?
You would either need an append or update query.

Hello,
I have a database that I am using to as quality. I would like to know if

[quoted text clipped - 7 lines]

Joe

 

[Joe via AccessMonster.com]

Karl,

Thanks for the advice. I will set that up this weekend and try it out. I just
have one more question. When I open the database and then click on the linked
table, it will as me for my username and password for the SQL server. Is
there a way to have this save the password everytime, so that I don't have to
reenter it when I open the database again?


Thanks,

Joe

Create a select query with criteria, run to verify correct record, in design
view change to append, select table for destination, check that fields append
to correct fields, and run.

Karl,
What I want the search form to do it look for a record by rec id in a link

[quoted text clipped - 10 lines]