Set focus on first text box on first tab page and go to next record
In Access 2003/XP/2000/97, I have a form with a main tab box (created with a tab control) with multiple tab pages. When the user is on the last text box on the last tab page and presses the tab key, how can I set the focus to the first text box on the first tab page and go to the next record in the form?

---

Establish tab order between objects in tab control pages
In Access 2003/XP/2000/97, I have a form with a main tab box (created with a tab control) with four tabs on it and each tab has a number of text boxes on it. I have indexed these tabs so when the user tabs across, it goes from one tab page to another. However when it reaches the last text box on a particular tab instead of going to the next tab, it goes to the next record.

---

Update from Subform
I have a form that displays customer order information, and a subform that show the individual items ordered and not shipped. on the subform I have a check box on each item ordered line. The user can select one or more of these items to ship by checking the check box, and by clicking a command button on the main form. How do I update th order record or records with quantiy shipped based on the check box?

---

Enable users to find a record by selecting a value from a list
When you design a form in Access, you can create a list box (list box: A control that provides a list of choices. A list box consists of a list and an optional label.) or a combo box (combo box: A control used on a form that provides the combined functionality of a list box and a text box. You can type a value in a combo box, or you can click the control to display a list and then select an item from that list.) that can be used to find a record when a value is selected from the list. This makes it easier for users to quickly find existing records without having to type a value into the Find dialog box.

---

Add a text box control to a form or report
The text box is the standard control used for viewing and editing data on forms and reports. Many different types of data can be displayed in text boxes, and you can also use them to perform calculations. This article explains how to create and use a text box and also explains some important text box properties. What do you want to do: Add a bound text box, Add an unbound text box, Add a calculated text box, Understand text box properties.

---

Text box in a form
Can I use a data from text box in a form from last record as default data in text box in a form form present 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.

---

Hide report object if no value
In Access 2003/XP/2000/97, I've created a report. In my report, I want to hide a text box if it has no value. Currently, if the text box value is nothing, a blank line is printed in the report. Is there a way to not print blank lines if my text box has no value?

---

cbo box to subform + add records
I want to have a combo box select a record and display that record's information in the subform. This can be based directly on the table, or from a qry (I already have a query because I use an expression for a concatenated lname & fname & dob elsewhere). I've accomplished this by having the cboSelectedPatient on the main form, and appropriately linking the master & child link properties, and requerying "On Update". ...

---

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.

---

Dynamically size report object
In Access 2003/XP/2000/97, I've created a report. In this report, I have a text box object that could return a value that has a small number of characters or it could have a large value in it. I don't want to create the text box object too big on the report in case the value that it returns is very small. It would look silly to have all of the blank lines. Is there a way that I can dynamically size this text box?

---

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.

---

Troubleshoot importing and linking
The Get External Data command is disabled. I get an error message saying the wizard is not installed or is disabled. I started the wizard, but it disappeared. What do I do? I don't see Microsoft Excel listed in the Files of Type box. I get an error saying Access cannot import data from my file. The option to append data to an existing table is disabled when importing a spreadsheet. I am importing data from a spreadsheet, but I cannot specify field options for any field other than the first.I get errors when I import or link to a spreadsheet or text file, or the data doesn't get imported (or linked to) properly. Importing a text file is taking a long time. I get errors when I append data to a spreadsheet or text file. Some field values appear truncated in a linked table. I get the Numeric field overflow message when I query a linked table. I can't open or update a linked Microsoft Visual FoxPro or dBASE table. I can't open or update a linked Paradox table. I can't open or update a linked SQL table. I get a key violation message. I imported a file and Access says it created a Tablename$_ImportErrors table. I'm trying to import or link data from my security-enabled database. File extensions don't show up beside the file names in the Files Of Type dialog box. I get an "ODBC - connection to datasourcename failed" message when I open a table or form in a converted database.

---

subforms update ALL records at once
I have a set of tables that are accessed by forms and subforms. A couple of the subforms seem to update ALL of the records in the relevant table when data is entered, while other subforms correctly update only the viewed record Ideas on where to start debugging this would be greatly appreciated!

