Re: Error message-No value given for 1 or more parameters



Thanks Bob
That helps
Second question was to get idea as which method is better DAO or ADO
but I found the answer in old topics
thanks
anil

.



Relevant Pages

  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)
  • Re: ADODB reference?
    ... will play around with DAO in A2007 after I finish my current test ... I had one other question about ADO connection string syntax in case ... to a variety of data sources but not designed specifically for Access. ...
    (microsoft.public.access.modulesdaovba)
  • Re: DAO Add/Edit/Update Methods
    ... BTW, I didn't say you can't use ADO and bound forms, but bound forms do ... thus why I included an update current record command ... Just so you know, when I have used DAO with the dynamic cursor keyset, I ... still ran into the issue of the EditMode property not showing the edit ...
    (microsoft.public.access.modulesdaovba)
  • Re: query mdb on network into Word. Access.exe not on workstation
    ... not sure that ADO uses DAO. ... >> turned out that the new workstations did not have the ... >> have ADO 2.8 because it was installed with the Office installation. ...
    (microsoft.public.access.externaldata)
  • Re: query mdb on network into Word. Access.exe not on workstation
    ... adodb provider for Jet did not know what to do. ... not sure that ADO uses DAO. ... >>> have ADO 2.8 because it was installed with the Office installation. ...
    (microsoft.public.access.externaldata)