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