---

Me reference in form
I have created a form that pulls information at a group and effective date level (there are multiple funds per group effective date combination). I am trying to create an update query that would update a reconciler to that group/effective date, but have it update every fund under that group/effectuve date. I created a query that will update this, but the only way I can make it work is to have it ask you for the group and effective date. However, I would like it to use the information already pulled in the form. In order to do this I have been trying to use the Me reference, but haven't gotten it to work. I have a feeling I'm using the wrong syntax, but can't seem to find how to do this correctly. ...

---

Passing a variable's content from one form to another's SQL string
Access 2003. On one form is a text box and command button. I enter CO*, for example in the text box and press the command button. In the command button's click event, the value of the text box, here CO* is assigned to a Public variable StringToUse. Then a Docmd opens another form. In this forms Record Set property I have placed the SQL code: SELECT * FROM tblMain WHERE LastName LIKE 'StringToUse'; I want this code to use the CO* in StringToUse to select the records. It appears StringToUse is empty when the second form is opened. Am I declaring StringToUse improperly, and/or is my SQL string incorrect?

---

Filter a query based on data entered in a text box
In Access 2003/XP/2000/97, I need to search for all Usernames containing 'ahm'. I want to create a form with a text box and a button. In the text box, I want to enter the search criteria and then click on the button to open the query displaying only the results where the Username field contains the value entered in the text box. How can I do this?

---

How to Do an Access 2007 Update Query
Access 2007 is a database program created by the Microsoft Corporation. It is an important part of the Microsoft office suite because it allows users to effectively track items, make professional reports and share information. Update queries allow users to update data in a set of forms or records. Doing a update query in Access 2007 only takes a few minutes when you have the correct information.

---

Sub-form Button Function Question
I have a relationship database with a primary group, family group, and company group. Each of these groups has a separate table and form with 4th table defining the relationship. We regularly add records to the database and to make it easy have created an add-record form based on the primary group. Within this form we have embedded sub forms for the family, company, and even the relationship groups. All of this works well with the exception of the "goto last record" button I have created for each of these forms. The button works if you open any single form on it's own, but none of them work when you open the "add new record" form. Darned if we can figure out why. There is no error message, it just doesn't go to the last record, or any record for that matter.

---

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?

---

Using A Combo Box To Find A Record
In this tutorial you will learn how to Use A Combo Box To Find A Record.

---

Overview of Windows Controls
A command button is a rectangular object that allows the user to dismiss a dialog box or to initiate an action. A combo box is a Windows control made of two parts: a text portion and a list. A text box is used to display a selection made from a list of items. On the right side of the text box, there is a down-pointing arrow that allows the user to know that the control holds a list. A radio button is a Windows control made of a round box O. In practical usage, a radio button is usually (if not always) accompanied by other radio buttons. A check box is a control that allows the user to validate or invalidate an option. A check box appears as a little square box. A toggle button is a type of button that behaves like a check box. It displays like a command button but behaves like a check box.

---

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.

---

Conditionally change the background color of a text box on a Continuous Form in Access 2003/XP/2000
Question: In Access 2003/XP/2000/97, how can I change the background color of a text box containing a date value on a Continuous Form? I would like to set the color individually on each record.

---

Populate one combo box based on the selection of another combo box
In Access 2003/XP/2000/97, I have a combo box that displays values based on the selection of another combo box. My problem is that when I make a different selection in the first combo box, the text in the second combo box does not change. Although the drop-down items are correctly changed in the second combo box. I have tried to requery but it doesn't work! Any suggestions?

---

Access Forms to Reports
I'm working with a one table db. I created a query that pulls select fields and I created a form from that query. So far so good. This form also has some textboxes that perform simple math. I open the form via a button so only one one record is displayed. ( I use a button where empid=empid to get the one record.) So, can you give me a jumpt start in the right direction to have the values from the form show up on a report? Maybe with a command button?! I tired using something like =form!formname!txtbox1, in an unbound textbox on the report but that did not seem to work.

---

