• Home
  • Microsoft Office
    • Access
      • Access Tutorials
      • Access Downloads
      • Access FAQs
      • Access Links
    • Outlook
      • Outlook Blog
      • Outlook Links
  • Windows
    • Windows Blog
    • Windows Links
  • Site Index
    • Directory
    • Downloads
    • Links
  • Store

Access Tutorials, TIPs, Examples

  • You are here:  
  • Home
  • Microsoft Office
  • Access
  • Access Links
  • Access Forms - Tips and Tricks

Navigation

  • Home
  • Microsoft Office
    • Access
      • Access Tutorials
      • Access Downloads
      • Access FAQs
      • Access Links
    • Outlook
      • Outlook Blog
      • Outlook Links
  • Windows
    • Windows Blog
    • Windows Links
  • Site Index
    • Directory
    • Downloads
    • Links
  • Store
Get notified of new content, downloads, and helpful information

Normally you will receive 1-4 email a months per list.
You will never receive spam from this website..

Access Links

Access Forms - Tips and Tricks

  • Hits: 2089
    Apply, change, or remove a theme
  • Hits: 2220
    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: 2479
    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: 2823
    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: 1948
    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: 1948
    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: 1565
    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: 2136
    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: 2112
    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: 2261
    Power Tip: Making forms easier to use and maintain
    Reader
  • Hits: 2453
    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: 2143
    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: 2295
    Subforms Should Reference the Control Rather than Field for Master Link Fields
  • Hits: 2342
    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: 2300
    Using the Form Navigation Caption
    Access 2007 lets you customize this with a new form property called
  • Hits: 218
    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: 302
    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: 230
    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: 180
    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.

Search - Web Links
Search - EDocman
Search - Categories
Search - Contacts
Search - Content
Search - News Feeds
Search - Tags

Just for You

Latest News

  • ACC2000: How to Build a Visual Basic Module to Print a Report in Landscape Mode on Legal-Size Paper
  • Office Template Store
  • What happens to those free Windows 10 upgrades after July 29, 2016?
  • Preview a Report and move to last page
  • Deploying Application (Front End) Updates

Popular

  • Microsoft Most Valued Professional MVP - Access Expert
  • Trust Center in Access 2007, 2010, 2013, and 2016
  • Why are there not many articles or examples for Access 2007, 2010, and 2013?
  • Splitting your Access database into application and data
  • What is the Access Runtime Version?
  • Home
  • Contact Us
  • Directory
  • Downloads
  • Links
Log in  \/ 
x

Login to your account

Forgot your password?

x

Password Reset

Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.


x

Access, Access VBA, Excel, Outlook, Office, PowePoint, Word, VBA, Windows, Smartphone

Access database examples, Access VBA Code Examples, Access Database Templates