Frank Vertin
asked on
How Do you layer the forms in the window that breaks up a large table for data entry?
I had this question after watching MS Access – Writing Solid VBA Code.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That was exactly what I was looking for.
Lots of columns can indicate poor table design. There's really no way to resolve this other than a rework of the structure, which often means a rework of the other objects in the database. You'd have to give more information about your structure, of course ...
Lots of rows is generally not an issue with Access, as it's pretty good with fetching data as needed.