Update query on more than one table

[jwr]

Can an update query update more than one table at a time?

Can an update query, update another query?

I am attempting to send a query to excel to email to user for input. When
the user returns to me, I am attempting to update the access info with the
new data.

I cannot seem to accomplish any of the above. All of the posts seem so
simple -- such as -- import from excel and update. How do I do this??? Is
there a website that will help?

Thanks in advance.

 

[tina]

comments inline.

Can an update query update more than one table at a time?
no.


Can an update query, update another query?

no. since a query does not *store* data, but only retrieves it, you can't
"update" data in a query - you can only update the data stored in a table.

I am attempting to send a query to excel to email to user for input. When
the user returns to me, I am attempting to update the access info with the
new data.

I cannot seem to accomplish any of the above. All of the posts seem so
simple -- such as -- import from excel and update. How do I do this??? Is
there a website that will help?

you can import the Excel file into a table in the database, or simply link
the Excel file to the database (it will show up as a linked table in the
database window); from the database window, click File | Get External
Data... then you can link the Excel table to the native table in a query,
and update the native table's records. the trick here is that you have to be
able to link specific records in the two tables, in order to update the data
in one with data from the other.

hth

 

[jwr]

Tina -

Before I continue on my task -- which is not accomplishing anything, may I
question you more?

Briefly -- I have had no training other than "on the job" training and I am
the teacher!

1. I have an Order Database from the access templates.
2. I have a large query (44 fields) that must be emailed to corporate after
it is updated.
a. All but 3 of the fields are completed.
1) I am wanting to send an email to my dealer for him to enter the
info into these 3 fields, email back to me and update my access query/info.

How do I do this?

1. Create a query and email to dealer?
2. Save-as from email to excel?
3. Do I save the email in the same folder as the access database?
4. Do my fields need to be exactly the same in excel and access?

My apologies for my ignorance. I really need guidance. Thank you so much.

 

[tina]

comments inline.

1. I have an Order Database from the access templates.
2. I have a large query (44 fields) that must be emailed to corporate after
it is updated.
a. All but 3 of the fields are completed.
1) I am wanting to send an email to my dealer for him to enter the
info into these 3 fields, email back to me and update my access query/info.

How do I do this?

1. Create a query and email to dealer?

you can't email a query - remember, a query is just a set of instructions to
the system. you can output a query's dataset as an Excel file, and then
email the Excel file to your dealer. (if you're not familiar with VBA, use a
macro to Output the query. in the macro window, you can use F1 to get to the
Help topic for the various macro Actions; that's a good way to learn how
they work.)

2. Save-as from email to excel?

have the dealer fill in the missing data in the Excel spreadsheet, and email
the Excel file back to you.

3. Do I save the email in the same folder as the access database?

when you get the email back from the dealer, save the Excel file anywhere
you want - just make sure you know exactly where you're saving it. (what
drive, and what folder.)

4. Do my fields need to be exactly the same in excel and access?

if you're working with an Excel file that you generated from an Access
query, then the fields should match without you having to do anything. the
point is, in order to update the data in the Access table, you need to be
able to match the specific records.

my first suggestion is to make sure you include the primary key field(s) of
the Access table in the original Output query.

for instance, let's say your Access table has 300 records in it. you run a
query that returns five records. you include the primary key field(s) in the
query, output the query to Excel, and email the Excel file to the dealer for
data to be added and/or updated. the dealer does so, and emails the Excel
file back to you. you save the Excel file from the email onto your PC. in
the database, you link the Excel file so that it shows up in the database
windw as a linked table.

now you can create a new query, include both the Access table and the Excel
table, and link the two tables on the matching primary key field(s). from
the Access table, pull the fields you want updated into the query design
grid. turn the query into an Update query, and set the UpdateTo line of each
field in the grid to the name of the corresponding field in the Excel table
with the following syntax:

[ExcelTableName].[ExcelFieldName]

substitute the correct names of the table and the field, of course.

hth

My apologies for my ignorance. I really need guidance. Thank you so

much.

you never need to apologize for not knowing something. the person who never
asks questions either already knows everything - or never learns anything.

 

[jwr]

Thank you for your direction.

Also, your last statement was very kind. God Bless.

comments inline.

1. I have an Order Database from the access templates.
2. I have a large query (44 fields) that must be emailed to corporate after
it is updated.
a. All but 3 of the fields are completed.
1) I am wanting to send an email to my dealer for him to enter the
info into these 3 fields, email back to me and update my access query/info.

How do I do this?

1. Create a query and email to dealer?

you can't email a query - remember, a query is just a set of instructions to
the system. you can output a query's dataset as an Excel file, and then
email the Excel file to your dealer. (if you're not familiar with VBA, use a
macro to Output the query. in the macro window, you can use F1 to get to the
Help topic for the various macro Actions; that's a good way to learn how
they work.)

