Database Interface -- Form or Data Access Page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Database Interface project (using FrontPage 2003 and Access 2003).
Users will be entering data into the database using a submission form --
here's the problem I have:

The data in the Access database was imported from Excel -- on the Excel
spreadsheet, data is entered for each Period (month) horizontally across the
spreadsheet. When the data is imported into ACCESS, the Periods (months)
are entered one per row (as they should be). The way I have the submission
form now, the users would have to enter the data 12 times (once for each
month in the calendar year). I'm trying to make this data-entry process as
transparent as I can for these folks ...

Is there a way that I can design a form that will allow the user to enter
the data for all 12 Periods and submit them 1 time and have them populate 12
rows? I know this may sound like a bizarre request, but perhaps there is
some JAVA code which could allow this. Would it be better to use a Data
Access Page? (Below is an example of what the user would see on the form):

JobCode Title Grade Type CurrentHDCT Jan
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
****This Data is STATIC and uneditable**** ****This
Data is entered by the users, but needs to populate the db 1 value per
row****

Thanks in advance.
 
No, each form submitted would create 1 record in the table, so you will need to create a field for
each month.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================
 
Thank you Thomas -- that's what I've always understood from a database
design standpoint: That forms update 1 db record per submission. I just
wanted to make sure there wasn't some JAVA code or other app that could
handle this request.
 
Back
Top