Tabbed Control Form

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

Guest

I have a database that I'm looking to provide a tidy front-end to.
Previously, the data was stored in Excel but this became unmanageable as it
provided little reporting and data integrity was a real issue. As a part time
task at work, I volunteered to migrate the "register" from XL to Access and
that part has been done. In addition, all the reporting required has been
built.
Now the problem: the original table (one entry per 'work request') had some
70 - 80 columns and so a single page form was never going to be workable.
after some research (I'm almost learning much of this as I go) I found the
tab control and decided to build a new form based on that.
All fine until I tried to edit - told that the record is uneditable. some
research suggested that I could apply changes to the recordset property
(which I did) and this did make things editable but it seems that the data no
longer appears within the form.
Hence, my question: can I make the data editable? The form data is based
upon a query but I've checked and it's all one to one relationships which is
something else that I think can cause the data to become uneditable.
any assistance or ideas greatly appreciated.
 
atropus32 said:
I have a database that I'm looking to provide a tidy front-end to.
Previously, the data was stored in Excel but this became unmanageable as it
provided little reporting and data integrity was a real issue. As a part time
task at work, I volunteered to migrate the "register" from XL to Access and
that part has been done. In addition, all the reporting required has been
built.
Now the problem: the original table (one entry per 'work request') had some
70 - 80 columns and so a single page form was never going to be workable.
after some research (I'm almost learning much of this as I go) I found the
tab control and decided to build a new form based on that.
All fine until I tried to edit - told that the record is uneditable. some
research suggested that I could apply changes to the recordset property
(which I did) and this did make things editable but it seems that the data no
longer appears within the form.
Hence, my question: can I make the data editable? The form data is based
upon a query but I've checked and it's all one to one relationships which is
something else that I think can cause the data to become uneditable.
any assistance or ideas greatly appreciated.
Click to expand...

If I understand you correctly, you can now enter data on the form, but no
records are displayed. In which case, you probably want to set the form's
Data Entry property to No. It's got nothing to do with the tab control.
 
I have a database that I'm looking to provide a tidy front-end to.
Previously, the data was stored in Excel but this became unmanageable as it
provided little reporting and data integrity was a real issue. As a part time
task at work, I volunteered to migrate the "register" from XL to Access and
that part has been done. In addition, all the reporting required has been
built.
Click to expand...

Well... Excel is a spreadsheet, the best of the breed. Access is a
relational database interface program. THEY ARE DIFFERENT. A good
spreadsheet will very likely be a poorly normalized database!
Now the problem: the original table (one entry per 'work request') had some
70 - 80 columns and so a single page form was never going to be workable.
after some research (I'm almost learning much of this as I go) I found the
tab control and decided to build a new form based on that.
Click to expand...

That may not be the best solution. I would strongly suggest that you
should step back two paces and look at the table design. 70 fields is
far less than the 255 field limit of a table - BUT it's still an
EXTREMELY wide table; I've needed as many as 60 fields in a table, but
30 is still about as wide as I would ever want to get!
All fine until I tried to edit - told that the record is uneditable. some
research suggested that I could apply changes to the recordset property
(which I did) and this did make things editable but it seems that the data no
longer appears within the form.
Hence, my question: can I make the data editable? The form data is based
upon a query but I've checked and it's all one to one relationships which is
something else that I think can cause the data to become uneditable.
any assistance or ideas greatly appreciated.
Click to expand...

One to one relationhships are VERY RARE. If you're not familiar with
the terms "Subclassing" or "Field level security", then it is likely
that you are splitting up your spreadsheet incorrectly! What are your
tables? Why are they one-to-one?

In any case, rather than a massive Query reproducing the spreadsheet
look, consider using a Form (for the "master" table) with Subforms
(for the related tables). This will solve your updatability problems
and very likely provide a better user interface as well.

John W. Vinson[MVP]
 
Back
Top