[AccessD] invalid number of arguments

Hello Michael,

I don't know if you are married, but my wife can be nagging at my head about
finishing this database for here.

I am not sure that i understand you!
Why using a Append query with an autonumbered field.

I will give you a small structure of the tables involved:


"commercial database linked table"

DEBSTM
Nummer        = Text  (but al Id's are numbers)    =  Primary Key
Adres
Plaats


i need following table

tblDEBITEUR
DebID         = Number   (Long Integer)
Postadres
Woonplaats


I need datatype = number because the filtering on this field otherwise isn't
going to be right.


Can you explain more on basis from this structure?


Pedro Janssen






----- Original Message -----
From: "Michael R Mattys" <mmattys at rochester.rr.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, June 22, 2005 5:15 PM
Subject: Re: [AccessD] invalid number of arguments


> Hi Pedro,
>
> <Snip & Reformat>
>
> - In this (commercial) database ... i can't change anything.
> - don't want to ad each new client in two different databases.
> - want to use the client table from the commercial database (clientID's
> identical).
> - clients [DEBSTM] can be linked to the "brick" database [tblDebiteur].
>
> > I don't want to use a query from this linked table, to adjust the names
> > because i then have to adjust al other query's and tables.
> > Using the same names for the table and fields would be the best way.
>
>
> > Pedro Janssen
>
> Hi Pedro,
>
> Nagging? :)
>
> An append query to an autonumbered table would be best.
> Leave in the text ClientID and use that as criteria in the query
> to make sure there are no duplicates. Alias the fields desired.
> You know macros have no error handling, right?
>
> ----
>
> Michael R. Mattys
> Mattys MapLib for Microsoft MapPoint
> http://www.mattysconsulting.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>