Error DoCmd.RunSql Line

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hello

I have the error No 2757 : " problem happening during acces to a propriety
or Method of an OLE Object"
(sorry for the translation)
it is link to the following code line

DoCmd.RunSQL ("DELETE * FROM [Table1] " _
& "WHERE [Table1].[RéfProfil] = " & Me.ListeProfils.Column(0))

could you tell me the correct syntax for this line in ADP ?

best regards
Alain
 
Ok I found a solution (forget the star!!)

DoCmd.RunSQL ("DELETE FROM [Table1] " _
& "WHERE [Table1].[RéfProfil] = " & Me.ListeProfils.Column(0))

I hope it will still work with DAO

Regards
Alain
 
Back
Top