Duplicate the record in form and subform
How to duplicate the current record on a form in a Microsoft Access database, along with the related records in the subform.

---

Create a Query in Microsoft Access to Find Duplicate Entries in a Table
There are many causes for duplicate data: for instance if you have multiple users entering data simultaneously via linked tables, or you might inherit a table with duplicate data already entered. Running into duplicate data in an Access Database can be quite annoying during the hectic workday, so I decided to write up a technique to help identify the duplicate records so you can manually handle them.

---

Prevent Duplicate Values
You can keep your Microsoft Access 2003 database free of confusing clutter by preventing duplicate values. For example, if you create a file where the key field is defined as the customer number field, you'll want the system to ensure that each record in the file has a unique customer number.

---

MS-Access Find Duplicate Query Wizard
As the administrator of a Microsoft Access database, one of the jobs that you may need to do is the keep the database working as efficiently as possible. A major cause of performance issues and database slowdown is erroneous or duplicated data contained in a table. We can keep these problems to a minimum by validating data entry and preventing duplicate information from being entered. We may have inherited a database that already contains duplicate information, and in the case we can use the Find Duplicates Query Wizard to search out this data. Using this wizard we can create a query that reports which record(s) in a table are duplicated using some field or fields in this table as a basis for the query. Microsoft Access asks which fields that you want to use for checking duplication and also which other fields you would like to appear in the query results. We can also use the Find Duplicates Query Wizard to help find possible duplicate key violations; a valuable trick when you want to take an existing table of data and make a unique field with one of the existing data fields.

---

Find, hide, or eliminate duplicate data
This article explains how to find and hide or eliminate duplicate data by using Microsoft Office Access 2007. As a rule, you should delete duplicate values whenever possible to reduce costs and increase the accuracy of your data. Office Access 2007 provides a number of ways to find and hide or delete duplicate values, and this article explains how to use the most common methods. What do you want to do? * Understand duplicate data * Prepare some sample data * Find and edit, hide, or delete duplicate data in a single table * Find and edit, hide, or delete duplicate data in multiple tables

---

How to Prevent Duplicate Values
You can keep your Microsoft Access database free of confusing clutter by preventing duplicate values. These instructions are for Access 97.

---

Find Duplicates Easily
After creating a database in Access, typically several people enter information. Over time, you need to clean up the database to remove duplicate records. While Access provides a query for just such a process, you can quickly find duplicate data within the database itself.

---

Creating Microsoft Access Queries using the Query Wizards
In Access there are two other query wizards that are available to (1)maintain the database, and these are: Find Duplicate Query Wizard. This wizard will show duplicate records in a single Microsoft Access table, based upon the values of a field in the table.(2)Find Unmatched Query Wizard. Using this query we can show all records that do not have a corresponding record in another database table (for example, a Product with no associated Supplier, or an Employee with no associated Department) The Find Duplicates Query Wizard works on a single table, whereas the Find Unmatched Query Wizard compares records in one table with records in another.

---

How to duplicate an MS Access table and its data using ADOX
This tutorial explains a method for creating a function that will connect with an existing Microsoft Access database, retrieve one of its tables, make a duplicate of that table's structure then copy its data into the new table using ADOX.

---

Outputting one HTML file per record in an Access database
There are several ways to make your Access data available on the Web. Usually, Access displays more than one record per Web page. For example, when you create a data access page, you can browse and modify all records in the record set from one Web page. Or, when you output a datasheet to an HTML or XML file, all the records are formatted as one HTML table. However, there are times when you want to output one HTML file per record. Learn: Why output one HTML file per record in an Access database? How many ways in Access can I output one HTML file per record? Use a report to output one HTML file per record. Use the VBA PRINT statement to output one HTML file per record.

---

Microsoft Access Multi-User Application Record Locking
Record locking occurs in two environments, the Microsoft Access Interface and the ADO Recordset Object. We have already established that record locking is in effect mostly in network shares. But what is record locking exactly? Well it is a mechanism that locks records when they are being edited by a particular user so that other users cannot edit them.

---

Save a record
Microsoft Access automatically saves the record you are adding or editing as soon as you move the insertion point to a different record, or close the form or you are working on...

---

Access/VBA Tutorials
When a record is deleted from a form's recordset, then bookmarks are used to go to another record more than 262 records away from the deleted one, it appears as though the record with the correct ID is being edited, but in fact a record offset positively from that one number of records deleted) is actually edited. What you see is NOT what you get - the wrong record is edited.

---

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.

---

How to: Return a Random Record from a DAO Recordset
Microsoft Access does not have a built-in mechanism for returning a random record from a set of records. This topic describes a sample user-defined function that you can use to return a random record.

---

Find, eliminate, or hide duplicate records in Access
This article describes the different types of duplicate data and explains how to eliminate duplication from your database altogether. This article also explains how to handle situations where some data may appear to be duplicated, but only because of the way the underlying query is designed and the results it returns. Learn how to avoid displaying redundant data in your current view without deleting any data from the database.

---

Update a text box to a value when a new record is created
In an Access 2003/XP/2000/97 form, I want to check when the user adds a new record (is there any relevant event?) so that I can load a default date value in a text box. I tried to go to a new record each time the form was loaded, but that resulted in numerous unwanted records. How can I avoid this?

---

Introduction to Record Sets
Topics: The Type of Recordset Objects, Creating a Recordset Object, Characteristics of a Record Set, Opening a Record Set, Record Navigation in a Record Set, The Fields of a Recordset.

---

Record selector symbols
To show the status of the current record in a form or datasheet, Microsoft Access displays the following symbols in the current record selector.

---

