Return data from one column into textbox
I am quite new to SQL and am having a problem displaying data from a column into a textbox. What I need to do is: On a form I have a combobox and a text box. In the combobox I have names. When I pick a name out of the combobox I need it to display the Job Title of that person in the textbox. I can either do this using SQL or just a query in Access whichever is best or easiest.

---

Conditional Formatting and Continuous Forms in Microsoft Access
There are times whilst working in a Microsoft Access form when you would like to indicate, by the use of background colour, that the textbox that the user is in is the currently active textbox.

---

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.

---

Use a control in an SQL statement in Access
In Access 2003/XP/2000/97, I've created a form where the user enters a value in a textbox. I want to use this value to create an SQL statement. How do I use a control's value in an SQL statement in VBA code?

---

Calculating on an access form
I have an access form with textboxes that I want added together. The textboxes and the total are not linked to a table. Right now when I put in 3 1's in 3 different textboxes and try to add them I get 111. My total textbox is not adding it's just combining all of the other textboxes into a string.

---

Textbox and Label Inner Margins
The user may give importance mainly to the information contained in a Report and insist only on getting it in the right order and layout. But, how to present this to him/her is your responsibility alone and depends on how much time you have to work on it. You will be designing a Report only once and it is part of your Project, how you do it is your own choice. Here, I would like to introduce you to few Properties of Text Boxes and Labels on a Report and how simple design changes can transform it into a nice looking Report. The following is an image of a Tabular Report designed with the Report Wizard of MS-Access.

---

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.

---

Relationship-Based Operations
In some cases, you will not want data from one table to be accessed just anyhow from another table. To manage the flow, you can set a condition that must be met. This also allows you to restrict a specific record instead of considering all records, simply because they happen to have a matching value in the foreign key of a child table. To set the condition that would be used to retrieve a specific record, you can use one of the functions referred to as domain aggregates.

---

Specify criteria for a text field
Want to limit the results of your query based on the value of a text field? You can specify exact values that you want a query field to match, partial values to match, or a set of values, any one of which to match. You can also exclude results based on specified values. Watch this demo to see how to do it.

---

Change the appearance of a control by using conditional formatting
Conditional formatting allows you to selectively highlight certain data on your form or report so that it is easier to understand. For example, you might want to format negative numbers in a red font to make it clear that those records need further attention. You can set conditional formatting for a text box or a combo box control. You can change the formatting based on the control's own value, or you can use an expression to change the formatting based on the values contained in other fields or controls. On a form, you can use conditional formatting to disable a control, and you can cause the formatting of a control to change when the cursor is positioned in that control. What do you want to do?: *Apply conditional formatting to a control based on its own value *Use an expression to apply conditional formatting to one or more controls *Change the formatting of a control on a form that has the focus *Remove conditional formatting from one or more controls *Create alternating row colors on a report

---

Database Numeric Values
A number is a digit (0, 1, 2, 3, 4, 5, 6, 7, 8, or 9), a combination of digits, or a combination of one or more digits, a separator, and one or more digits. Microsoft Access supports three categories of numbers and there are various ways you can apply one to a field. You can work in either the Datasheet View or the Design View of a Table. In the Datasheet View, you can use some of the fields from the Field Templates and this options has some limitations. In the Design View, before specifying the particular numeric type of a field, first set its Data Type to Number. Learn: Integer-Based Data Types, Decimal Data Types, Arithmetic Functions, Series-Based Functions, Business Functions, Finance Functions.

---

Set default values for fields or controls
This article explains how to set a default value for a table field or for a control on a form in a Microsoft Office Access 2007 database. The default values that you set will appear in the field or control whenever you create a new record in your database. In this article * Understand default values * Set a default value for a table field * Set a default value for a control * Set a default row for a list box or combo box * Examples of default values

---

Action Queries
We have used the concept of a query so far only to create a list of fields that would be considered for a set of records. We also mentioned that a query in Microsoft Access is simply a means of visually representing data. Indeed, a query is based on a SQL statement. As SQL is its own, fully functional language, we can use it to perform far more operations than to only select columns for a query.

---

Create a table
When you create a database, you store your data in tables - subject-based lists that contain rows and columns. For instance, you can create a Contacts table to store a list of names, addresses, and telephone numbers, or a Products table to store information about products. This article explains how to create a table, how to add fields to a table, and how to set a table's primary key (primary key: One or more fields (columns) whose values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.). It also explains how to set field and table properties.

---

Calculate Age
Microsoft Access does not include a function that will calculate the age of a person or thing based on a given date. This topic contains Microsoft Visual Basic for Applications (VBA) code for two custom functions, Age and AgeMonths, that will calculate age based on a given date. Learn how to calculate the age of a person or thing based on a given date.

---

Date Parameters for generating Microsoft Access Reports
When generating Microsoft Access Reports, it may be necessary to apply parameters based upon dates to allow your users to view data relating to specific information only. The following Microsoft Access database example gives the user various options of populating date fields based upon preset values for today, week, month and year and also allows the user to supply their own values for the data that the report should be based upon.

---

MS Access Date/Time ODBC issue
When you run a query based on a linked (attached) Microsoft SQL Server table that contains a Date/Time field, and the criteria for the Date/Time field contains a literal time value, Microsoft Access returns an empty result set.

