Solved

Inserting a MSAccess form into a Intranet Webpage

Posted on 2004-10-05
11
215 Views
Last Modified: 2010-04-09
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
Comment
Question by:Goels
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
11 Comments
 
LVL 19

Expert Comment

by:webwoman
ID: 12227714
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
 

Author Comment

by:Goels
ID: 12235872
Thanks for your suggestion dear. I have accordingly posted my question in the ASP forum.

Chow
Goels
0
 
LVL 4

Expert Comment

by:leslynf
ID: 12291610
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Goels
ID: 12296502
I am using Access 2002, Windows XP.

Cheers
Goels

0
 
LVL 4

Expert Comment

by:leslynf
ID: 12322694
Then Data Access pages are a viable solution for you.

Leslyn :)
0
 

Author Comment

by:Goels
ID: 12337004
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
 
LVL 4

Accepted Solution

by:
leslynf earned 250 total points
ID: 12350137
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
 

Author Comment

by:Goels
ID: 12350159
Thanks a lot Leslyn.

Cheers
Goels
0
 
LVL 4

Expert Comment

by:leslynf
ID: 13483026
Thank you.

Leslyn :)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Building a website can seem like a daunting task to the uninitiated but it really only requires knowledge of two basic languages: HTML and CSS.
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
In this tutorial viewers will learn how add a scalable full-width header using CSS3. Create a new HTML document with an internal stylesheet. Set a tiled background.:  Create a new div and name it Header. Position it with position:absolute at the top…
In this tutorial viewers will learn how to code links for mobile sites that, once clicked, send a call or text to a specified number. For a telephone link (once clicked, calls a number), begin with a normal "<a href=" link tag. For the href, specify…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question