Intellisense .Fields.Append DAO?

  • Thread starter Thread starter MSH
  • Start date Start date
M

MSH

Have you checked to make sure you have a reference to DAO?

(i.e. In VBA Tools|References menu)
-----Original Message-----
Why is there no intellisense in this:

Dim idxPKDAO As DAO.Index
Set idxPKDAO = TdfDAO.CreateIndex(strPKNameDAO)
Set Fld1DAO = idxPKDAO.CreateField(strFldName1DAO, dbText)
With idxPKDAO
.Fields.Append Fld1DAO
'This is where the issue arises above
.Primary = True
End With

When I type .Fields Fields is available in
Click to expand...
intellisense. But when I type the dot after Fields
expecting intellisense to list Append as an option there
is nothing that happens. Based on this I'd say I was
cruising for a bruiser. But no it is correct. Just as I
have written:
..Fields.Append Fld1DAO

So what's up? Jet 4.0 SP6 DAO 3.7 Windows 2000 SP3
Click to expand...
Access XP (not in Access here) just VBA.
 
The DAO reference isn't the issue. I can reproduce this oddity in A2K,
but I can't explain it.
 
" But no it is correct. Just as I have written."

In other words it works "[j]ust as I have written."

If I did not have a referemce to the DAO library I doubt this would be the case. Try it yourself you will see the issue. Thanks anyway. It is clear that the library is missing some information; DAO Object Library 3.6 anyway.
 
Back
Top