---

Set Form, Report, and Control Properties in Code
Form , Report , and Control objects are Microsoft Access objects. You can set properties for these objects from within a Sub, Function, or event procedure. You can also set properties for form and report sections. Learn how to set properties of forms, reports, and controls.

---

Set AutoNumbers to start from ...
How to set an AutoNumber field so it begins from a number other than 1.

---

Sort records based on partial values in a field
There may be times when you want to sort records based only on the month portion of date values and ignore the day and year. Or, you might want to sort records based only on the first few characters of a text field. This topic shows you how to do perform these searches by creating simple expressions. What do you want to do? * Sort on partial date values * Sort on partial text values

---

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.

---

Change the formatting of a field in a report based on its value
In Access 2003/XP/2000/97, I am trying to create a report that will have one field change colors based on the results of a query. How do I do this?

---

Series-Based Functions
A series or collection-based function is one that considers a particular column and performs an operations on all of its cells. For example, if you have a particular column in which users enter a string, you may want to count the number of strings that have been entered in the cells under that column.

---

Domain-Based Functions
A domain-based function is used to get a value from another object and deliver it to the object in which it is being used or called. The general syntax of these functions is:

---

HTML
Hypertext markup language (HTML) consists of a set of "tags" that tell a web browser how a web page should look and operate. Learning objectives: understand the structure of an HTML document; use HTML tags to format web-based content; create hyperlinks between two documents; use HTML tables to display tabular data and format pages. (install Acrobat Reader to read this tutorial).

---

Sorting String-Based Fields
Most fields of a database contain strings. This allows you to sort them in alphabetical order. When sorting the strings of a column, Microsoft Access refers to the language of the computer set in the Control Panel. That language defines its alphabetical rules. This also implies that the rules in one language are not necessarily the same in another language. To sort the records of a table or query, you must specify the field that would be used as the reference.

---

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?

---

Switch between different languages as you type
You can use two methods, the Set Language method and the Language Bar method, to switching between different languages when typing in 2007 Microsoft Office system programs. The method that you choose is based on the different languages that you use and your personal preference. What do you want to do? * Which method should I use? * Switch between different languages using the Language Bar * Where is the Language Bar? * More information

---

Sorting and Filtering Text-Based Fields
In reality, queries are not the only objects used to analyze data. The main reason for using a query is that it can save its results to be used when necessary. The analysis done on a table or a form is usually temporary and may be lost when you close the table or the form. Other than that, most data analysis operations you can perform on a query are also available on tables and forms. TOC: Sorting Records on Empty Fields, Filtering Empty Fields, Sorting String-Based Fields, Sorting Records in SQL, Filtering String-Based Fields

---

Set or Change the Primary Key
The Access application uses the primary key to identify each item in a database table. When you set or change the key, you modify the ID number that the program uses to match records from one table to another. Here's how to set or change the key.

---

Demo: Select the right form view
Forms are used to display a set of data that is stored in related tables or queries within in a database. Forms help present data in an organized and attractive manner, based on the design and view. Selecting the right form view is important because it affects both the performance and the ease of use of your database, including data entry, analysis, and viewing. Watch this demo to learn which form style will best match the needs of your database users.

---

Display a particular subform based on a combo box selection
In Access 2003/XP/2000/97, I need to figure out how to display a particular subform on a main form (I have 3 subforms) based on a combo box selection.

---

The Structured Query Language
So far, to create a query we have learned to use either the Query Wizard or the Design View of a query. In both cases, we were selecting fields and adding them to the query. This concept of building a query is based on the Structured Query Language abbreviated SQL. In fact, all queries are based on SQL and this language is used by most database development environments, including Microsoft Access.

---

Set Page Layout in Access 2007
All the components of page layout - such as page orientation, margins and page size can be set in the page layout section of print preview in Microsoft Access 2007. Check out this video tutorial to find out how to set page layout in Access 2007.

---

The Structured Query Language (SQL)
So far, to create a query we have learned to use either the Query Wizard or the Design View of a query. In both cases, we were selecting fields and adding them to the query. This concept of building a query is based on the Structured Query Language abbreviated SQL. In fact, all queries are based on SQL and this language is used by most database development environments, including Microsoft Access.

---

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?

---

DAvg Function
In Access, the DAvg function returns the average of a set of numeric values in a specified set of records (or domain).

---

DSum Function
In Access, the DSum function returns the sum of a set of numeric values in a specified set of records (or domain).

---

Filtering String-Based Fields
Imagine you have a table where some records can be recognized as belonging to a category. For example, in a list of persons, you may have a column that shows each one's gender. Obviously different people would have different values but a group of people would have the same value and another group would have another same value. Based on such a field, you can create a list that includes only the people who share one of the values. To do this, you would filter the values. Microsoft Access provides various techniques to visually filter records.

---

Change a Field's Data Type
When you first design and build a database, you plan one or more tables, define the fields (columns) for each table and set a data type for each field. For example, if you need to store dates and times, you set a field to the Date/Time data type. If you need to store names and addresses, you set one or more fields to the Text data type, and so on. Here are some steps on how to change a field's data type in Microsoft Access 2003.

---