Sometimes you need to design a form where many fields will have similar values to the last record entered, so you can expedite data entry if all controls carry data over. There are two ways to achieve this ...
Access cannot log changes to your data at the record level. This article describes one solution for logging inserts, deletions, and edits. The typical multi-user situation is supported, and the code can be called from different forms open at the same time.
Microsoft Support - ACC2000: How to Duplicate a Main Form and Its Subform Detail Records
This article describes how you can automate the duplication of a main form record and its associated subform detail records. The article shows you how to add a command button to the Orders form of the sample database Northwind.mdb that duplicates the current order into a new order. The article then shows you how to use the new command button.
By Allen Browne
The example below shows how to duplicate the record in the main form, and also the related records in the subform.
In Access 2003, simply moving the mouse over the pages of a tab control can make the screen flicker annoyingly if Windows XP themes are active.
September 2007 update: Microsoft reports this issue is fixed in Service Pack 3 for Office 2003.
This article describes what is required to create an updateable form that is bound to an ActiveX Data Objects (ADO) Recordset object.
When you are creating new records by using a form, you may want to speed the data entry process by having fields in the new record fill automatically with values from the previous record. This article shows you how to create a sample Visual Basic for Applications function called AutoFillNewRecord() that enables you to fill selected fields (or all fields) in a new record with values from the previous record automatically.
Microsoft Access 2007 introduces many new features to give Access forms enhanced behavior and a modern look that's more Vista-like. Here are some tips for adding these features to your application.
A flexible search form provides several boxes where a user can enter criteria. An efficient search form creates the criteria from only those boxes where the user enters a value.
In the sample database, the form frmSimple shows an example where the form's recordsource is the master table (tblMaster) and the subform (subDetail) displays its corresponding records
Access 2007 lets you customize this with a new form property called
ave you ever wanted to requery a form after a user inserts a new record or modifies an existing record, to perhaps re-order things, but wanted to stay on the same record that you currently are on once the requery was done?
"Proximity Functions" is a set of Microsoft® Access® modules, forms and controls that you can use to easily add professional functionality to your Access application without programming. By simply importing a few modules, then copying and pasting one control next to a text control on your form you can add Windows-standard file open/save dialogs, folder browse dialogs, color selection dialogs, a fantastic calendar date picker dialog, and more.
An database containing both an API and Form based ToolTip solutions. The Form based solution can be used for forms in DataSheet view
Enhanced features include:
Selectable delay times for Toolltip to first appear
Selectable delay times for Tooltip to dissappear
Selectable Text Color
Selectable Background Color
Specify Tooltip size
Add a title to the Tooltip in Bold
Selectable Icon for the Tooltip
ToolTips for Lines, Boxes, any rectangular area on your Form
This demonstration database shows various methods of using the Flex Grid
ActiveX control in an Access 2000 (or later) database. Flex Grid controls can be
used to show data from a table or query on a form in a format which is not possible
using standard Access controls.