Access Links

Access Forms - Tips and Tricks

  • Hits: 1998
    Apply, change, or remove a theme
  • Hits: 2135
    Assign default values from the last record
    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 ...
  • Hits: 2378
    Creating an Audit Log
    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.
  • Hits: 2741
    Duplicate a Main Form and Its Subform Detail Records
    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.
  • Hits: 1873
    Duplicate the record in form and subform
    By Allen Browne The example below shows how to duplicate the record in the main form, and also the related records in the subform.
  • Hits: 1887
    Flicker with tab controls
    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.
  • Hits: 1474
    How to bind Microsoft Access forms to ADO recordsets
    This article describes what is required to create an updateable form that is bound to an ActiveX Data Objects (ADO) Recordset object.
  • Hits: 2036
    How to fill a record with data from a previous record automatically
    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.
  • Hits: 2011
    Microsoft Access 2007Microsoft Office Access 2007 Form Design Tips
    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.
  • Hits: 2147
    Power Tip: Making forms easier to use and maintain
    Reader
  • Hits: 2371
    Search criteria
    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.
  • Hits: 2064
    Send to friend RSS for post comments 2010 Intro Series Access 2003 Access 2007 Access 2010 Access Services Code Community Developer Download Form IT Pro Macro Partner Offer Power Tips
    In today
  • Hits: 2189
    Subforms Should Reference the Control Rather than Field for Master Link Fields
  • Hits: 2273
    Synchronize Two Related Subforms on a Microsoft Access Form
    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
  • Hits: 2208
    Using the Form Navigation Caption
    Access 2007 lets you customize this with a new form property called
  • Hits: 126
    MS Access – VBA – Requery a Form While Remaining on the Same Record

    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?

  • Hits: 186
    Proximity Functions to to easily add professional functionality to your Access application

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

  • Hits: 131
    Stephen Lebans: Custom Tooltip

    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
    Selectable Margins
    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

  • Hits: 109
    Flex Grid Demo 
    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.

Latest News

Popular