How to Create Auto Report

How to Create Auto Report Auto Report method is the easy way that MS Access provides to create a report for MS Access version 2010. You can create auto report if you need all fields from a table or query to be in the report. Creating Auto Report from Table Select table (highlight table name) Click the Report icon on the tool bar as shown in the picture below When I select Orders table then click on Report icon the report will be automatically completed in a second as shown…

Read More

Macro: How to Transfer Data from Form to Report

Macro: Transfer Text from Form to Report (VB: Transfer Text from Form to Report) In this How To, I will show you how to transfer data from textbox on form to report. Data on the textbox is not stored in the table. For example below, I have two textboxes on the form for start and end date. I want to open a report by the date range from the start date and end date that I enter on the form. I also want the date range to show on the…

Read More

How to Transfer Data from Form to Report

VB: Transfer Text from Form to Report (Macro: Transfer Text from Form to Report) In this How To, I will show you how to transfer data from textbox on form to report. Data on the textbox is not stored in the table. For example below, I have two textboxes on the form for start and end date. I want to open a report by the date range from the start date and end date that I enter on the form. I also want the date range to show on the…

Read More

How to Print Report on MS Access

How to Print Report In this How To, I will show you how to print a report. Users can print out all records or a specific record or range of records. The user can use either VB code or Macro to print as I will show the how to below. There are two most common methods to print. Print Preview Report: The user will see how the report looks like before printing. The Print Preview toolbar will display on the Navigation toolbar that allow to print and to do other…

Read More

How to Create Report with a Link to Another Report

Report links to another Report The purpose for this How To is to create a summary report that has a linked field to open a detail report of that summary field. Example below will show a report summary of total sale for each month. There is a link on the total field that will open all list of sale for that month. This How To will provide step by step how to create these two reports. Creating Queries Step #1 We need to create a query that make a summary…

Read More

How to Create a Mailing Label

How to create a mailing label The mailing label can be used to mail a letter to customer. It will be more efficient than writing down each name and address on the letter. The illustration below shows how to create a mailing label step by step. Step 1: select Cutomer table               Step 2: click on Labels icon on the report section under the Create Menu         Step 3: Select type of label then click Next>. In this HowTo, I select…

Read More

View Report of the Search Result on Search Form

View Report of the Search Result on Search Form: MS Access The customer data shown on the Search Form is come from the search result of Search or Show All button which assigns the result from the SQL SELECT statement to the Record Source of a current form. If we have a customer report with a Record Source of tbl_Customer, the original Record Source on report and the Record Source on the search form are different. If we want to open a report showing only the customer data that shows…

Read More