"Make Query by Form"

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

On a database I designed a couple of years ago (Access 98) I had this
facility. You opened it, selected an existing form - hit the OK button and
an identical form layout was produced but this time you used the fields to
query the dataset.

The trouble is that when I try to convert the database to 2002, the facility
no longer works (compile errors).

I can't remember where I got it originally (possibly from the book Access
2000, by Osborne).

Does anyone know of a 2002 version (or similar) in the public domain.

Tx

Rob
 
Rob

This happens sometimes when the original database was not compiled BEFORE
converting. One solution might be to create a new, empty .mdb in A02, set
the references to reflect DAO instead of ADO (in most cases), then import
all objects from the earlier version.

The other way is to do a full compile of the older version, in the older
version of Access, before converting.
 
Try the Menu Records / Filter /Filter_By_Form.

or you can use the "Form View" Toolbar icon with the funnel and the form
images.
 
Thanks for the suggestion.

Jeff,

I've created a new database but just can't find any references to DAO or ADO
that I can change.

Can you point me in the right direction.

Tx
 
Rob

Open (or create) a code module. Tools|References lists (first) the checked
references, then all the rest.
 
Back
Top