Pedro Janssen
pedro at plex.nl
Mon Jun 13 14:10:46 CDT 2005
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 >