gsrai31
12-04-2007, 06:51 PM
I am new to web development. I need some urgent help in building this basic web application with visual studio 2005 and MS Access database called “DailyReporting”.
I have successfully managed to create a login page for some users. What I need to do next is - once a user has logged in, I need to use the “Username” to display an input form on a secure web page that includes some drop down boxes with items that are relevant to the logged in user. These values will come from a reference table called “Suppliers”. Supplier table has these fields – (Supplier, FlightNo, Destination, Allocation, SchCollectionTime, SchDepartDay, SchDepartTime, SchArrivalDay, SchArrivalTime, Start Date, End Date). User name is always same as in the field “Supplier”.
So for example if supplier’s name is BA, then the FlightNo drop down needs to show all BA flights from the reference table. When user selects a particular flight then the Destination, Allocation etc needs to display items in drop down lists or text boxes that are relevant to the selected flight number. It will be useful to use calendar control for schDepartDay and schArrivalDay etc.
I suppose in a select query it will look like this (SELECT Supplier, FlightNo, Destination, Allocation, ScheduledCollTime, ScheduledDepartDay, ScheduledDepartTime, ScheduledArrivalDay FROM Suppliers WHERE Supplier=UserName.Value AND ((Date()) Between [Start Date] And [End Date];
There will be some blank text fields that user will enter some values into. These are - ActualCollectionTime, ActualDepartDay, ActualDepartTime, ActualArrivalDay, ActualArrivalTime and Comments. Once the form is completed, user will submit the report that will add a new record to another table called “DailyReport”. DailyReport table has all of the fields as on the input form and a field for DateStamp that will enter the system date and time when the submit button is clicked. Once data has been submitted, form will be ready for a new record.
I hope this all makes sense. If not please let me know.
Your help will be much appreciated. Many thanks in advance for your help. GS
I have successfully managed to create a login page for some users. What I need to do next is - once a user has logged in, I need to use the “Username” to display an input form on a secure web page that includes some drop down boxes with items that are relevant to the logged in user. These values will come from a reference table called “Suppliers”. Supplier table has these fields – (Supplier, FlightNo, Destination, Allocation, SchCollectionTime, SchDepartDay, SchDepartTime, SchArrivalDay, SchArrivalTime, Start Date, End Date). User name is always same as in the field “Supplier”.
So for example if supplier’s name is BA, then the FlightNo drop down needs to show all BA flights from the reference table. When user selects a particular flight then the Destination, Allocation etc needs to display items in drop down lists or text boxes that are relevant to the selected flight number. It will be useful to use calendar control for schDepartDay and schArrivalDay etc.
I suppose in a select query it will look like this (SELECT Supplier, FlightNo, Destination, Allocation, ScheduledCollTime, ScheduledDepartDay, ScheduledDepartTime, ScheduledArrivalDay FROM Suppliers WHERE Supplier=UserName.Value AND ((Date()) Between [Start Date] And [End Date];
There will be some blank text fields that user will enter some values into. These are - ActualCollectionTime, ActualDepartDay, ActualDepartTime, ActualArrivalDay, ActualArrivalTime and Comments. Once the form is completed, user will submit the report that will add a new record to another table called “DailyReport”. DailyReport table has all of the fields as on the input form and a field for DateStamp that will enter the system date and time when the submit button is clicked. Once data has been submitted, form will be ready for a new record.
I hope this all makes sense. If not please let me know.
Your help will be much appreciated. Many thanks in advance for your help. GS