Append Query

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

I would like to view the data in the query before I append the data
to a table. How would I set up the query to append to a table after I have
a chance to verify the info.

I saw something similar to this in another posting, but there were no
responses.

Tiffany
 
Thanks for your response!!

I have created a select query, but I want to be able to push a button and
have it automatically append the data to my table without asking me for the
parameter again.

Tiffany
 
I would like to view the data in the query before I append the data
to a table. How would I set up the query to append to a table after I
have a chance to verify the info.
Click to expand...

Base the form on the incoming data, and make it use continuous forms --
this give a quick way of letting the user browse up and down the records.
Remember to make the query a Snapshot the the user cannot alter the data.

Put a command button in the form footer to call the append procedure.

HTH


Tim F
 
Thanks for your response Tim

I have built a form that brings the data from the select query in and have
added a button to the form that runs the append query. How do I pass the
parameter from the select query to the append query, so that it doesn't ask
for the parameter again when I run the append query?

Thanks for your help :)
Tiffany
 
-----Original Message-----
I would like to view the data in the query before I append the data
to a table. How would I set up the query to append to a table after I have
a chance to verify the info.

I saw something similar to this in another posting, but there were no
responses.

Tiffany



.
Hi Tiffany, the simplest way is to generate two versions
Click to expand...
of the query. The first being a standard select query,
which will show the data which will be used to append the
table and the other the append query itself.
Hope that helps
Regards
Steve
 
How do I pass the
parameter from the select query to the append query, so that it
doesn't ask for the parameter again when I run the append query?
Click to expand...

set qdf = querydefs("MyAppendQuery")
with qdf
.parameters("LastKnownValue") = dwLastGoodValue
.parameters("FirstMissingDate") = CDate(txtMissing)

.execute dbFailOnError

end with

Hope that helps


Tim F
 
Back
Top