Drop-down datawindow

L

Lori

I have a form from which inputted data is stored in an
Access database. I have a list of people in a lookup
table in Access...how can I design the text box on the
form in Frontpage to show a drop-down list with these
names? I know how to do it on a form in Access but can't
figure out how to do it in Frontpage.

Thanks
 
M

Mike

Jim Buyens answered this for me:

"Just Run the Database Results Wizard once for each
drop-down box you want to load from a database. On page 4
or the wizard, make sure you specify Dropdown List - One
Record per Item."

Mikeal
 
J

Jim Buyens

-----Original Message-----
I have a form from which inputted data is stored in an
Access database. I have a list of people in a lookup
table in Access...how can I design the text box on the
form in Frontpage to show a drop-down list with these
names? I know how to do it on a form in Access but can't
figure out how to do it in Frontpage.
Click to expand...

1. Set the insertion point where you want the drop-down
box to appear.
2. Choose Database from the Insert menu, and then choose
Results.
3. Configure the DRW to retrieve two fields from your
lookup table: people names and people ids.
4. On page 4 of the Wizard:
o In the first drop-down list, choose One Record Per
Item.
o In the Display Values From This Field drop-down
list, select the name of the column that contains
people names.
o In the Submit Values From This Field drop-down
list, select the name of the column that contains
people ids.
5. On page 5 of the wizard, click Finish.
6. Save the page and test, using an http:// URL.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
L

Lori

I followed the steps below and got a drop-down datawindow
to appear however, no data is displayed in it and it is
really short in width and I can't figure out how to
increase the width of the box. Any ideas of what I am
doing wrong? Thanks!
 
M

Mike

Did you publish it to you web site?

It will display short on your design page until you publish it. Then it will
pull the data from you dbase.
 
L

Lori

Hi Mike,

Thanks for your patience...I am very new to
Frontpage...what specifically does "publish it to my web
site" mean? The file I am working in is a .asp file. I
went through the steps to get the drop-down menu and now
the drop down exists (really small) with the
text "Database Results" next to it with a yellow
background. I saved the changes to the file, but I don't
know what "publishing" it means. Sorry, this is my first
time working in Frontpage and I am updating an existing
file. I know the Access side well, just not Frontpage.
Thanks for any help you can give!
 
M

Mike

In order for components like the Database Results Wizard to work, you need
to have you site hosted on a server with FrontPage extensions installed.
You then need to 'publish' you site to that server and then you will see the
information in you drop-down box.

To publish you site click File > Publish Web and follow the instructions.

This is the only way that your drop-down will work if you want it to pull
form a database.

Mikeal
 
K

Kathleen Anderson [MVP - FP]

Clarification: Although either FrontPage 2000 Server Extensions from
Microsoft or FrontPage 2002 Server Extensions from Microsoft are required to
create pages that use the ASP features, FrontPage Server Extensions are not
required to run the pages that are generated by the ASP features.

IOW, the server extensions are required to create the pages (design-time) -
they are not required to browse the pages.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;233018
 
Top