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
==============================================


<(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
>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.
>
>
>

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.


"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> ==============================================
>
>
> <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>>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.
>>
>>
>>
>
>