Default Forms, Reports, and Databases All versions.Assign default values from the last record - Carry data over Access 95 and later.Flicker with tab controls Access 2003 (Addressed by SP3 for Office 2003.).Duplicate the record in form and subform Access 95 and later.Locking bound controls on a form and subforms Access 97 and later.Filter a Form on a Field in a Subform Access 95 and later.Rounding in Access - Round up, round down, rounding time values Access 95 and later.Why can't I append some records? Trouble-shooting imports All versions.Quotation marks within quotes All versions.Common errors with Null Access 95 and later.Nulls: Do I need them? Access 95 and later.Getting a value from a table: DLookup() All versions.Hide duplicates selectively Access 97 and later.Numbering Entries in a Report or Form Access 2 and later.Bring the total from a subreport onto a main report All versions.Print the record in the form All versions.Limiting a Report to a Date Range Access 95 and later.Avoid #Error in form/report with no records Access 2 and later (and solves Access 2007 issue).
If you don't know how to write code, these may help.