2. Save-as from email to excel?

have the dealer fill in the missing data in the Excel spreadsheet, and email
the Excel file back to you.

3. Do I save the email in the same folder as the access database?

when you get the email back from the dealer, save the Excel file anywhere
you want - just make sure you know exactly where you're saving it. (what
drive, and what folder.)

4. Do my fields need to be exactly the same in excel and access?

if you're working with an Excel file that you generated from an Access
query, then the fields should match without you having to do anything. the
point is, in order to update the data in the Access table, you need to be
able to match the specific records.

my first suggestion is to make sure you include the primary key field(s) of
the Access table in the original Output query.

for instance, let's say your Access table has 300 records in it. you run a
query that returns five records. you include the primary key field(s) in the
query, output the query to Excel, and email the Excel file to the dealer for
data to be added and/or updated. the dealer does so, and emails the Excel
file back to you. you save the Excel file from the email onto your PC. in
the database, you link the Excel file so that it shows up in the database
windw as a linked table.

now you can create a new query, include both the Access table and the Excel
table, and link the two tables on the matching primary key field(s). from
the Access table, pull the fields you want updated into the query design
grid. turn the query into an Update query, and set the UpdateTo line of each
field in the grid to the name of the corresponding field in the Excel table
with the following syntax:

[ExcelTableName].[ExcelFieldName]

substitute the correct names of the table and the field, of course.

hth

My apologies for my ignorance. I really need guidance. Thank you so

much.

you never need to apologize for not knowing something. the person who never
asks questions either already knows everything - or never learns anything.

with
the to the
data

 

[tina]

you're welcome

Thank you for your direction.

Also, your last statement was very kind. God Bless.

comments inline.

enter
the

you can't email a query - remember, a query is just a set of

instructions

to
the system. you can output a query's dataset as an Excel file, and then
email the Excel file to your dealer. (if you're not familiar with VBA,

use

a
macro to Output the query. in the macro window, you can use F1 to get to the
Help topic for the various macro Actions; that's a good way to learn how
they work.)

2. Save-as from email to excel?

have the dealer fill in the missing data in the Excel spreadsheet, and email
the Excel file back to you.

3. Do I save the email in the same folder as the access database?

when you get the email back from the dealer, save the Excel file anywhere
you want - just make sure you know exactly where you're saving it. (what
drive, and what folder.)

4. Do my fields need to be exactly the same in excel and access?

if you're working with an Excel file that you generated from an Access
query, then the fields should match without you having to do anything. the
point is, in order to update the data in the Access table, you need to be
able to match the specific records.

my first suggestion is to make sure you include the primary key field(s) of
the Access table in the original Output query.

for instance, let's say your Access table has 300 records in it. you run a
query that returns five records. you include the primary key field(s) in the
query, output the query to Excel, and email the Excel file to the dealer for
data to be added and/or updated. the dealer does so, and emails the Excel
file back to you. you save the Excel file from the email onto your PC. in
the database, you link the Excel file so that it shows up in the database
windw as a linked table.

now you can create a new query, include both the Access table and the Excel
table, and link the two tables on the matching primary key field(s). from
the Access table, pull the fields you want updated into the query design
grid. turn the query into an Update query, and set the UpdateTo line of each
field in the grid to the name of the corresponding field in the Excel table
with the following syntax:

[ExcelTableName].[ExcelFieldName]

substitute the correct names of the table and the field, of course.

hth

My apologies for my ignorance. I really need guidance. Thank you so

much.

you never need to apologize for not knowing something. the person who never
asks questions either already knows everything - or never learns anything.

comments inline.

Can an update query update more than one table at a time?

no.


Can an update query, update another query?

no. since a query does not *store* data, but only retrieves it, you can't
"update" data in a query - you can only update the data stored in a table.


I am attempting to send a query to excel to email to user for input.
When
the user returns to me, I am attempting to update the access info with
the
new data.

I cannot seem to accomplish any of the above. All of the posts

seem
so

simple -- such as -- import from excel and update. How do I do this???
Is
there a website that will help?

you can import the Excel file into a table in the database, or

simply
link

the Excel file to the database (it will show up as a linked table in the
database window); from the database window, click File | Get External
Data... then you can link the Excel table to the native table in a query,
and update the native table's records. the trick here is that you

have
to

be
able to link specific records in the two tables, in order to update the
data
in one with data from the other.

hth


Thanks in advance.

 

[jwr]

Tina -

I have asked this question and gotten no response on other forums. Do you
know how to send a report or form in PDF format? When I go to file and send
to, that option is not there.
Joy

you're welcome

Thank you for your direction.

Also, your last statement was very kind. God Bless.
instructions use to
the field(s)
of