Delete a record using VBA code in Access
I've created a form and I want to delete the currently selected record. How do I delete the current record in the form?

---

Printing the Record on the MS-Access Form to a Report
Imagine that we have a database that stores contact information for all employees that work for a company. There may be a time when we need output this information to a Microsoft Access Report, although at times we may only need to view information for a certain record.

---

Delphi 6 and MS Access Reports
This may sound like a weird question but I am wondering whether anyone has been able to trigger an MS Access Report from Delphi 6. I am trying to port an Access "application/database" into Delphi 6 and, while I can replicate (and even improve upon) the Access Forms, The first phase of this task is going to get a lot more complicated if I have to also duplicate the various reports that are already available in the Access database. So, what I would really like to do is to interface the Delphi application to the MS Access database in a manner that would allow me to initiate the existing Access Reports.

---

Access Tips
Adding the Database Name to a Report in Access, Automatically Compact and Repair Access Databases, Change the Default Working Folder in Access, Combining Text from Two Fields in Access, Create a Vertical Control in Access, Define a Default Field in an Access Database, Deleting Duplicate Records in Access, Display Tabbed Documents in Access 2007, Displaying Highest or Lowest Values in an Access Query's Results, Import Access Tables into Excel, Insert Time/Date in Excel or Access, Navigation Pane in Access 2007, Number Entries in an Access Report, Report Layout View in Access 2007, Techniques for Creating Forms and Reports in Access, Upgrading to Access 2007, Using Validation Rules to Restrict Data in Microsoft Access

---

How to: Display a Custom Dialog Box When the User Deletes a Record
When you select a record on a form and delete it, Access displays a dialog box asking the user to confirm the deletion of the record. Learn how to use the BeforeDelConfirm event procedure to display a custom dialog box when the user deletes a record.

---

Report by Selecting Indv Record
This article explains how to select an individual MS Access record, and generate a report.

---

Assign default values from the last record
How to have form in a Microsoft Access database automatically offer to the values of the last record, to avoid typing similar data again.

---

Set the focus on the first field in a form whenever a record is viewed
In Access 2003/XP/2000/97, I have a control button to "Add a New Record" on a form. I realized that when I clicked on it, even though a new record comes up, the cursor does not go directly to the first field of data entry. How can I get the cursor to move to the first field on the form?

---

Searching for a record based on a text box value in a form
There are times, when developing your Microsoft Access databases, that you may wish to allow your users to search for a record in the form that contains a certain value which will be entered into a textbox.

---

Displaying Custom Dialog Boxes for Custom Delete Actions in Access 2007
In Microsoft Office Access 2007, when the user selects and deletes a record on a form, Access displays a dialog box that asks the user to confirm that she wants to delete the record. In some cases, you may want to suppress this dialogue box.

---

Undo Changes in Microsoft Access Form
There are occasions when the user may need to discard changes that they have made to a record that they are entering or modifying within a Microsoft Access database form. You may wish to allow them the option to undo these changes whilst editing the record and you will find below details to create this option.

---

Operations on Record Sets
This MS-Access tutorial will teaches you about operations on record set.

---

Macro Conditional If Record Not Found
I've been trying to make a macro conditional that attempts to find a record in query X and if no such record exists, to go to form Y, however, if a record does exist, go to form Z. If I only want form X opened if such a record does not exist, wouldn't I use a conditional to cross reference the entry on a form "A" with the selected field after the FINDRECORD?? Is there an easier way?

---

Understand Referential Integrity
You can ensure that relationships between records in related tables are valid by enforcing referential integrity in Microsoft Access. For example, if referential integrity is enforced, you will not be allowed to delete a record from your Customer table if there is a matching record in your Sales table. These instructions are for Access 97.

---

Using a Combo Box to Find Records
It is possible to use an unbound combo box in the header of a form as a means of record navigation. The idea is to select an entry from the drop-down list, and have Access take you to that record.

---

How to Create a Microsoft Access Field That Automatically Generates Numbers
You can create a field that automatically generates unique numbers for each record. AutoNumbers are the simplest way to set up primary keys, which are vital if you want to establish relationships among the various tables in your database. A primary key is a unique identifier for each record in the database; with a primary key, you can share record information across multiple tables. These instructions are for Microsoft Access 97.

---

Exploring Multiple Active Record Sets with MS Access
This tutorial explains how to access multiple recordsets from a single connection to SQL Server 2005 in Microsoft Access. We will also explore the properties of the recordsets. TOC: Exploring Multiple Active Record Sets with MS Access; Connecting to SQL 2005 using ADO; Executing SQL Queries on the Open Connection; Interleaving Data from Two Recordsets.

---

Refreshing data on a child one-many form
I have a one to many relationship on a form/subform. I have buttons on the subform that basically will automatically add a new record to the table the subform is based on. I am using the sql "insert" clause to add the record - which it is dong just fine. However, I have tried the .refresh and .requery commands and neither seem to be able to display the new record automatically in the list. I have to exit the screen and come back in before the new record is displayed. WHat method can I use to cause the new record to be displayed on the child form right away?

---

Has the record been printed?
How to determine whether a record in an Access database has been printed yet.

---

Why Compact and Repair your Microsoft Access Database?
Microsoft Access databases are uniquely designed to allow databases to consistently increase in size, unless you compact them. When you delete a record from a Microsoft Access database, the space allotted for that record continues to be held in reserve by the database and it is not released for reuse. Likewise, extra space, created by modifying and shortening records, is not released for reuse.

---

How to: Determine Whether The Current Record is a New Record In a Form
Learn how to use the NewRecord property to determine if the current record is a new record.

---