• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

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
0
Goels
Asked:
Goels
  • 4
  • 4
1 Solution
 
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
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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
 
leslynfCommented:
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
 
GoelsAuthor Commented:
Thanks a lot Leslyn.

Cheers
Goels
0
 
leslynfCommented:
Thank you.

Leslyn :)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now