Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to create a form for my companies intraNet site. The idea is as follows:

  1. An employee wants to make a purchase, so they will go to the appropriate page in the intraNet
  2. They will fill out the form on the intraNet page
  3. They click the email button
  4. The data in the form is saved in a database, and an email is sent to me stating that there is purchase order request form filled out

I am not exactly sure how to go about this. Part of me wants to create it in a Data Access Page but I am not sure that's correct.

  • Can someone help me?
  • Is there anyone who can direct me to someone/something that can help me?
share|improve this question
    
I cannot tell you too much about Access as programming languages, but for that kind of simpler stuff I preffer php, or ROR for development, that's my personal opinion, would be great if some DAP programmer share something with us. –  jcho360 May 17 '12 at 20:08
    
There are new options available with Sharepoint and MS Access 2010, if they are available to you: channel9.msdn.com/Shows/Access/Microsoft-Access-2010-Demo –  Remou May 17 '12 at 20:11
    
You can build the web on your own. Take a look at the Express version of Visual Web Developer (FREE) microsoft.com/visualstudio/en-us/products/2010-editions/… . To actually send the "form", please search for SmtpMail class and other related asp.net classes. Hope that helps. –  MarlonRibunal May 17 '12 at 22:14

2 Answers 2

You could look into APEX which is available even on the free Oracle Express Edition.

Oracle Application Express (APEX) is a Web application development tool for Oracle Database. The tool uses built-in features such as user interface themes, navigational controls, form handlers, and flexible reports to accelerate application development.

Oracle Application Express installs with the database and consists of data in tables and PL/SQL code. When you run an application, your browser sends a URL request that is translated into an Oracle Application Express PL/SQL call. After the database processes the PL/SQL, the results are relayed back to the browser as HTML. This cycle happens each time you request or submit a page.

You can use Oracle Application Express with the embedded PL/SQL gateway. The gateway runs in the XML DB HTTP server in the database and provides the necessary infrastructure to create dynamic applications. As shown in Figure 19-1, the embedded PL/SQL gateway simplifies the application architecture by eliminating the middle tier.

You will need to evaluate this option with respect to your existing infrastructure and requirements.

share|improve this answer
    
Thanks everyone! I will look into it as much as I can! This really helps! :D –  eternalearth888 May 18 '12 at 14:25

There's more than one way to do this with Access. (Newer versions of these articles are probably available.)

Each of these has different trade-offs. Your decision will depend in part on what kind of dbms you're storing the data in--Access (Jet), SQL Server, Oracle, MySQL, etc.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.