[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