cgttsp01
asked on
How can I enter several fields for individual months, but use the same code.
Hi,
I need to convert an excel document to an Access database and enable a CF program to Add/Edit/Display the same data the document did.
The problem I need to overcome, is that each month has 39 associated input fields, which means that with Access I am limited with how many input fields I can use with the Add and Edit forms.
So, I think I need to find a way to use the same form for each month's entries.
My question is, how do I go about doing this?
Thanks
I need to convert an excel document to an Access database and enable a CF program to Add/Edit/Display the same data the document did.
The problem I need to overcome, is that each month has 39 associated input fields, which means that with Access I am limited with how many input fields I can use with the Add and Edit forms.
So, I think I need to find a way to use the same form for each month's entries.
My question is, how do I go about doing this?
Thanks
Why not create a link from your access table to the excel sheet and then qury on the access. Each month you upload the same field data or diferent field?
I'm not really following what the problem here.
Why is it a problem for you to be limited to 39 input fields?
Why can't you use the same form for each month's entries?
Spike
Why is it a problem for you to be limited to 39 input fields?
Why can't you use the same form for each month's entries?
Spike
ASKER
Spike,
Allow me to explain.
I would like to enter each set of input fields (39) for each heading (month) separately. The display page needs to show each concurrent month's set of data.
My issue would be, how do I use the same form for each set of entries (months)?
Probably I could just simply have a drop down box to select the heading (name of the month), and create a whole new record for each month.
However, how would I determine how to display the months records for 2001 separately when 2002 comes around?
Allow me to explain.
I would like to enter each set of input fields (39) for each heading (month) separately. The display page needs to show each concurrent month's set of data.
My issue would be, how do I use the same form for each set of entries (months)?
Probably I could just simply have a drop down box to select the heading (name of the month), and create a whole new record for each month.
However, how would I determine how to display the months records for 2001 separately when 2002 comes around?
ok, I sort of see where you are going with this...
If you need to use the same form and the only difference is the month name then you could put that in either a hidden form field or in a url variable. On the action page you determine the correct month using this variable.
As for displaying the data...
What is the database structure that you are using to store the data?
Spike
If you need to use the same form and the only difference is the month name then you could put that in either a hidden form field or in a url variable. On the action page you determine the correct month using this variable.
As for displaying the data...
What is the database structure that you are using to store the data?
Spike
ASKER
The group this is for has requested an Access database. Should I create one table with all the necessary entries?
Or should I create a separate table for each month?
How would I display each month's set of fields in monthly order?
Also, how would you suggest I "On the action page you determine the correct month using this variable."
Thanks
Or should I create a separate table for each month?
How would I display each month's set of fields in monthly order?
Also, how would you suggest I "On the action page you determine the correct month using this variable."
Thanks
ASKER
The group this is for has requested an Access database. Should I create one table with all the necessary entries?
Or should I create a separate table for each month?
How would I display each month's set of fields in monthly order?
Also, how would you suggest I "On the action page you determine the correct month using this variable."
Thanks
Or should I create a separate table for each month?
How would I display each month's set of fields in monthly order?
Also, how would you suggest I "On the action page you determine the correct month using this variable."
Thanks
ASKER
The group this is for has requested an Access database. Should I create one table with all the necessary entries?
Or should I create a separate table for each month?
How would I display each month's set of fields in monthly order?
Also, how would you suggest I "On the action page you determine the correct month using this variable."
Thanks
Or should I create a separate table for each month?
How would I display each month's set of fields in monthly order?
Also, how would you suggest I "On the action page you determine the correct month using this variable."
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.