Intellisense .Fields.Append DAO?

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
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
Access XP (not in Access here) just VBA.
 
D

Dirk Goldgar

The DAO reference isn't the issue. I can reproduce this oddity in A2K,
but I can't explain it.
 
G

George Hester

" 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top