Re: append queries

From: Tim Ferguson (FergusonTG_at_softhome.net)
Date: 02/28/04 

Date: Fri, 27 Feb 2004 17:21:00 -0800

"Lee" <Lmorgenstein@bederson.com> wrote in
news:369001c3fd71$927d1ab0$a301280a@phx.gbl:

> 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?

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?

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?

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

Relevant Pages

  • Re: append queries
    ... >> the end offers blank fields for data entry. ... >> Do append queries automatically empty out after ... >An append query will not affect the source data at all. ... >Tim F ...
    (microsoft.public.access.tablesdbdesign)
  • Re: style issues
    ... No need to call APPEND in either branch. ... CONS prepends, and APPEND appends, so why not have a choice ... I know you can say that CONS is the right constructor ... Lists are not symmetric structures. ...
    (comp.lang.scheme)
  • Re: SETF and variable issues in Self Similar program.
    ... APPEND is always a warning sign. ... ;;automatically - these lists contain all numbers that are equivalent ... Global variables should always be written as *foo*. ... (defun ordered-union (x y) ...
    (comp.lang.lisp)
  • Re: SETF and variable issues in Self Similar program.
    ... Most people just use CONS. ... I was somehow too fixated on discussing append. ... Although CL doesn't promise tail call optimization, ... calling APPEND on lists in recursive functions ...
    (comp.lang.lisp)
  • Re: Paper Data Entry Form
    ... frequency of data entry errors, since it's touched once, not twice. ... Microsoft Office/Access MVP ... having some drop-down lists obscuring other dropped-down lists, ... out a paper data entry version to give to users. ...
    (microsoft.public.access.forms)
Quantcast