Re: Insert statement does not work suddenly !

Tech-Archive recommends: Fix windows errors by optimizing your registry

Okay: clearly you don't have reference to the DAO library.
Here's some info about library references:
http://allenbrowne.com/ser-38.html

You can do it with ADO if you prefer. There's an example at the end of this webpage:
http://allenbrowne.com/func-ADO.html#ExecuteADO

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"edisonl via AccessMonster.com" <u47544@uwe> wrote in message news:9bcbb3b7d9ea7@xxxxxx
Hi Piet,

It gave an error saying type mismatch..

By the way, Can I do it in ADO ?

Regards & God Bless, Edison

.

Relevant Pages

  • Re: run time error 429
    ... The big difference is that A2k has ADO as the default data ... while A97 had DAO as the default library. ... your library references. ... If IsNullThen Exit Sub ...
    (microsoft.public.access.formscoding)
  • RE: Recordset: Type Mismatch
    ... > So I wonder why I'm getting this error knowing that my code was running ... Recordset object. ... Or you can set the DAO library to have higher precedence than the ADO ... these library references, please see Tom Wickerath's tip: ...
    (microsoft.public.access.modulesdaovba)
  • RE: New record in table in Access from VBA in Excel
    ... > multiple versions of Microsoft ActiveX DAta Objects 2.x library references ... >> error you probably need to reference the project to ADO. ... This should cure your UDF error. ... >> HTH ...
    (microsoft.public.excel.programming)
  • Re: Data Member not Found
    ... You should disambiguate this declaration if you choose to keep the ADO ... Dim rst As DAO.Recordset ... Library References in Access Databases": ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.forms)
  • Re: Displaying Select columns(windows forms app)
    ... Okay, I figured out how to filter out columns. ... I can't use ADO to do ... it as it doesn't support such procedures with columns. ...
    (microsoft.public.dotnet.framework.adonet)