Can 2 fields be displayed in the the same dropdown?

D

Dave

This is a continuing saga to my CLASS & DATE signup page.

First thanks to all!!

I am good with MS ACCESS, I am ok with FrontPage and I do not know what the
capabilities are of forms and databases.

If I create a DATE & CLASS field, can those fields be combined for display
purposes in a single drop down.

So the left part of the drop down would be the CLASS and the right part
would be the DATE.

I.e. CLASS = im2020 DATE = 4/19/2004

So here I have two choices to have ACCESS combine the two fields into one:

1 - I know how to create a new field in ACCESS combining the two records
with a macro, but I don't know how to have ACCESS run a macro after the
database has a record added via a web.

2 - Is there a way to show CLASS & DATE side by side in one drop down?

Is there a good reference/examples area on the web and/or is there a good
source book for FRONTPAGE 2003 and Forms & Databases.

Thanks everyone!!!!
 
D

Dave

I figured out how to show them next to each other.

Now I need to figure out how to put spaces between them. I know that I can
enter characters like letters, but how do I enter spaces.?

Thanks

Dave
 
T

Thomas A. Rowe

Add  

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
D

Dave

You have been a great help!
I am using the Results Wizard to build these things with the exception of a
little code to make the pull down display correctly.

Now I cannot pass the 2 fields DATE and CLASS to the results page, it says
no results where found.

Am I fighting a losing cause here? I want the user to register for these
classes, but I want the CLASS & DATE fields to pass through separated using
the selection on the dropdown.

Any guidance would be appreciated.

Once I get this to work, then the rest of what I want to do is repetition.

Thanks
 
T

Thomas A. Rowe

Assign a code to the class/date combination, the pass that to results page, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
D

Dave

Thanks Tom - that was it!!!

Is there anything that explains the wizard and it's options very well - a
white paper maybe.

Also can a record be updated/changed from a FrontPage asp page

Thanks
 
T

Thomas A. Rowe

It depends on the version of FP. FP2002 and FP2003 should allow you to create edit and delete page
via the Wizard, whereas FP2000 only allow the creation of add page.

I hand code all of my ASP, thereby avoiding limitations of the wizard.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Top