run

a

query that returns five records. you include the primary key field(s)

in
the

query, output the query to Excel, and email the Excel file to the

dealer
for

data to be added and/or updated. the dealer does so, and emails the Excel
file back to you. you save the Excel file from the email onto your PC. in
the database, you link the Excel file so that it shows up in the database
windw as a linked table.

now you can create a new query, include both the Access table and the Excel
table, and link the two tables on the matching primary key field(s). from
the Access table, pull the fields you want updated into the query design
grid. turn the query into an Update query, and set the UpdateTo line

of
each

field in the grid to the name of the corresponding field in the Excel table
with the following syntax:

[ExcelTableName].[ExcelFieldName]

substitute the correct names of the table and the field, of course.

hth



My apologies for my ignorance. I really need guidance. Thank you so
much.

you never need to apologize for not knowing something. the person who never
asks questions either already knows everything - or never learns anything.



comments inline.

Can an update query update more than one table at a time?

no.


Can an update query, update another query?

no. since a query does not *store* data, but only retrieves it, you
can't
"update" data in a query - you can only update the data stored in a
table.


I am attempting to send a query to excel to email to user for input.
When
the user returns to me, I am attempting to update the access

info
with

the
new data.

I cannot seem to accomplish any of the above. All of the posts seem
so
simple -- such as -- import from excel and update. How do I do
this???
Is
there a website that will help?

you can import the Excel file into a table in the database, or simply
link
the Excel file to the database (it will show up as a linked table

in
the

database window); from the database window, click File | Get External
Data... then you can link the Excel table to the native table in a
query,
and update the native table's records. the trick here is that you have
to
be
able to link specific records in the two tables, in order to

update
the

data
in one with data from the other.

hth


Thanks in advance.

 

[tina]

you need to print the report to a .PDF file, using a PDF printer driver. you
can google to find inexpensive, as well as some free, drivers. i've seen
pdf995 recommended in these newsgroups, as well as CutePDF (which is the one
i use). also, see Stephen Lebans' website for a PDF converter that does not
require a PDF printer driver: http://www.lebans.com/reporttopdf.htm

hth

Tina -

I have asked this question and gotten no response on other forums. Do you
know how to send a report or form in PDF format? When I go to file and send
to, that option is not there.
Joy

you're welcome


VBA,
use

get

to anything.
the to
be run

field(s)

in

the
query, output the query to Excel, and email the Excel file to the dealer
for
data to be added and/or updated. the dealer does so, and emails the Excel
file back to you. you save the Excel file from the email onto your

PC.
in

the database, you link the Excel file so that it shows up in the database
windw as a linked table.

now you can create a new query, include both the Access table and the
Excel
table, and link the two tables on the matching primary key field(s). from
the Access table, pull the fields you want updated into the query design
grid. turn the query into an Update query, and set the UpdateTo line of
each
field in the grid to the name of the corresponding field in the Excel
table
with the following syntax:

[ExcelTableName].[ExcelFieldName]

substitute the correct names of the table and the field, of course.

hth



My apologies for my ignorance. I really need guidance. Thank you so
much.

you never need to apologize for not knowing something. the person who
never
asks questions either already knows everything - or never learns anything.



comments inline.

Can an update query update more than one table at a time?

no.


Can an update query, update another query?

no. since a query does not *store* data, but only retrieves it, you
can't
"update" data in a query - you can only update the data stored

in

a posts
seem

table

in you
have

 

[jwr]

Many thanks!

you need to print the report to a .PDF file, using a PDF printer driver. you
can google to find inexpensive, as well as some free, drivers. i've seen
pdf995 recommended in these newsgroups, as well as CutePDF (which is the one
i use). also, see Stephen Lebans' website for a PDF converter that does not
require a PDF printer driver: http://www.lebans.com/reporttopdf.htm

hth

Tina -

I have asked this question and gotten no response on other forums. Do you
know how to send a report or form in PDF format? When I go to file and send
to, that option is not there.
Joy
get learn
how

need

to

be
able to match the specific records.

my first suggestion is to make sure you include the primary key field(s)
of
the Access table in the original Output query.

for instance, let's say your Access table has 300 records in it.

you
run

a
query that returns five records. you include the primary key

field(s)

in
the
query, output the query to Excel, and email the Excel file to the dealer
for
data to be added and/or updated. the dealer does so, and emails the
Excel
file back to you. you save the Excel file from the email onto your PC.
in
the database, you link the Excel file so that it shows up in the
database
windw as a linked table.

now you can create a new query, include both the Access table and the
Excel
table, and link the two tables on the matching primary key field(s).
from
the Access table, pull the fields you want updated into the query design
grid. turn the query into an Update query, and set the UpdateTo

line
of