Update the data in a database
This article explains how to update existing data. Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature. In this article * How database design affects updating * How data types affect updating * How table field properties affect updating * Use a form to update data * Use a datasheet to update data * Use an update query to change existing data * Use an append query to add records to tables * Use Data Collection to update records * Use the Find and Replace dialog box to change data * Use cascading updates to change primary and foreign key values

---

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

---

Filter records based on a combo box selection
I'm using Access 2003/XP/2000/97 and I need to figure out how to display the record details based on a combo box selection. For example, when I select a CustomerID in a combo box, how do I get the related customer name and address information to appear?

---

The Message Box
A message box is a Windows(operating system)-created form used to display some information to the user. As opposed to a regular form, the user cannot type anything on the box. There are usually two ways you can use a message box: you can simply display a message to, or request an answer from, the user.

---

Manage Data Tasks
Use this dialog box to view and manage the import and export operations (also known as specifications) that you have created for the current database. When you run either the Import Text Wizard or the Export Text Wizard, you can save the operation as a specification for future use.

---

Change the background color of a text box based on whether a value has been entered in Access 2003
Question: In Access 2003/XP/2000/97, how can I apply a conditional format on a text box? I want to change the background color to red from white when the text box has not been filled in (null value). How do I do this?

---

Queries how tos
How to assign "odd" or "even" value to every record in a table. How to assign sequential row numbers to each row in a query. How to calculate a running total. How to calculate or update "week of the month." How to calculate student grades from test results. How to determine the lowest five values of a record set, instead of the highest five values. How to determine which customers purchased both products. How to determine which tables are no longer needed as sources for queries or forms. How to "Find and Replace" a value in as many records as needed. How to read Jet's query execution plan to write more efficient queries. How to use Jet SQL to append records to a table from a text file. How to use Jet SQL to insert records into a remote database that has a database password. How to use Jet SQL to update records in (or from) a remote database that has a database password. How to use a user-defined VBA variable as criteria in a query. Where to find SQL developer tools to practice with.

---

Microsoft Access Forms and Combo Boxes
MS Access is a very versatile data handling software. The Microsoft Access Combo box is one of the many features provided which generate elegant user data entry interfaces. A combo box is a data capture control just like a text box. It has a drop down list of predefined values. The user can click on any of these values to populate the text box. Alternatively, data can be typed into a combo box too.

---

Need help on MS Access
I am creating a database using access 2003 for myself. Everything I key in a new record I have to manually type in the name in the first field, it is time consuming if the name is long. So I created a drop down list. I wanted to get the data on my "name" field, so during the list creation I choose the option: "I want the list box to look up the values in a table or query"

---

Advanced Triggers
Learning objectives: How do I run VBA code using a macro? How do I use the value in one field to automatically suggest a value for a different field? How do I change the table or query a form is bound to once the form is already created? What is the After Update event? How is it used? How do I provide a search capability for my forms? How do I create an unbound combo box? Can I implement the search capability using Visual Basic? (pdf file, install Acrobat Reader to read this tutorial.)

---

Web Database Access from Desktop Applications
This tutorial demonstrates how your desktop applications can read from and update server-side databases that are otherwise inaccessible. Yet there is more that you can do along these lines: For instance, we did not address the issue of security. Obtaining the expiration date of a registration record is of little value to the malicious user. In contrast, if such a user were to somehow detect the URL that your desktop application is calling in order to update the program's expiration date, then he could set his own registration record to have an expiration date far off in the future, and thus effectively avoid having to pay to renew his license for your program. For any such sensitive data access or modification, you should encrypt the values being passed back and forth between your desktop application and the PHP scripts on your server, so hackers cannot exploit your system.

---

MS Access Tables
I currently have a value in a text box tht I need to search for in a table, but i do not seem to be able to get the button on the form to take this value and search through the table i have created for the specific value. Any suggestion?

---

Filter a query based on a text box value
I have an Access 2003/XP/2000/97 database that contains a form called Orders. I want to be able to create a query that returns the currently selected record from the Orders form. How can I do this?

---