Connection to FoxPro Database

[Michael P. Griba]

I am writing some VBA code that will show a user form when opening the
document it is within. The form will include a drop down (combobox) list and
a generate report command button. I have created the document template and
placed the bookmarks necessary to place the queried FoxPro data in. I have
ran a test without connectivity to the data to check my command button and it
works just fine. The problem I am having is connecting to the database and
filtering certain information to the drop down list for selection and then
querying based on that selection for further database information from FoxPro.

I am using Word (Office XP/2000/2003) and VBA 6. I was trying to connect to
the data using the vfpoledb driver, but I am having no luck it appears.
Could anybody out there help me get started with this? Thanks.

I have tried the various snippets out there for ADO/OleDB/ODBC, but I am
afraid it is my references that is out of whack. Thanks in advance for any
help any of you can provide.

Michael P. Griba
West Coast Charters, Inc.
(e-mail address removed)

 

[Cindy Winegarden]

Please post the code you've got so far and note exactly where it fails to do
what you expected.

--
Cindy Winegarden
(e-mail address removed)


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx