Discussion:
Reference to DAO object in VBA
(too old to reply)
Arlan
2005-06-30 17:16:03 UTC
Permalink
I have created a small application in VBA the references the 'Microsoft DAO
3.6 Object' and it works great until I save it as a template for
distribution. When the template is loaded the reference to DAO is not
checked. Is there a feature (bug) that needs to be worked around (if so
how?) or am I missing somthing more basic?
This is written in Word 2003 and needs to operate in Word XP as well.

THANKS!
Jezebel
2005-06-30 23:10:53 UTC
Permalink
You need to distribute and install the DAO library. Users won't necessarily
have it on their computer, since MS moved to ADO.
Post by Arlan
I have created a small application in VBA the references the 'Microsoft DAO
3.6 Object' and it works great until I save it as a template for
distribution. When the template is loaded the reference to DAO is not
checked. Is there a feature (bug) that needs to be worked around (if so
how?) or am I missing somthing more basic?
This is written in Word 2003 and needs to operate in Word XP as well.
THANKS!
Arlan
2005-07-01 08:07:01 UTC
Permalink
I hadn't thought of that... Thanks. BUT my testing was on the same computer
as the development computer so availability of the DAO object is not the
issue. The reference to it is lost when I save the application as a .dot
file. Is this normal? How can I prevent it?
Post by Jezebel
You need to distribute and install the DAO library. Users won't necessarily
have it on their computer, since MS moved to ADO.
Post by Arlan
I have created a small application in VBA the references the 'Microsoft DAO
3.6 Object' and it works great until I save it as a template for
distribution. When the template is loaded the reference to DAO is not
checked. Is there a feature (bug) that needs to be worked around (if so
how?) or am I missing somthing more basic?
This is written in Word 2003 and needs to operate in Word XP as well.
THANKS!
Doug Robbins
2005-07-01 11:21:45 UTC
Permalink
What was the "application" before you saved it as a .dot file.

Having always started with a .dot file, I have never had the problem that
you are experiencing.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
Post by Arlan
I hadn't thought of that... Thanks. BUT my testing was on the same computer
as the development computer so availability of the DAO object is not the
issue. The reference to it is lost when I save the application as a .dot
file. Is this normal? How can I prevent it?
Post by Jezebel
You need to distribute and install the DAO library. Users won't necessarily
have it on their computer, since MS moved to ADO.
Post by Arlan
I have created a small application in VBA the references the 'Microsoft DAO
3.6 Object' and it works great until I save it as a template for
distribution. When the template is loaded the reference to DAO is not
checked. Is there a feature (bug) that needs to be worked around (if so
how?) or am I missing somthing more basic?
This is written in Word 2003 and needs to operate in Word XP as well.
THANKS!
Loading...