Re: CreateField error

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

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 10/21/04

  • Next message: Russell Brandl: "Re: VB error with access Help" 
    Date: Thu, 21 Oct 2004 17:57:30 -0400

    Does field OpNoteID exist in the table?

    Also, I'd recommend replacing the DAO 2.5/3.5 reference with the DAO 3.5x
    reference. DAO 2.5/3.5 is only intended for backwards compatibility. 

    -- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Max" <max_nospam@mscm.info> wrote in message
news:cl7i8i$8qs$1$8302bc10@news.demon.co.uk...
> Hi,
> I am using Access97 on Windows XP desktop and the following references:
> Visual basic VBA322.DLL
> Access 8.0 Object Library
> Common controls 6.0
> Word 10.0
> DAO 2.5/3.5
>
> The following code generates a "Method or data member not found" error on
> the CreateField.
>
>     Set tdf = dbs.TableDefs!Patients
>     Set idx = tdf.CreateIndex("PatientIDIndex")
>     Set fld1 = idx.CreateField("OpNoteID")
>
> Any ideas?
>
> Thanks in advance,
> Max
>
>
>
  • Next message: Russell Brandl: "Re: VB error with access Help"

    Relevant Pages

    • Re: the Shift key
      ... If you're using Access 2000 or 2002, make sure you set a reference to DAO ... > dumb question) how do I set the property? ... >>Doug Steele, Microsoft Access MVP ...
      (microsoft.public.access.security)
    • Re: Access 2007 - whatever happened to ADO and DAO ?
      ... the object model for ACE is identical to the DAO object model. ... Doug Steele, Microsoft Access MVP ... there's no point in having the ADO reference ...
      (microsoft.public.access.modulesdaovba)
    • Re: User and Group information
      ... Access 2000 and 2002 didn't have a reference set to ... DAO by default, but Microsoft realized their error, and Access 2003 ... >> Doug Steele, Microsoft Access MVP ... >>> Dim grp As Group, ...
      (microsoft.public.access.gettingstarted)
    • Re: Duane Hookom HD - QBF
      ... the reference for which you're looking should be ... "Microsoft DAO 3.6 Object Library". ... Doug Steele, Microsoft Access MVP ...
      (microsoft.public.access.forms)
    • Re: Export text file
      ... It is better to use just DAO and no ADO reference at all. ... recordset objects in the drop down list. ...
      (microsoft.public.access.externaldata)