DH - Query By Form

  • Thread starter Thread starter tbd
  • Start date Start date
T

tbd

I have downloaded the above example from Rogers Access
Library. Within the database, I am asked for a reference
to Microsoft DAO Object Library, as the code requires a
reference to the Object Library. Does anyone know how I
go about getting this reference?

tbd
 
Hi.
to Microsoft DAO Object Library, as the code requires a
reference to the Object Library. Does anyone know how I
go about getting this reference?
Click to expand...

Open a code module in the VB Editor. Select the Tools menu -> References to
open the References dialog window. Scroll down until you find the Microsoft
DAO 3.6 Object Library. Mark the check box for this library. Select the
"OK" button to save your change.

Open the References dialog window again and you'll see the DAO library at
the bottom of the list of checked libraries. If Roger's database doesn't
have the ambiguous DAO objects explicitly declared in the code, then you'll
need to move the DAO library up the list with the "Up Priority" button until
it is listed above the ADO library, so that the DAO library takes precedence
over the ADO library. Select the "OK" button to save your change.

Next, select the Debug menu -> Compile <Database Name> to compile the code
with the new library.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Open a code module. Select Tools | References. Scroll down 'til you see
the Microsoft DAO x.x Object Library (version depends on what version of
Access you are using - take the highest number version).

If the code you downloaded includes references in the form of:

Dim db as DAO.Database

then you have your reference set. If in the form of:

Dim db as Database

you'll need to either uncheck the ADO reference (same place), or "move" the
DAO reference above the ADO reference.

Preferred approach is to use the full reference in the Dim statement
(DAO.Database), so Access will know which (DAO vs. ADO).
 
Brilliant, thank you very much guys! I knew I was being a
plonker about it, I was in the tools menu in the Database,
rather than Visual Basic. D'oh!

TBD
 
If you have any questions about the QBF Applet, come on back. I know a
little about how it is constructed.
 
Back
Top