[AccessD] invalid number of arguments

Pedro,

Will the error go away if you set a reference to DAO 3.6
and then put Dim db As DAO.Database?
----

Michael R. Mattys
Mattys MapLib for Microsoft MapPoint
http://www.mattysconsulting.com



----- Original Message -----
From: "Pedro Janssen" <pedro at plex.nl>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, June 13, 2005 3:10 PM
Subject: Re: [AccessD] invalid number of arguments


> Thanks for this code Michael,
>
> but i need to solve the invalid argument error anyway, because i have
other
> codes with the same problem.
>
> 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: Monday, June 13, 2005 3:13 PM
> Subject: Re: [AccessD] invalid number of arguments
>
>
> > Pedro,
> >
> > Sorry. This is how I remove linked tables:
> > To make it so that you remove only specific tables
> > you modify it so that you end up with Neal's function.
> >
> > Function RemoveLinkedTbls()
> >     Dim db As DAO.Database, tdf As DAO.TableDef
> >     Set db = CurrentDb
> >     For Each tdf In db.TableDefs
> >         If tdf.Connect <> "" Then
> >             DoCmd.DeleteObject acTable, tdf.Name
> >         End If
> >     Next
> >     Set db = Nothing
> > End Function
> > ----
> >
> > Michael R. Mattys
> > Mattys MapLib for Microsoft MapPoint
> > http://www.mattysconsulting.com
> >
> >
> >
> > ----- Original Message -----
> > From: "Pedro Janssen" <pedro at plex.nl>
> > To: "Access Developers discussion and problem solving"
> > <accessd at databaseadvisors.com>
> > Sent: Monday, June 13, 2005 8:41 AM
> > Subject: Re: [AccessD] invalid number of arguments
> >
> >
> > > Hello Michael,
> > >
> > > when using db.TableDefs(strTableName).Delete it gives an
compile-error:
> > > Can't find methode or member.
> > >
> > > Any other ideas.
> > >
> > > 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: Monday, June 13, 2005 1:13 AM
> > > Subject: Re: [AccessD] invalid number of arguments
> > >
> > >
> > > > ----- Original Message -----
> > > > From: "Pedro Janssen" <pedro at plex.nl>
> > > > To: <AccessD at databaseadvisors.com>
> > > > Sent: Sunday, June 12, 2005 5:50 PM
> > > > Subject: [AccessD] invalid number of arguments
> > > >
> > > >
> > > > Hello Group,
> > > >
> > > > i am using a function that Neil Kling provided me in the past.
> > > > When running it from an expression i get an error:
> > > >
> > > > Invalid number of arguments.
> > > >
> > > > Who can help me with this
> > > >
> > > > ------
> > > >
> > > > Pedro,
> > > >
> > > > It should be
> > > >
> > > > db.TableDefs(strTableName).Delete
> > > >
> > > > ----
> > > >
> > > > 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
> > > >
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com