Microsoft Access
  Home arrow Microsoft Access arrow Page 4 - wsh
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Dedicated Servers 
Moblin 
JMSL Numerical Library 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MICROSOFT ACCESS

wsh
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 17
    2006-02-15

    Table of Contents:
  • wsh
  • Creating a parametric query
  • Turning this into a Data Access Page
  • Page display in the browser

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    wsh - Page display in the browser


    (Page 4 of 4 )

    Open the page in IE6.0 (here IE6.0 is available and therefore used) from its location in C:\Documents and Settings\computer user\Desktop\Nov7\DAP3\PDAP.htm. The display of this page in the browser is as shown in this picture. An Enter Parameters window pops up with just one parameter, CustomerID. There is a text box where you can enter the value of the parameter.

    Now enter a CustomerID, say, 'DUMON' (I remember this  because I have seen the table) for the parameter value column which is showing a text box and click OK. The page will display as shown below (I have expanded the Company Name node for this picture).

    Hosting the page on the intranet

    Upload the PDAP.htm file to the intranet's root folder, or copy this page and paste it in the root folder. It will be available for the intranet users. The next display shows the same page as seen at the URL, http://localhost/PDAP.htm. However you get two warnings, as shown in the next two pictures. 

     

    If you click OK to accept to display, you get the final page displayed, which pops up the same Enter Parameter value dialogue. If you enter the CustomerID value, you get the page displayed.

    Summary

    If the parametric query is working correctly, turning it into a Data Access Page is quite simple using the PageWizard.  You may experience some problems with hosting it on the intranet, mostly due to permission- and data provider-related  problems. The values for the parameters you enter are not case sensitive.  The web pages created in this tutorial are functional, but you may have to work on them to make them aesthetically pleasing. However, Data Access Pages are RAD at its best.


    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

       · One good way to get just what you want is parametric query. No need to get the whole...
       · HiSorry 'bout being anoni mouse, still waiting for the registration email to hit...
       · Try this work around, change your query from select to 'Make table' and base your...
       · Thanks, but I don't think that will work for me. I can base a DAP on the table, but...
       · The reason "like" does not work is because as much as this article wants you to...
       · Thanks for the comments. Since the query has no problem, the problem would be with...
       · I tried to use *Name* as my parameter in my DAP. I know that it should return...
       · DAPs run on the ADO model, so you probably need an ANSI wildcard in your LIKE...
       · The above poster is right. Dunno if anyone's come across it, but a more detailed...
       · The KB article is very clear. sincerely,Jay
       · I had similar problems described in the article above. Based on the discussion and...
       · I'm trying to implement a small variation of this tutorial. I have a simple access...
       · Since you are trying to use the relationships between two queries, it will be better...
       · HiI've read your articels and looked at your website.And found out that you...
       · Are the three tables connected in any way? You can drop controls on the Data Access...
       · sorry about posting as 'any mouse', but my account password hasn't arrived yet. ...
       · I worked as an experimentalist in the hard sciences most of my life. There is...
       · I have dependant drop down lists in a form in Access 2000... i have one simple table...
     

    MICROSOFT ACCESS ARTICLES

    - Linking SQL Express 2005 Tables to MS Access...
    - Working with Access Projects in Access 2007
    - Exploring Access 2007
    - Working with Stored Procedures in an MS Acce...
    - Creating and Using Action Queries
    - Creating Data Access Pages with Charts using...
    - Advanced Ideas using VBA
    - VBA Details
    - Updating Records in MS Access
    - Using ADO`s Record Object with URLs
    - Exporting XML from MS Access 2003
    - Importing XML into MS Access 2003
    - On Using Pass-through Queries in MS Access
    - Distributed Queries in MS Access
    - Configuring a Linked Microsoft Access Server...





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway