Need Ideas For Interface Design

  • Thread starter Thread starter Jason Ferguson
  • Start date Start date
J

Jason Ferguson

I don't know if anyone will have any ideas to help me, but what the
heck.

I am creating a Wizard to export certain records from an Access table
to an Excel Spreadsheet (don't worry, I already have code to do that).

The user should be able to choose which records need to be exported
based on four different fields:

- a "Batch ID" (string value representing which records were imported
to the database at the same time)
- A status (open or closed)
- Which organization the records relate to
- Last name

Specifying one of these can come up with any number ( >= 0 ) of
records.

I'm having difficulty coming up with an idea flexible enough to search
this way. I'd like the user to be able to keep checking certain
records that he/she wants included until the Next button is clicked.

My question is: how would all of you tackle this problem?

Jason
 
The user should be able to choose which records need to be exported
based on four different fields:

- a "Batch ID" (string value representing which records were imported
to the database at the same time)
- A status (open or closed)
- Which organization the records relate to
- Last name

Specifying one of these can come up with any number ( >= 0 ) of
records.

I'm having difficulty coming up with an idea flexible enough to search
this way.
Click to expand...

A simple Parameter Query can do this without much difficulty.

I'd create a small unbound form, frmCrit, with four controls: a combo
box listing all the BatchID's; a checkbox or two-row listbox listing
the status; a textbox or combo box of organizations; and a textbox or
combo box of last names.

The Report would be based on a query with criteria such as

=[Forms]![frmCrit]![cboBatchID] OR [Forms]![frmCrit]![cboBatchID] IS
NULL

and similarly for the other fields. With the IS NULL addition, this
will let the user (say) leave the Last Name field on the form blank,
and have all last names retrieved (similarly for any of the other
fields).

You can put a button on frmCrit to launch the report.
 
Back
Top