Results 1 to 2 of 2

Thread: Need Help with Indexes

  1. Jan 17th, 2003, 08:36 AM #1
    James0816
    James0816 is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2002
    Posts
    88

    Angry Need Help with Indexes

    Ok...really frazzled now and need some major help. I am trying to create an index but it is just not working. I keep getting a "Run-time error '3409': Invalid field definition 'DocTitle' in definition of index or relationship.

    Here's a code snipet:

    Set cmptbl = cmpdb!compliance
    With cmptbl

    Set cmpidx = .CreateIndex("cmptitle")
    With cmpidx
    .Fields.Append .CreateField("DocTitle")
    .Fields.Append .CreateField("DocDesc")
    End With
    .Indexes.Append cmpidx
    .Indexes.Refresh
    End With

    Am I missing something here? Definately lost now. Could've sworn it was working yesterday.
    Reply With Quote Reply With Quote
  2. Jan 17th, 2003, 11:05 AM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    Some possible causes for this error

    The field name you have specified might be misspelled.
    The field data type is a Memo or OLE Object, which cannot be indexed.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width