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!!!!

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
"Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!!!!
>
>

Add &nbsp;

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
> "Dave" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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!!!!
> >
> >
>
>

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

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Add &nbsp;
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> > 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
> > "Dave" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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!!!!
> > >
> > >
> >
> >
>
>

It has got to be a criteria thing. If I remove the criteria, I get all the
records.


"Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Add &nbsp;
> >
> > --
> > ==============================================
> > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > WEBMASTER Resources(tm)
> > http://www.ycoln-resources.com
> > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > ==============================================
> > To assist you in getting the best answers for FrontPage support see:
> > http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> > "Dave" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > > 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
> > > "Dave" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > 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!!!!
> > > >
> > > >
> > >
> > >
> >
> >
>
>

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

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Add &nbsp;
> >
> > --
> > ==============================================
> > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > WEBMASTER Resources(tm)
> > http://www.ycoln-resources.com
> > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > ==============================================
> > To assist you in getting the best answers for FrontPage support see:
> > http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> > "Dave" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > > 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
> > > "Dave" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > 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!!!!
> > > >
> > > >
> > >
> > >
> >
> >
>
>

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

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Assign a code to the class/date combination, the pass that to results
page, etc.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> > 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
> >
> > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Add &nbsp;
> > >
> > > --
> > > ==============================================
> > > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > > WEBMASTER Resources(tm)
> > > http://www.ycoln-resources.com
> > > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > > ==============================================
> > > To assist you in getting the best answers for FrontPage support see:
> > > http://www.net-sites.com/sitebuilder/newsgroups.asp
> > >
> > > "Dave" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > > 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
> > > > "Dave" <(E-Mail Removed)> wrote in message
> > > > news:(E-Mail Removed)...
> > > > > 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!!!!
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

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)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Assign a code to the class/date combination, the pass that to results
> page, etc.
> >
> > --
> > ==============================================
> > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > WEBMASTER Resources(tm)
> > http://www.ycoln-resources.com
> > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > ==============================================
> > To assist you in getting the best answers for FrontPage support see:
> > http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> > "Dave" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > > 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
> > >
> > > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > Add &nbsp;
> > > >
> > > > --
> > > > ==============================================
> > > > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > > > WEBMASTER Resources(tm)
> > > > http://www.ycoln-resources.com
> > > > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > > > ==============================================
> > > > To assist you in getting the best answers for FrontPage support see:
> > > > http://www.net-sites.com/sitebuilder/newsgroups.asp
> > > >
> > > > "Dave" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > > 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
> > > > > "Dave" <(E-Mail Removed)> wrote in message
> > > > > news:(E-Mail Removed)...
> > > > > > 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!!!!
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Is there someone that can answer this that I can send this to?

Thanks

Dave

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> > 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
> >
> > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Assign a code to the class/date combination, the pass that to results
> > page, etc.
> > >
> > > --
> > > ==============================================
> > > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > > WEBMASTER Resources(tm)
> > > http://www.ycoln-resources.com
> > > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > > ==============================================
> > > To assist you in getting the best answers for FrontPage support see:
> > > http://www.net-sites.com/sitebuilder/newsgroups.asp
> > >
> > > "Dave" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > > 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
> > > >
> > > > "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> > > > news:(E-Mail Removed)...
> > > > > Add &nbsp;
> > > > >
> > > > > --
> > > > > ==============================================
> > > > > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > > > > WEBMASTER Resources(tm)
> > > > > http://www.ycoln-resources.com
> > > > > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > > > > ==============================================
> > > > > To assist you in getting the best answers for FrontPage support
see:
> > > > > http://www.net-sites.com/sitebuilder/newsgroups.asp
> > > > >
> > > > > "Dave" <(E-Mail Removed)> wrote in message
> > > > news:(E-Mail Removed)...
> > > > > > 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
> > > > > > "Dave" <(E-Mail Removed)> wrote in message
> > > > > > news:(E-Mail Removed)...
> > > > > > > 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!!!!
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Dave:
If you are looking for tutorials on how to use the FrontPage Database Wizard
in FP2002 or FP2003, I have links to a few on this page:
http://www.spiderwebwoman.com/resour...sandtricks.asp

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


Dave <(E-Mail Removed)> wrote:
> Is there someone that can answer this that I can send this to?
>
> Thanks
>
> Dave
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Dave" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>> 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
>>>
>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Assign a code to the class/date combination, the pass that to
>>>> results page, etc.
>>>>
>>>> --
>>>> ==============================================
>>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>>> WEBMASTER Resources(tm)
>>>> http://www.ycoln-resources.com
>>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>>> ==============================================
>>>> To assist you in getting the best answers for FrontPage support
>>>> see: http://www.net-sites.com/sitebuilder/newsgroups.asp
>>>>
>>>> "Dave" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>>> 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
>>>>>
>>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>> Add &nbsp;
>>>>>>
>>>>>> --
>>>>>> ==============================================
>>>>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>>>>> WEBMASTER Resources(tm)
>>>>>> http://www.ycoln-resources.com
>>>>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>>>>> ==============================================
>>>>>> To assist you in getting the best answers for FrontPage support
>>>>>> see: http://www.net-sites.com/sitebuilder/newsgroups.asp
>>>>>>
>>>>>> "Dave" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>>> 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
>>>>>>> "Dave" <(E-Mail Removed)> wrote in message
>>>>>>> news:(E-Mail Removed)...
>>>>>>>> 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!!!!