Error DoCmd.RunSql Line

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to delete records in Access table and reset the Autonumber 1
Function and Request are not good friends 6
Windows metafile image error in VBA office 2010 0
Access 2000 subform: problem accessing a property or method of the OLE Object 9
Dropping an Error Table 4
VBA - exporting serial letters to single documents 0
New user needs help! 4
Why won't my Access Data Project work with linked child fields? 0

Top