On 7 Jun 2005 17:34:48 -0700, "DaveA" <ny******@yahoo.com> wrote:
You always want to design the database before implementing the forms.
Certainly for such important functionality as you are describing.
It is good to be aware of Access' limitations before you design the
database.
Your 644 fields (if that were even possible) present a clear example
of a database design no-no: repeating groups.
Rather than a table with:
CalendarDate datetime
Period1Code text(1)
Period2Code text(1)
Period3Code text(1)
Period4Code text(1)
etc.,
better do something like:
CalendarDate datetime
Period integer
Code text(1)
A database is not a spreadsheet.
Perhaps it makes more sense to implement the schedule in Outlook: it
already implements many features found in a calendar application.
Another suggestion: hire professional help, at least for the database
design.
-Tom.
I've got myself into a bind here. Any help would be a life saver.
I created a form with 644 text boxes that serve as "days" for a
schedule. Each text box has a code which is populated with an X or /.
My problem is I did them all unbound. Is there a way to use code to
either create a new table or append my current table that creates the
unbound text fields starting with text0 and increasing by 1 until it
reaches 644?
Thanks in advance. I am not looking forward to creating a table with
644 text fields.
Dave