Undo changes
Learn: Undo changes in Design view, Undo changes when adding or editing records in a datasheet or form, Undo changes when adding or editing records in a data access page, Revert to a saved version of a form or report.

---

Working with multiple undo and redo in Access
In Access, the Undo and Redo options allow you to undo or redo one or several changes at once. However, the range of operations that you can undo or redo will always begin with the most recent operation and you may only undo or redo operations in the order in which they took place. For example, you cannot undo just the second, fourth, and eighth changes you have made to your table design.

---

Undo and redo typing
If you complete several typing actions in Microsoft Office Access and then decide that you do not want to keep those changes, Access maintains a list of the last 20 typing actions that you made and lets you undo those changes. If, after you undo a typing action, you decide that you wanted to restore the text, you can use the Redo typing option. You can redo up to 20 of your last typing actions. The Undo and Redo features let you remove or repeat single or multiple typing actions.

---

Splash Screens in Microsoft Access
When Microsoft Access opens, the first object that opens up by default is the database window. Most of the time you would not like to give your users access the this window, so you can hide this and display your own form or switchboard. To enable you to show your own Microsoft Access form when the database opens you should create an unbound form and use the Access Start Up options to set this form to open up whenever the database is started.

---

Backing up a Microsoft Access 2007 Database
One of the rules of protecting your work and data is backing it up. We learned it from the first computer science class and we all do it, whether it's saving your vacation photos on a flash disk or burning a cd with the latest book you wrote. This also applies to databases: using a back-up easily protects against any data loss. Plus, by reverting to an older version you can "undo" actions that the command "undo" is not able to help you with.

---

You can undo and redo multiple actions in Access
In response to many customer requests, you can now undo and redo (repeat) multiple actions when you are working in views, stored procedures, and functions in Design view in Access.

---

Showing or Hiding Microsoft Access Subforms
You can hide or display a Microsoft Access subform in various ways, by using an event of the form or a form control, using a command button or using a toggle button. In many cases, your computer monitor's screen estate may be at a real premium, with many elements and form controls vying for position. In this case, the simplest and most convenient solution may be to hide objects or controls until they are required. This article shows a simple approach of hiding a Microsoft Access Sub Form if the object is not required.

---

Viewing a Live Web Page on Microsoft Access Form
With so many companies and individuals having presence on the internet, it is more likely that your customers could have their own web sites. If we build a Microsoft Access table that will store our Customer information, this table can easily save each Customers web site address in a single field that stores the URL. If we want to have immediate access to the web sites as you view your customer data in a Microsoft Access form, we can view it in a Web Browser control that we place on the form design.

---

Microsoft Access Custom Form Navigation
Customising Microsoft Access forms, adding your own menus and command buttons is part of creating a Microsoft Access database application and designing an Access graphical user interface. Microsoft Access forms can contain the built in Access navigation buttons and record counter, or you may wish to add your own.

---

Four Things to Love About Microsoft Access 2007
For many years now, Microsoft Access has been one of the most popular of all desktop database programs. Along with its bigger cousin, Microsoft SQL, Microsoft Access has helped form the core of database development for many small, medium and large businesses, and with the new version, Microsoft Access 2007, on the horizon it is important for workers to learn about the new features and benefits of this new program. Those who have been using Access 2000, Access XP or Access 2003 will recognize much of the interface of Microsoft Access 2007, but there are some notable differences, and a new look as well. It is important for those considering upgrading to the new version to understand the unique features and benefits of the 2007 version of Microsoft Access.

---

How to create a User Login Form in Microsoft Access
In my Microsoft Access database I have a table of Users, each with a user name and password, and a login form set up. I want the user name and password entered into the login form to be compared against those stored in the Microsoft Access table. If a match is found the user is allowed to access to the system, if not the system should exit. Answer » The following details one procedure that could be applied to this scenario. There are many more approaches to this and also other areas that will need to be secured within your database environment. You should also look into Disabling/Enabling the Shift Bypass Key.

---

Form Design
A form appears to be the most regularly used object of a Microsoft Access database. Although there are various means of quickly creating a form, as we saw with the Form Wizard or AutoForm and their variations, at times you will need to further customize the appearance of a form to the user as this can affect the overall understanding of your product.

---

