Remember that in Access 2000 ADO is the default data access model and not DAO. Thus, the reason you do not see Database as an option is because it isn't one in ADO (you are probably looking at the Connection object). However, if you still wish to work with DAO instead of ADO, then go to Tools...
This is from Microsoft... there used to be a mdb download that had this at MS's site, but I can't seem to find it anymore. Anyway, put this in a module:<br>
<br>
Dim intLabelBlanks As Integer<br>
Dim intLabelCopies As Integer<br>
Dim intBlankCount As Integer<br>
Dim intCopyCount...
I am not sure if you are still waiting for a reply on this one, but just in case you are, here is the API for Selecting a folder:<br>
<br>
Private Type BROWSEINFO<br>
hOwner As Long<br>
pidlRoot As Long<br>
pszDisplayName As String<br>
lpszTitle As String<br>
ulFlags As Long<br>
lpfn...
Go to Microsoft's sample database "Solutions.mdb" (installed under your Samples directory when Microsoft Office was installed) and look at the module "modRefreshTableLinks" -- it is all there.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.