[AccessD] invalid number of arguments

Pedro Janssen pedro at plex.nl
Tue Jun 14 15:56:14 CDT 2005


Hello Michael,

no the error then still exists.

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 9:41 PM
Subject: Re: [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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>





More information about the AccessD mailing list