Front Page Inventory search

R

RA

I'm trying to create an inventory search tool. Using Front
page 2003, I created a database interface which cratered a
page "Submission Form" that allows the entry of items, a
second page called "Database Editor" allows for adding and
deleting items and a third page "called Results Page"
displays a list of items.

I would like to create a search page for customers to
select different attributes form dropdown list of what
they looking for and click submit and a list of applicable
items should appear. Anyone out there can help??
 
S

Sharon

I do not have an answer to your question, but I would like
to know the steps you used to create your second page for
adding and deleting items... can you give me some
direction?

Thank you
 
R

RA

Sharon,
I used Front Page wizard to create it. Here are the steps:
File  New. on the right hand site a window opens with
options of new templates
Click on "More Web site templates" and select database
interface template. That will start the wizard.
Good Luck

RA
 
R

Rich Palarea

If you want to use the Database Results Wizard to code this page for you, do
this:

1. Create a new, blank page
2. At the point you wish to display the results, select Insert, Database,
Results
3. Select your database connection and select next
4. Select the record source and select next
5. On the next screen, you can edit the list of fields you wish to display.
Make sure you click More Options button and do the following step.
6. This is where you will set the fields you want users to be able to search
on. Select Criteria button.
7. From here, select Add and you can set the type of "searching" you want
the user to be allowed to perform. Say you have a field in your inventory
called Monitors and values of VGA, SVGA, DVI and you want them to be able to
select one from a dropdown. Choose the Field Name Monitor, set the
Comparison to Equals and leave the Value as Monitor. Check the box for "use
this search form field". Select OK You can add more criteria if you wish.

You can get quite detailed SQL generated from the wizard that might take you
a while to build if you don't know SQL.

As you exit the wizard, you'll find yourself back at the
Criteria/Ordering/Defaults screen. Set any ordering or default parameters
before going to the next step. Click next.

8. Setup your results page formatting here. Click Next.
9. Set the number of records to show at one time on this screen. Click
Finish.

You will have a page with a search form on top and a results table/list
below.

In place of the search field in the top form, place a dropdown box and
populate with the values you wish to allow users to search with. Make sure
that you name the field Monitors (or whatever the corresponding database
field name is).

You can also code individual search pages by creating a new, blank page
(asp) and building a form.

HTH
Rich
 
R

Ralph

Rich,
Thank you very much for your help on this. It's been so
long you might no even remember. I followed your
instructions on this and was able create it. The only
problem I have is I could never get any records to return.
I tried several things but no luck. Any advise or pointers
to where to look. The site is www.isisco.com/data1 if you
want to look at it. There is a list on the top with 2
items that are in the database.

I would appreciate any pointers,

Thanks,
Ralph
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Creating a Search using a combo box and then creating a report. 4
Inventory search form 0
inventory search form - help!! 0
How do I create an inventory list? 1
I will pay for your help 2
how do I set the print area in front page 1
Multi-Page Forms in FrontPage 0

Top