append queries

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

My Access question concerns adding new records:

If you use forms view to add a new record, the star at
the end offers blank fields for data entry. Is it
possible to offer a drop down list (look-up list) only in
a new record's fields, when the rest of the table is
already populated?

If you create a new record entry form, which could
include all those drop down lists, do you use an append
query to add the new data to the table?

Do append queries automatically empty out after appending
the new records? Do they need to be batch processed,
like each day and labeled with the date, and then
manually cleared after the main table is updated? Or is
there some kind of automatic append update process that
can be run?

Thanks for your help.
 
If you use forms view to add a new record, the star at
the end offers blank fields for data entry. Is it
possible to offer a drop down list (look-up list) only in
a new record's fields, when the rest of the table is
already populated?
Click to expand...

I don't really understand. If you want to disable the controls when the
user is editing an old record, then you can use the OnCurrent event and
check the .NewRecord (I think... check the help files) property. But if you
are only giving your users one chance to edit data, then they had better be
pretty good at never making mistakes :-)
If you create a new record entry form, which could
include all those drop down lists, do you use an append
query to add the new data to the table?
Click to expand...

No: if the form is on a new record, then the new record will be saved as
soon as the user moves off the record or closes the form.
Do append queries automatically empty out after appending
the new records? Do they need to be batch processed,
like each day and labeled with the date, and then
manually cleared after the main table is updated? Or is
there some kind of automatic append update process that
can be run?
Click to expand...

An append query will not affect the source data at all. If you need to kill
the source after importing it, you'll need to do this as a separate
command. Just be sure that you have checked and ascertained the recieved
data before killing the original....

Hope that helps


Tim F
 
Tim;
Thank you very much

Lee
-----Original Message-----


I don't really understand. If you want to disable the controls when the
user is editing an old record, then you can use the OnCurrent event and
check the .NewRecord (I think... check the help files) property. But if you
are only giving your users one chance to edit data, then they had better be
pretty good at never making mistakes :-)


No: if the form is on a new record, then the new record will be saved as
soon as the user moves off the record or closes the form.


An append query will not affect the source data at all. If you need to kill
the source after importing it, you'll need to do this as a separate
command. Just be sure that you have checked and ascertained the recieved
data before killing the original....

Hope that helps


Tim F

.
Click to expand...
 
Back
Top