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.

---

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

---

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.

---

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.

---

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.

---

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?

---

MS-Access and Mail Merge
When we talk about Address Labels, Form Letters, Mail Merge and so on, the name that comes into our mind is MS-Word, loaded with plenty of functions for the above tasks. It needs a database to provide source data for address labels, Form Letters etc. We can prepare a Table in Word Document and use it for Addresses or attach one from Microsoft Access or other database sources. Here, we are not going to use MS-Word for Address Labels, Form Letters and Mail Merge operations, we will do it in MS-Access. Yes, we will try Mail Merge too.

---

Create mailing labels in Access
Microsoft Office Access 2007 gives you several different options for creating labels containing data stored in your Access tables. The simplest is to use the Label Wizard in Access to create and print your labels from a report you create. In addition, you can import data into Access from other sources, such as Microsoft Office Excel 2007 workbooks and Microsoft Office Outlook 2007 contact lists and "merge" that data or existing Access tables with a Microsoft Office Word 2007 document and then create and print labels from Word.

---

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.

---

Duplicate a record in Access
I've created a form in Access 2003/XP/2000/97 and I want to have a button on the form that duplicates the current record. What VBA code do I use to duplicate the current record in a form?

---

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?

---

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?

---

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?

---

How to use addresses from an Access 2002 database to create labels in Word 2002
This article explains how to use the Mail Merge feature in Word to create and print labels using data from an Access database. The article contains instructions using the Customers Table in the Northwinds sample database that is supplied with Access.

---

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.

---

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.

---

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.

---

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?

---

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.

---

How to: Move Through a DAO Recordset
A Recordset object usually has a current position, most often at a record. When you refer to the fields in a Recordset, you obtain values from the record at the current position, which is known as the current record. However, the current position can also be immediately before the first record in a Recordset or immediately after the last record. In certain circumstances, the current position is undefined. Describes how to use the Move methods to navigate a recordset.

---

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.

---

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

---

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.

---

linking 3 tables
I have attached a db.jpg ( a screen shot) of my MS Access Database. Here we have 3 tables: S_T,SI_T and SO_T. S_T is the main Tables, S_T primary key S_Id is used as foriegn key in SI_T as SI_Section_Id and PRimary key of SI_T table is SI_Id, also, the Primary key of SI_T is used as Foriegn key in Table SO_T as SO_Inspecs_id ,the Primary key of SO_T is SO_ID. I need a query that joins the three tables and displays 1 record of Each Record of Main Table S_T e.g if S_t has 1 record and it is used as PK at 2 records in SI_T then the result should only displays one record. We can say that multiple instances of Foriiegn keys should be ignored and only one record shoud be displayed.

---

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.

---

Create Labels From Microsoft Access Reports
One of the most convenient Access features for many a user is automatically printing mailing labels from your database. The labels are really just a kind of report. These instructions apply to MS Access 97.

---

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

---

Subforms in MS Access 2007
When I enter a new data record on the master form, the subform still shows the data from the previous record. Why, when I click on the new button doesn't it also clear the data from the subform and what can I do to accomplish that?

---

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.

---

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.

---

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.

---

How to: Synchronize a DAO Recordset's Record with a Form's Current Record
Learn how to synchronize a recordset's record with the form's current record.

---

Merge Access data with Word
ou can merge Microsoft Office Access 2007 data with a Word 2007 document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data.

---

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.

---

Forms/Subforms and Auto Seq numbers followup
In my sub-forms that use the increment number, how do I get the next new record to automatically show the next available number? What's happening now is that when I enter a new record, the increment is correct on that record. But, on the data entry form, the NEXT (blank) record shows the same increment number. I have stored the formula in the Default section of the control, and I have tried to set up a requery function on the form in several different areas to see which would update it. None of them seem to work quite right. The closest I've gotten is to enter a character in a new entry, then press ESC and the increment will then change to the correct number. I hope this makes sense. Thanks, and hope you have a great day.

---

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.

---

Finding, Filtering and Formatting Data
As databases grow larger and larger, finding a specific record or group of records becomes harder and harder. Fortunately, Microsoft Access is equipped with an arsenal of Find, Sort, and Filter commands that can track down and organize a table's information in record time.

---