Hiding Microsoft Access Database Forms
I have a Microsoft Access form with four command buttons that display specific forms using the DoCmd.OpenForm action. I want to hide the main database switchboard form whenever one of the four buttons is clicked on and then restore the main form when the user closes the form opened by the command button.

---

Microsoft Word documents from a Microsoft Access Form
From my Microsoft Access form I would like to hyperlink to a Microsoft Word document. At present each record contains a document name and a full file path to where the document is stored. I would like to open Word and view the specified document.

---

Microsoft Access Tutorial
This tutorial consists of the following lessons: About Microsoft Access; Create a Database; Create a Table; Adding Data; Create a Form; Modify a Form; Create a Query; Modify a Query; Create a Macro; Convert Access Database to Excel; Microsoft Access versus SQL Server.

---

Displaying Subform Totals in a Main Form in Microsoft Access
In this article we are going to show you how to display totals taken from your subform, and display these in controls in your main form. We need to be able to reference the subform control from the main Microsoft Access form. If you attempt to sum a subform field by using a calculated control on a main form, you may receive an error message in the main form control.

---

AutoExec Macro in Microsoft Access
In Microsoft Access you can use startup options to specify, for example, what form to display, whether toolbars can be customized, and whether shortcut menus are available in your Microsoft Access file. You can also use a special macro named AutoExec to carry out an action or series of actions when your database first opens. When you open a database, Microsoft Access looks for a macro with this name and, if it finds one, runs it automatically.

---

Create a form to enter and view your data
Make data entry and data viewing easier and safer with Microsoft Access forms designed and customized for user convenience. After completing this course you will be able to: 1) Create a form with the Form Wizard, with an AutoForm, and in Design view. 2) Customize a form's appearance and tab order to suit frequent users and usual data. (Microsoft Office Access 2003)

---

Free MS Access Tutorials
In Microsoft Access you can create different views of data using a select query, create a form in Microsoft Access and use it to enter and edit records, re-organise records in datasheet view using sorts and filters, create tables in Microsoft Access 2000 and few hints and tips about designing your database table.

---

Sending E-Mails from a Microsoft Access Form
Often, processes that are performed in Microsoft Access require that others be notified. The automation of E-Mails from a Microsoft Access Database Form is a prime example of this. This is particularly true when assigning individuals to specific duties/tasks, such as managing the relationship with a new customer or processing a helpdesk ticket. Because notification in most organizations means sending an email, the low-tech approach of creating and sending an email outside of your Microsoft Access database, especially if you are dealing with a high volume of notifications, can be incredibly inefficient and means the duplication of workload. Luckily these instances provide a classic opportunity to use technology to improve your productivity and in general make your job less aggravating. This article will demonstrate how to implement vb-code that will automate the sending of emails (via Outlook) from a Microsoft Access database. Because the authors experience with emailing notifications has involved a helpdesk, the objects in this database will have the most relevance for a helpdesk using Microsoft Access. However, once you understand the code and how to implement it, this capability can be adjusted to suit the needs of any Microsoft Access database system.

---

Spell Checking in a Microsoft Access Form
When filling in information in your Microsoft Access forms, you may wish to ensure that your users are correctly spelling words, particularly if this data is going to be viewed by other users. There are a few ways that you can check your spelling when entering data into an Access form, but you may wish to ensure that this is done automatically, to make sure that your users don't forget!

---

Using a Form with MS Access
This tutorial goes through how to create a form in Microsoft Access and use it to enter and edit records.

---

The Forms of a Database Application
A visual application such as a computer database usually starts with a rectangular object that hosts other controls. Such an object is a form. In Microsoft Access, you can create a form that stands on its own like the forms of other programming environments, or you can create a form that is tied to a list. This means that the process of creating a form may depend on how you proceed. Topics: Using Form, The Properties of a Form and Form Maintenance.

---

Using an Option Group to Filter a Microsoft Access Form
You can use an option group on a Microsoft Access form, report, or data access page to display a limited set of alternatives. An option group makes selecting a value easy because you can just click the value that you want. Only one option in an option group can be selected at a time. In a form or report, an option group consists of a group frame and a set of check boxes, option buttons, and toggle buttons.

---

Refresh or requery data
If you are using a Microsoft Access project, or a Microsoft Access database that's shared on a network, other users could be changing data while you are viewing the same data in a datasheet or form. Microsoft Access updates the data you see at regular intervals. However, you can immediately display the most current data by refreshing the records.

---

