Sounds to me like something that is supposed to be installed is not. Also, you might be having a version reference conflict. Maybe the installed version of word doesn't use a specific method that's being invoked.
Comatose
Taboo Programmer
2,910 posts since Dec 2004
Reputation Points: 361
Solved Threads: 215
I would ensure that you have the vbruntime files updated. Date is an internal VB command, so there should be no issues with it.
Comatose
Taboo Programmer
2,910 posts since Dec 2004
Reputation Points: 361
Solved Threads: 215
It's also possible that your license to whatever library you're using has expired, especially if you're trying to use Access and you only had a trial version of Office inst called.
Oh contraire Sendoshin...
The data access methods for communicating with access databases is seperate from MS office products. In fact, they are shipped with the OS and constantly have updates that are called MDAC (Microsoft Data Access Components) with some sort of version number tied into the file name for example http://support.microsoft.com/kb/219293 (however mdac 2.8 is not listed in this list and for some reason I cannot find the current list at the moment as M$ is running too slow for my tastes).
Now, as for the error poster/post #11 is recieving. Check your references. Do you have both ADO and DAO? If so, move the DAO reference up via the up arrow button so it is prior to the ADO reference. Or, does it say that the DAO reference is missing? Then you may need to download and install a MDAC version prior to 2.6, because DAO is no longer shipped as part of MDAC starting at 2.6. But before you do that, deselect the missing reference, hit ok, save entire project, go back to references, find correct reference, select, ok, run. Does it work now?
Now, if you are not missing a reference and do not have more than one data access method then you may have to declare it as Dim db as DAO.Database...
Good Luck
vb5prgrmr
Posting Virtuoso
1,912 posts since Mar 2009
Reputation Points: 156
Solved Threads: 296