each
field in the grid to the name of the corresponding field in the Excel
table
with the following syntax:

[ExcelTableName].[ExcelFieldName]

substitute the correct names of the table and the field, of course.

hth



My apologies for my ignorance. I really need guidance. Thank

you
so

much.

you never need to apologize for not knowing something. the person who
never
asks questions either already knows everything - or never learns
anything.



comments inline.

Can an update query update more than one table at a time?

no.


Can an update query, update another query?

no. since a query does not *store* data, but only retrieves

it,
you

can't
"update" data in a query - you can only update the data stored

in

a
table.


I am attempting to send a query to excel to email to user for
input.
When
the user returns to me, I am attempting to update the access info
with
the
new data.

I cannot seem to accomplish any of the above. All of the posts
seem
so
simple -- such as -- import from excel and update. How do I do
this???
Is
there a website that will help?

you can import the Excel file into a table in the database, or
simply
link
the Excel file to the database (it will show up as a linked

table

in
the
database window); from the database window, click File | Get
External
Data... then you can link the Excel table to the native table

in

a

 

[tina]

you're welcome

Many thanks!

you need to print the report to a .PDF file, using a PDF printer driver. you
can google to find inexpensive, as well as some free, drivers. i've seen
pdf995 recommended in these newsgroups, as well as CutePDF (which is the one
i use). also, see Stephen Lebans' website for a PDF converter that does not
require a PDF printer driver: http://www.lebans.com/reporttopdf.htm

hth

Tina -

I have asked this question and gotten no response on other forums. Do you
know how to send a report or form in PDF format? When I go to file

and
send

to, that option is not there.
Joy
you're welcome


Thank you for your direction.

Also, your last statement was very kind. God Bless.
comments inline.


1. I have an Order Database from the access templates.
2. I have a large query (44 fields) that must be emailed to
corporate
after
it is updated.
a. All but 3 of the fields are completed.
1) I am wanting to send an email to my dealer for him to
enter
the
info into these 3 fields, email back to me and update my access
query/info.

How do I do this?

1. Create a query and email to dealer?

you can't email a query - remember, a query is just a set of
instructions
to
the system. you can output a query's dataset as an Excel file, and
then
email the Excel file to your dealer. (if you're not familiar

with
VBA,

use
a
macro to Output the query. in the macro window, you can use F1

to
get

to
the
Help topic for the various macro Actions; that's a good way to learn
how
they work.)

2. Save-as from email to excel?

have the dealer fill in the missing data in the Excel

spreadsheet,
and

email
the Excel file back to you.

3. Do I save the email in the same folder as the access database?

when you get the email back from the dealer, save the Excel file
anywhere
you want - just make sure you know exactly where you're saving it.
(what
drive, and what folder.)

4. Do my fields need to be exactly the same in excel and access?

if you're working with an Excel file that you generated from an Access
query, then the fields should match without you having to do anything.
the
point is, in order to update the data in the Access table, you

need

to
be
able to match the specific records.

my first suggestion is to make sure you include the primary key
field(s)
of
the Access table in the original Output query.

for instance, let's say your Access table has 300 records in it. you
run
a
query that returns five records. you include the primary key field(s)
in
the
query, output the query to Excel, and email the Excel file to the
dealer
for
data to be added and/or updated. the dealer does so, and emails the
Excel
file back to you. you save the Excel file from the email onto

your
PC.

in
the database, you link the Excel file so that it shows up in the
database
windw as a linked table.

now you can create a new query, include both the Access table

and
the

Excel
table, and link the two tables on the matching primary key field(s).
from
the Access table, pull the fields you want updated into the query
design
grid. turn the query into an Update query, and set the UpdateTo line
of
each
field in the grid to the name of the corresponding field in the Excel
table
with the following syntax:

[ExcelTableName].[ExcelFieldName]

substitute the correct names of the table and the field, of course.

hth



My apologies for my ignorance. I really need guidance. Thank you
so
much.

you never need to apologize for not knowing something. the

person
who

never
asks questions either already knows everything - or never learns
anything.



comments inline.

Can an update query update more than one table at a time?

no.


Can an update query, update another query?

no. since a query does not *store* data, but only retrieves it,
you
can't
"update" data in a query - you can only update the data

stored
in

a
table.


I am attempting to send a query to excel to email to user for
input.
When
the user returns to me, I am attempting to update the access
info
with
the
new data.

I cannot seem to accomplish any of the above. All of the posts
seem
so
simple -- such as -- import from excel and update. How do

I
do

this???
Is
there a website that will help?

you can import the Excel file into a table in the database, or
simply
link
the Excel file to the database (it will show up as a linked table
in
the
database window); from the database window, click File | Get
External
Data... then you can link the Excel table to the native

table

in that
you