Database form

Brian · Sep 16, 2003

Hello,

I have created a form that will allow my users to select
numbers 1 -10 using 6 drop down boxes. These 6 drop down
menus are stored in an access database using columns D1
to D6. The results page displays what they have saved,
but I would also like to have each column add the total
numbers selected and update on my intranet. I would also
like to know the best way to reset the totals back to
zero as new totals are needed on a monthly basis. I am
guessing I need use the Database results Wizard, but I am
having a hard time figuring this out. I use FP 2002.

I am new to Frontpage and Access, so information to point
me in the right direction would be greatly appreciated.

Thanks,

Brian

Kevin Spencer · Sep 16, 2003

I don't think the Wizard is going to get what you are looking for. You would
have to write your own custom ASP app to do this. It can be done using
FrontPage (I've done it for years), but it requires some programming and
HTML knowledge to do it. You can find some beginning tutorials on my web
site at http://www.takempis.com, if you're feeling brave. Otherwise, set
your sights a little lower and do what you can with the Wizard.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.

Ivan Sheng · Sep 17, 2003

Hi Brian,

FrontPage doesn't provide these functions. You need to realize these
funcions by writing ASP code. However, writing code is out of the support
boundary. If you are interested in this issue, I have 2 suggestions:

1. Post this question in ASP related newsgroup.

2. Refer to this link for more information about ASP:
http://msdn.microsoft.com/library/psdk/iisref/aspguide.htm

Ivan Sheng
Microsoft Online Partner Support
MCSD,MCSE4,2000,MCDBA,CCNA,ASE
Get Secure! ¨C www.microsoft.com/security

This posting is provided ¡°as is¡± with no warranties and confers no rights.

Thomas A. Rowe · Sep 17, 2003

Ivan,

When replying, can you include the original post?

--

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

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

Brian · Sep 17, 2003

Thats a nice page. Do you have any samples for this? I am
feeling brave. Also the totals do not have to be
redisplayed on the page, but I would like a way to have
it totaled and printed. Could I use Crystal Reports to
print the database?

Thanks,

Brian

Ivan Sheng · Sep 17, 2003

Sure.