Re: CreateField error

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

From: Max (max_nospam_at_mscm.info)
Date: 10/22/04

  • Next message: Kenneth Goodwin: "Re: Invalid operation. (Error 3219)"
    Date: Fri, 22 Oct 2004 10:58:53 +0100
    
    

    Thanks,
    It is present, the error ocurs when I try to compile the project.
    I changed the DAO to 3.5 and have fixed most of the errors with explicitly
    designating
    DAO as in db = DAO.database

    Max

    "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:eemExj7tEHA.1272@TK2MSFTNGP12.phx.gbl...
    > 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: Kenneth Goodwin: "Re: Invalid operation. (Error 3219)"

    Relevant Pages

    • Re: Error 3251 using ADO & VBA to drop a table!
      ... DAO should be in the Access help files. ... Doug Steele, Microsoft Access MVP ... Dim tbl As ADOX.table ... RemoveRelationships cat, tbl ...
      (microsoft.public.access.modulesdaovba)
    • 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: Change Data Type with VB code
      ... I just checked my VB6 references and I have DAO 3.6. ... Doug Steele, Microsoft Access MVP ... using ALTER COLUMN did not change the data type. ...
      (microsoft.public.access.tablesdbdesign)
    • Re: A few more A97 vs A2000 questions
      ... Microsoft DAO 3.6 Object Library, ... A SwB created in A97 has no ... >> Doug Steele, Microsoft Access MVP ... >>> machines and can't resolve the problem so far. ...
      (microsoft.public.access.conversion)
    • Re: ActiveX component cant create object Access2003
      ... Since you're using DAO, it's important that you ... >> Doug Steele, Microsoft Access MVP ... >> (no private e-mails, please) ... >>> OLE Automation, MS ActiveX Data Objects 2.1 Lib, MS HTML Object Lib., ...
      (microsoft.public.access.modulesdaovba)