Re: Access 2000 Appending records to a table

Tech-Archive recommends: Fix windows errors by optimizing your registry

You need to figure out why the query is failing, if the fields are not set
to required. When you say 'it fails to append', what happens? What is the
error message, if there is one? There could be other reasons for it to
fail - like referential integrity, duplicate keys, validation rules, etc.

--
Joan Wild
Microsoft Access MVP
"geocoy" <geocoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B08CA787-73D2-4239-9F75-B73990FBF043@xxxxxxxxxxxxxxxx
Dummy me, I should have told you I already checked for "Required"
In the past I have solved this problem in two ways, either by adding bogus
data or by adding an "IF" statement to the query in the empty field and
tell
it to add text if the field is null

"Joan Wild" wrote:

It would appear that those fields have their 'required' property set to
Yes.
You need to consider why it is set to yes, and whether the property can
be
set to no, or only do the append when you have full information.

This property would be set in the backend mdb where the table is located
(not on the link in the frontend).

--
Joan Wild
Microsoft Access MVP
"geocoy" <geocoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B1218148-0A49-4F97-A06C-0E1D5C75BD19@xxxxxxxxxxxxxxxx
I am using an append query to add records to a linked table in another
Access
2000 database. The nature of the information stored on the originating
table
is such that all fields can not be populated at the instance it is
created.
So I would like to append the record with the data that is available at
the
time, leaving some fields blank. When I try to run the append quwery,
it
fails to append the record to the linked table. If I add bogus data to
the
fields just to populate the blanks, the query works. Is there some way
around this process of adding bogus data just to poplate the fields so
the
append query works?







.

Relevant Pages

  • Re: Membership database updates
    ... When you open any Query in Design View, click on the toolbar just next to ... black down-arrow where you can change your query to an Append or Update ... If you have any current members in your Import list, ... You mention Update Queries and Append Queries but I can't find how to ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Assign macro on After update event
    ... I don't see why you can't append the current record next scheduled date to ... it then try using an update query to update the dates in the new record. ... "Anna" wrote: ... maybe you can help me with that: all this macro is ...
    (microsoft.public.access.forms)
  • Re: duplicates query help & strategy for update queries with SetWarnings = False
    ... I have many many queries that check for orpaned data (for example, if there's a billing record with no matching custID in the customer table, I'm putting up a form with the unmatched data, and a quick way to update all unmatched to one archive type customer, etc. ... I was surprised to see duplicate entries in some of the static tables for dropdown selections, so I have to solve this one now. ... Once the user has handled all the problems, you enable the final command button at the bottom of the form, which executes an append query to add the data to the real table. ...
    (comp.databases.ms-access)
  • Re: Append Query Date Criteria Problem.
    ... Why can't I append some records? ... Choose Parameters on the Query menu. ... Access opens the paramters dialog. ... > End Sub ...
    (microsoft.public.access.queries)
  • RE: How to use Append Queries to add new records
    ... I sort of knew how the append query would work, ... > destination field name that you want to append those values to. ... > out new action queries. ...
    (microsoft.public.access.queries)