Go Back   Access World Forums > Apps and Windows > Web Design and Development > ASP and ASP.NET

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-26-2012, 06:08 AM   #1
kevin_Carr
Newly Registered User
 
Join Date: Sep 2011
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
kevin_Carr is on a distinguished road
Access 2007 and webforms

Hi all,

sorry to put out a 'newb' question but Im in need of a little guidance.

I am revamping an old 2003 database (ive already imported from the old and rebuilt it into an accdb format with some pretty stuff to go with it) but its been posed to me whether we can automate the 'Requests'.

Currently, on the Telstra Intranet, we have a webform to request a new Video Conference. Some of the information is pre-populates from LDAP (i believe), and the rest is all free-form.
Users fill in date, time, duration, host's name, and other assorted bits and pieces. The biggest problem is when they get to the Video Rooms (sites) that they are intending on using.
The webform fields for a site are:
E.164 Alias
IP Address
ISDN Number
Contact Name
Contact Number
Physical Address
Equipment Type

So staff have to manually fill this out. The Key field is the E.164 Alias as its a unique identifier. What i want to do is have a webform where the user types in the E.164 (whether it be free-type or drop down doesnt matter) and then it auto-populates most of the other fields - which is being sourced from a table in a database (master summary.accdb).

I also want it to be event based, as there will be multiple sites; once the first site has been selected, the user might press "Add" to have a new Site and then repeat the above scenario.

Now the big question for you: Should I be using an ASP page for this, or a HTML5 page? And secondly, can this kind of thing be linked?
Our company also uses Sharepoint 2007 and im thinking of eventually publishing the database on Sharepoint if that makes things easier to work with?

Thanks all for your forthcoming advise.

Kev

kevin_Carr is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import data from Excel(2007) spreadsheet into Access(2007) form using VBA Barry Forms 2 05-21-2012 06:47 AM
Problem Between Access 2003 & Access 2007 Displaying Forms Correctly, Office 2007 kfschaefer Forms 2 06-17-2011 04:09 PM
CopyFromRecordset Access 2007 to Excel 2007 truncates field for long string Rx_ Modules & VBA 4 05-24-2011 03:08 PM
Merging Access 2007 data into Word 2007 merge file JWinter95 Modules & VBA 0 05-23-2011 11:00 AM
webforms Treason Modules & VBA 0 05-10-2004 03:29 PM




All times are GMT -8. The time now is 04:00 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World