Inserting a MSAccess form into a Intranet Webpage

Hi all,

I have a MS Access form which has 3 combo boxes on it. These combo boxes are there to get a combination of account name, report type and date; and then according to the chosen combination a particular report opens on clicking on a 'display report' button. These reports are in a given folder and are named as'accountname+reporttype+date'. I was trying to get this particular form inserted into a webpage so that when one opens the webpage he has all the form functionality from there. The 3 tables associated with this form are in Access itself. The webpage is not on the internet but on the company intranet server.
Any ideas.

Cheers
Goels
GoelsAsked:
Who is Participating?
 
leslynfConnect With a Mentor Commented:
Working with Data Access Pages is slightly different than working with a form. Forms have class modules using VBA. Because Data Access Pages are used to create HTML pages (when published), they use VBScript (a web scripting language).

A couple of notes. Bound Combo boxes on Data Access Pages adhere to case sensitivity.

Check the properties behind the combo box on the Data Access Page -- ControlSource (Field to be stored), ListRowSource (Source of data for the list), ListDisplayField (Field from the RowSource that's displayed in the control's list), ListBoundField (Field that used to stored and retrieved from the bound data source).

Here's a good reference for you:

   Publisher: Sybex
   Title: Access 2002 Developer's Handbook Volume 2: Enterprise Edition

There are two full chapters on Data Access Pages that will be a great help to you.

Hope this info helps you.

Leslyn :)
0
 
webwomanCommented:
You need to reconstruct this in ASP. You're not going to be able to use ANY reports or forms directly from Access.

It would probably be easier to just put the database on a file server and let everybody use it in Access.
0
 
GoelsAuthor Commented:
Thanks for your suggestion dear. I have accordingly posted my question in the ASP forum.

Chow
Goels
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
leslynfCommented:
Depending on the version of Access you are using, you may have the ability to construct your form in the Data Access Pages area of Access.

Leslyn :)
0
 
GoelsAuthor Commented:
I am using Access 2002, Windows XP.

Cheers
Goels

0
 
leslynfCommented:
Then Data Access pages are a viable solution for you.

Leslyn :)
0
 
GoelsAuthor Commented:
I tried converting my form into a data access page but the result is similar to a semi-functional  image of the form being placed on the web page. Neither do the combo boxes display their lists nor is the display pdf report button working. It could be since all the vba code is showing as coments when looking at the HTML source.

Goels
0
 
GoelsAuthor Commented:
Thanks a lot Leslyn.

Cheers
Goels
0
 
leslynfCommented:
Thank you.

Leslyn :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.