Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How Do you  layer the forms  in the window that breaks up a large table for data entry?

Posted on 2014-10-16
3
Medium Priority
?
131 Views
Last Modified: 2014-10-22
I had this question after watching MS Access – Writing Solid VBA Code.
0
Comment
Question by:Frank Vertin
3 Comments
 
LVL 24

Accepted Solution

by:
Eirman earned 2000 total points
ID: 40384887
I didn't  hear any reference to tables and data entry in that video.

To make data entry less complicated on a data entry form, you should use tabs for the various categories of data for the record you are creating. Tabbed forms are also great for related sub-forms.
http://office.microsoft.com/en-ie/access-help/create-a-tabbed-form-HA010341583.aspx
0
 
LVL 85
ID: 40391805
By "large tables", do you mean a table with a lot of COLUMNS, or one with a lot of ROWS?

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.
0
 

Author Closing Comment

by:Frank Vertin
ID: 40397003
That was exactly what I was looking for.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question