msaccess

[Guest]

how do you create a search from multiple selected types import to a table so
it can be retreived later.

 

[John Vinson]

how do you create a search from multiple selected types import to a table so
it can be retreived later.

You'll have to explain your question more thoroughly. You're mixing
search, import, table, retrieve - but I have NO trace of a notion what
you are importing, what "multiple selected types" might be, or what
you're trying to accomplish.

Please describe the real-world situation, with some indication of what
it is (text files? spreadsheets? Access tables?) that you want to
import and what you want to do with the imported data.

John W. Vinson[MVP]

 

[Guest]

Iam working on a registration database with address infomation, each address
has a selection field (drop down and check box) that that separates then from
the others. How can I create a search form using my selection feilds (
example male from female, who said yes to breakfast) and then i want it to
export these results to a table, info from that will be used to make mailing
lables.

 

[John Vinson]

Iam working on a registration database with address infomation, each address
has a selection field (drop down and check box) that that separates then from
the others. How can I create a search form using my selection feilds (
example male from female, who said yes to breakfast) and then i want it to
export these results to a table, info from that will be used to make mailing
lables.

A couple of things to consider:

Tables contain data. A dropdown or a checkbox IS NOT DATA - these are
*tools* which let you display data. If you're using Microsoft's
so-called Lookup Wizard, take a look at this critique:

http://www.mvps.org/access/lookupfields.htm

Secondly you're making the very common mistake of assuming that you
must copy data into a table in order to print mailing labels. This is
not necessary, and it's not even a good idea! A mailing label report
can and should be based on a Query.

You can create this Query by creating a small unbound form - let's
call it frmCrit - with unbound combo boxes, checkboxes, whatever other
criteria you want. You would then create a Query using criteria like

=[Forms]![frmCrit]![cboSex]

You can then create your mailing label report based on this Query, and
put a command button on frmCrit to open the Report. The report will
use the query, which will use the criteria from frmCrit; it's not
necessary to copy any data anywhere.

John W. Vinson[MVP]