I created an Access program for timecard entry for our users but now have been asked to transition this into a web application using Visual Basic developer. The data that is inputted will be populated to one table that will be exported to a .txt file and imported into our Accounting system.
I have attached a screen print of what my Access input page looks like to give you a visual of what I'm trying to accomplish.
The first thing on the entry page needs to be four unbound fields: W/E date, Week#, Empl ID & Employee Name(name should be pulled from an employee table where empl id = empl id keyed in.
The reason for the fields above is because the these fields must be listed in every record added and I want to avoid having the user to have to rekey the information for these fields for every record for the specific employee.
Second, there needs to be an input form for users to key in the information. Fields include employee id, w/e date, week# (all populated from the fields above), job#, cost code, hours, etc.
Third: Below the input form I need a view of the data to show what has been entered for that employee so far. For example, when the user keys in data for Empl# 1, when they hit the Submit button it automatically refreshes the view below to show the newly added record.
I'm a newbie to VS and ASP.net and I'm not sure how to accomplish this. I have created a web application and a Web form page but I'm not sure what controls to use for everything. Also, what code do I use the empl id on the input form to filter the data displayed in my third section? I've looked all over the Internet and also have a book but I can't find anything that addresses my specific situation.
Any help would be greatly appreciated.