Want to publish on Intranet

[uofte]

First - thanks to the contributors on this site. I have used the Excel forums for years.

I have an open-ended question. I have created a db that I would like to publish on my intranet. The main form of the database uses combo boxes (supported by vba code written by me) to look up data for the user. The user then enters variables into this form, which updates a new table. This all works great on the stand-alone db.

I have tried several things to get this form on the intranet, but to no avail. I can see the form (when saved as DAP), but the combo does nothing; therefore the page is useless.

The basic question is this: What is the best way to publish this form on my intranet? I have a stand-alone server dedicated to this project running Windows Server 2003, Web edition. I also have MSDE installed and running. I used the upsize wizard this morning to create an ADP, but am just plain lost. I am starting to question if I am "over-doing" it.

Anyone have a basic game plan for me?

Thanks in advance,
Dustin

 

[kelfuego]

So are these webpages that your trying to develop in ASP?

I have a couple of databases that I have designed front ends for using ASP. My Db's use a couple of different tables and as such I simply created a secondary recordset to use dynamically as the pulldown list. Once the user has selected the appropriate category and click the submit button, the data is passed via url to another page where it is used as a filter for the database.

here is an example (forgive the graphics as this is not to meant to be a flashy site)

http://mail.voaor.org//MISDB/SearchPgm.asp

when you make a selection, for a good example, of what this does select the wrc in the pulldown menu.


Kelly Johnson MCP
Volunters of America Oregon