How to call NAG functions with Microsoft Access and Excel data
NAG supplies data in text form for the example programs it distributes with its numerical libraries. Whereas text form makes the programs simple and portable, it may not be the form in which users store data. In particular, a database enables users to better organise their data and to extract subsets of data according to a set of rules by using a Structured Query Language (SQL) statement. This article provides and describes C++ source code that extracts data from Microsoft Access and Excel databases. The software has been tested using Microsoft Visual Studio 6 and Office 2000.

---

Microsoft Access 2003 Quick Tutorial
Microsoft Access 2003 Quick Tutorial. Opening a Form and Using a Form. Forms can be used to add new records or change existing ones. (pdf file, install Acrobat Reader to read this tutorial).

---

What is a unbound form in Microsoft Access?
Basically it is a form that is not bound to any database table or query. You can usually determine if a form (or a control on a form) is bound by looking at its record source property which will either be bound to a Table, Query or SQL String. Also if you look at each control on the form you will find that each control has a Control Source, which is derived from the field names made available in the Record Source. A bound form is easier to create and requires minimal programming (if any). It allows for rapid application development since Microsoft Access is designed to make application development fast and easy. An unbound form on the other hand requires a lot of programming, BUT gives you near total control over how your application is going to work. This in some cases outweighs the numerous benefits offered by bound forms.

---

Adding A Flash Movie To A Microsoft Access Form
Question: The problem is this: My boss has requested that I include an animated company logo which has been created using Flash in our Microsoft Access database splash screen, to be opened prior to the database switchboard form opening. From here i want to open any forms, queries and reports. Is this possible, any help or advice would grateful as I have tried and can not find the solution? ANSWER » Yes, this is possible using the following details and design -

---

Gaining Remote Access to Microsoft Access with RDO
This tutorial shows how to use the RDO control, which is similar to the ADO control, to access a Microsoft Access Database on a network drive from a machine on another node of the network. TOC: Gaining Remote Access to Microsoft Access with RDO; Remote data location; Create an ODBC source on XPHTEK; Visual Basic Application; Controls on the form.

---

Print A Single Record from a Microsoft Access Form into a Report
You may, at times, wish to only print the record that you are currently displaying in your Microsoft Access form. This can be done directly from the Form's File: Print Option and choosing Print Range : Selected Record(s). However, forms are not really optimized to print out records and you may wish to present your data in a more user friendly approach.

---

Unbound form SQL Backend Access Front End
I want to create a form in Microsoft Access with unbound form where I can search for a record by ID on the top screen and the record's information will be filled in the text boxes on the bottom part. Please note, I am using SQL as the backend.

---

Forms
In the seventh article in our series covering Microsoft Access, we take an in-depth look at forms. TOC: Creating Your First Form; The Form Wizard; Customizing Your Form.

---

Popping Up A Reminder Form in Microsoft Access
As with anything in Microsoft Access there are several ways to perform an action. It may be necessary to provide reminders of when a job, order or appointment is overdue and this can be achieved using the following process.

---

Load Subforms Dynamically
Subforms are one of the great features of Microsoft Access. If you have ever tried to replicate the Form/Subform paradigm of Access in Visual Basic, you will appreciate how simple the process really is. 1. Create the master form 2. Create the child form 3. Drag child form and drop on master form 4. Set the Link Master Field and Link Child Field properties

---

Why does my form go completely blank?
The entire Detail section of a Microsoft Access form goes blank sometimes. The text boxes you see in design view disappear when you go to use the form, leaving nothing but empty space.

---

Microsoft Access 2007: File Attachment Controls
How to attach, open, edit multiple files to a single Microsoft Access table record using a form control. (video tutorial)

---

Create a Form
Learn how to create a form in Microsoft Access with this Microsoft Access tutorial.

---

Creating Microsoft Access Forms
Forms allow the user to customize tables according to their specifications or needs. The form also allows the user to control access to a specific database. You can create forms in Access by using the Form Wizard or Design View.

---

Filter to only view Current User's Records in a Microsoft Access form or query
There may be circumstances where you, as the database developer, may only wish to allow the current user of the Microsoft Access database to view only their own records. This can be achieved using various approaches and you will find one way of dealing with this shown below. What we need to do to achieve this: Create a module to capture the Current User accessing the Microsoft Access database. Store the User Name to pass this to the Microsoft Access forms or queries. Display information that relates to the Current User only.

---