J
Jeri
I've been struggling with this issue for a while, but the solution eludes me.
I asked the question previously, but didn’t get an answer that worked. I hope
someone can help.
I am using Access 2007 for scientific data entry.
I have a table of plant species, and a form with fields for the species
code, the scientific name, common name, and alias names. I have a button
(btn_SpeciesSearch) that opens the find dialog box without the "replace" tab.
I would like to have the default set to search all fields, any part of the
field. I also want the match case to be turned off.
I'm using this code:
me.allowedits=false
docmd.gotocontrol "FloraSpeciesCode"
docmd.runcommand (accmdfind)
me.allowedits=true
I tried using Docmd.findrecord, which sort of worked. But I'd like to use
the dialog box so they have the option of searching particular fields. Also,
if they are searching for a type of aster, for example, it will turn up on a
number of records. So the dialog box works better, as they can just sift
through them by hitting "next."
I already have a combo box to search for a particular genus.
I’ve noted the suggestion to set a general rule in tools, but I don’t want
this to happen throughout the database, but only in this one case.
If anyone has any suggestions, I'd deeply appreciate your help.
Jeri
I asked the question previously, but didn’t get an answer that worked. I hope
someone can help.
I am using Access 2007 for scientific data entry.
I have a table of plant species, and a form with fields for the species
code, the scientific name, common name, and alias names. I have a button
(btn_SpeciesSearch) that opens the find dialog box without the "replace" tab.
I would like to have the default set to search all fields, any part of the
field. I also want the match case to be turned off.
I'm using this code:
me.allowedits=false
docmd.gotocontrol "FloraSpeciesCode"
docmd.runcommand (accmdfind)
me.allowedits=true
I tried using Docmd.findrecord, which sort of worked. But I'd like to use
the dialog box so they have the option of searching particular fields. Also,
if they are searching for a type of aster, for example, it will turn up on a
number of records. So the dialog box works better, as they can just sift
through them by hitting "next."
I already have a combo box to search for a particular genus.
I’ve noted the suggestion to set a general rule in tools, but I don’t want
this to happen throughout the database, but only in this one case.
If anyone has any suggestions, I'd deeply appreciate your help.
Jeri