LEARN MS-ACCESS TIPS AND TRICKS

RSS Feed Homepage

Articles: 1, 2, 3, 4, 5, 6, 7

Users Group and Permissions
2010-03-07 17:00:00
When you create a new Workgroup Information File, as part of the Microsoft Access Security implementation, it is important that the following two steps you follow immediately after creating the new Workgroup Information File (.mdw) file on priority basis:Create a new Administrator UserID (say myAdmin or whatever name you like) for you and join yourself as a member of the Admins Group Account.Remove the default Admin User Account from the Admins Group. If this is not done then your database is not secured and anybody can open and use it when MS-Office Software is re-installed.From now on you must use the new UserID myAdmin to login as Administrator of the Databases that uses this new common Workgroup Information File. One more thing, the databases that you create after login with the new User Name myAdmin, this User Account will be the Owner of those Databases and other Objects within it. Remember the Owner of the Database has full authority on all Objects including Administrative A...

Create Security Group Account with VBA
2010-03-01 13:25:00
Last week we have learned how to create a Microsoft Access Security User Account(SMITHJOHN) with VBA and learned how to join him as a member of the default Group Account Users. The Users and Admins Group Accounts are already present in the default Workgroup Information File (Sytem.mdw) or in the new Workgroup Information File that you create separately.If we need to group Users under different categories (like MANAGERS, SUPERVISORS, DATA ENTRY OPERATORS, EDITORS and so on) so that their access rights to different objects can be defined differently at group level and any number of Users can be joined to these groups. Once we clearly define group level access rights all Users joined to that group will inherit the privileges assigned to that Group.One User can be joined to more than one Group as well. A sample image of the User and Group Accounts control is given below and we will examine how the User SMITHJOHN's Security credentials are appearing in the Control.In the User Name...

Creating User-Account with VBA
2010-02-22 13:36:00
For creating a Microsoft Access User -Account manually in the Workgroup Information File (.mdw) we go through Tools - -> Security - -> User and Group Accounts - ->User Name Option. There, we need to provide a unique User Name and a Personal ID to create a User-Account.We have seen this procedure in the Security Main Menu. The UserIDs, PersonalIDs, Work-GroupIDs and Passwords of Users are maintained in the Workgroup Information File (a database with .mdw extension and the Default Workgroup Information File is System.mdw).Access privileges to Database Objects are stored within the database itself. Both these two parts of the Combination-Lock (UserID with PersonalID in Workgroup Information File and access rights to individual objects for each User/Group maintained within database) works together. Individual User gets access to Objects with the right UserID, Password and PersonalID. PersonalId is a very important element of the User-Profile and we need it again, if we ever need to rec...
More About: Creating

Microsoft Date Time Picker Control
2010-02-14 06:29:00
We have learned how to use Calendar Control for easy entry of Date Values into Fields on Form through the earlier Article: Animated Floating Calendar. We have used a single Calendar Control for several Date Fields by moving the Calendar Control automatically near the selected Date Field with unfolding animation.We have used this method to save space on the Form otherwise we need to place several Calendar Controls linked to each date field on the Form.Now we have a better ActiveX Control ? Microsoft Date Time Picker ? a Calendar Control that almost looks like a Combo Box on Form and easy to use.Let us get into a simple example to learn how to use this Calendar for a Date Field on a Form.Import the following Objects from C:Program FilesMicrosoft OfficeOffice11SamplesNorthwind.mdb sample database:Table: EmployeesForm: EmployeesOpen the Employees Form in Design View.Select the Company Info Tab.Select ActiveX Control? from Insert Menu.Select Microsoft Date and Timer Picker Control...

Form and Report Open Arguments
2010-02-05 08:25:00
While opening a Report or Form we can pass several Optional Values as Run-Time Arguments to control the output on the Report or to change the Form Open Mode depending on the User's Profile.For example: If the Current User belongs to a particular Users Group, in the Security Workgroups, who has only enough privilege to view the data and not to Add or Edit then we can open the Form in Read-only mode otherwise in Normal Mode, when the Current User attempts to open the Form.The following Code checks whether the Current User belongs to a particular User Group. The following Code of CheckGroup() Function must be copied into a Standard Module in your Database.Public Function CheckGroup(ByVal strUsr As String, grpName As String) As String'---------------------------------- -------------------'Author : a.p.r. pillai'Date : Feb-2010'URL : www.msaccesstips.com'Remarks: All Rights Reserved by www.msaccesstips.com'-------------------- ---------------------------------Dim wsp As Wo...

Indexing and Sorting with VBA
2010-01-28 14:47:00
A Table is normally created with a Primary Key or Index to arrange the records into certain order to view or process. Primary Key or Index can have one or more fields, in order to make the Key Values Unique, if this is not possible with a single field.If you open the Employees Table from C:Program FilesMicrosoft OfficeOffice11SamplesNorthwind.mdb sample Database in design view you can see that the EmployeeID Field is defined as Primary Key.To create an Index manually and to define it as Primary Key:Open the Table in design View.Click at the left side of the Field Name to select it.Click on the Indexes Toolbar Button.You may give any suitable name in the Index Name Field replacing PrimaryKey, if you would like to do so.If the Record Values in the selected field are not unique then you can select more data fields (up to a maximum of ten Fields) to form Unique Key for the Primary Key.You may click and drag over the Fields to select them (if they are adjoining fields) or click o...
More About: Sorting

Data Upload Controls
2010-01-12 16:47:00
In some Projects we have to upload data regularly from external data sources like dBase, Excel, flat files like CSV, Text and so on. The external file can remain linked to the Project and the data from them can be added into the local MS-Access Table for preparing ReportsFor example, let us say we have an MS-Access Application that prepares monthly Reports on Profitability of Businesses and to do this we must upload raw data on Revenue and Expenses received every month in one of the file Formats mentioned above. If our Application is designed in a such way that when the existing linked file is replaced with new data file with the same name then the Application must be able to identify the presence of new data in the attached file and allow the User to upload the new records into the master file. But, before this action is allowed it become our responsibility as a developer to see that the data once uploaded is not allowed into the System again.To do this we must install a procedure ...
More About: Data

Auto Numbering In Query Column
2010-01-04 17:37:00
We know how to create an Auto -number Field in a Table to generate Unique Sequence numbers automatically for the records added to the Table. We know how to create Sequence Numbers for data lines on Reports.On Reports, create a Text Box in Detail Section of the Report, write the expression =1 in the Control Source Property and change the Running Sum Property Value to Over All or Over Group. If you need sequence numbers for each Group separately, depending on the Sorting and Grouping settings on the Report, then the Over Group option must be set in the Property otherwise Over All for continuous numbers from start of the Report to the End.If you want to create Running Sum value of a Field, like Quantity or Total Price, then set the Running Sum Property value as explained above. For more details on Running Sum as well as creating Page-wise Totals on Access Reports visit the Page with the Title: MS-Access Report and Page Totals. But, Auto-numbering in Queries looks somewhat strange to as...
More About: Column , Query

Web Browsing within Access Form
2009-12-28 03:42:00
Browsing the World Wide Web is nothing new to us. But, how about organizing the Web Addresses of frequently visiting Websites in a Table and browse the Web from within an Access Form?Not only Internet Sites, you can browse the Intranet Website within your Local Area Network - Corporate LAN) too. All you have to do is to create an Access Form with a Microsoft Web Browser Control and a few lines of VBA Code. For example, the following VBA Code will open the GMail Web Site http://www.gmail.com/ automatically when you open the Form with the Web Browser Control, as shown in the above image.: Private Sub Form_Load()Dim strURL As String strURL = "http://www.gmail.com/" Me.WebBrowser0.Navigate strURLEnd Sub Don't know how to do it? Try the following: Open a new Form in Design View. Click somewhere on the Detail Section of the Form to select that area. Select ActiveX Control... from Insert Menu. Look for the name Microsoft Web Browser in the displayed list of Act...
More About: Browsing

Text Search Filter Web Style
2009-12-20 18:27:00
How to search for several pieces of information across all the fields and in all the records of a Table?For example, when we search for something on the Web we give several piece of text separated with , or + symbol to match any of the given text anywhere within the Web Pages and display the matching links on the screen. Search text example1 : ms-access, forms, reports, QueriesOrSearch text example2 : ms-access+forms+reports+queriesIn the same way we can create filter to display records from a table that matches several piece of Text /numbers/Phrases across in any field in any record. Last week we have learned the usage of BuildCriteria() Function to filter data using only one field. BuildCriteria() Function can accept only one Field as its first Parameter. We will be using this Function here also. But, we will pull a trick for using this Function for all the fields in a Table.So let us do this with a simple Query and a Tabular Form. Import Customers Table from C:Program FilesMicro...
More About: Style

Filter with BuildCriteria Function
2009-12-14 20:16:00
Any method that helps to find data quickly on a Form is always welcome by Users. There are several options available when you are in Form View Mode.When you Right-click on a Field a Shortcut Menu will popup showing four data filter options as shown on the sample image given below.The third option Filter For can accept a Criteria Expression like >10200 AND <=10300 or similar to filter a Range of Values from the selected field.If you would like to see more options then point on Filter option in Record Menu. There you can find two new Options: Filter by Form and Advance Filter/Sort. Filter by Form allows you to set up Criteria in more than one field to select records based on Form fields.The Advance Filter/Sort will open up Filter Design (Query Design) Window with the Source Table/Query of the Form with whatever criteria you have entered into the Filter for or Filter by Form Options earlier, if any. You can further modify the filter conditions and Sorting Order and select Apply F...

Save User Specific Parameter values
2009-12-06 16:37:00
Last week we have prepared a Report Parameter Control Form for concurrent usage on Network without clashing with other User ?s Report Data Filter Parameter Values , while preparing different Versions of the same Report. To do this we have discarded the usage of a Parameter Table as Record Source to the Parameter Form and created two Unbound Text Boxes for keying in Parameter Values for setting Filter condition in the Report Source Query. Besides that we have seen how to save the Parameter Values in the Custom Properties of the Form, when the Form is closed.The sample image of the Report Parameter Form: RptParameter is given below for reference:Last week we have used the Parameter Control's Text Box Names FromDate and ToDate for entering Date-Range values as Criteria for filtering Data in Report Source Query. The Custom Property Names we have created giving slight change to the Text Box Names, like DateFrom and DateTo.One Question we have raised last week was; is it possible to Sav...
More About: Save

Creating Using Form Custom Property
2009-11-29 19:11:00
Parameter Controls are provided to the Users for entering data Filter criteria values for preparing MS-Access Reports. A reference to the parameter control fields can be set in the criteria row of the Report Source Query directly to filter the data. A sample image of such a Parameter Control is given below. The above Report Parameter Control gives flexibility to the User to set a Date Range in the fields provided on the screen before opening one of two Report Options provided. When the User Clicks on the Preview Command Button the Report will be opened with data filtered using the Parameter Control Date Range values set as Criteria on the Source Query. To record the Date Range values (Date From and Date To) a small Table with two fields is created with a single record and used as Record Source to the above Form. The idea behind the use of a Table is to preserve the last used Report Parameter Values in the Table. Next time when we open the Form we will know for which period we hav...
More About: Property , Creating

MS-Access And Data Processing-2
2009-11-22 18:21:00
This is the continuation of earlier Article published on this subject last week. Click here to visit that Page.Last week we have explored the sample data processing methods and tried to approach the same problem in different ways to arrive at the same result. Reports are the main output component that goes to the User with critical information for analysis of business activities and for making serious business decisions. Transforming raw data into meaningful form and providing them on Reports is a real challenge of any Project.If you attain some working knowledge of different types of Queries available in MS-Access you can do most of these tasks without touching the VBA Code. Depending upon the complexity of processing steps you can use several Queries, create intermediate temporary Tables and use those tables as source for other Queries to overcome issues that may arise as hurdles in the processing steps.We will look into such an issue here so that you will know what I meant by hur...
More About: Data

MS-Access and Data Processing
2009-11-15 17:41:00
Designing Forms or Reports can be learned quickly by mastering the usage of Design Tools available in MS-Access , keeping aside the programming aspects. But, data processing is something that demands diversity in each Project and cannot be standardized. The data Table design is very important and these must be carefully planned and created for easier retrieval of information as well as to avoid duplication. Proper relationships must be established between Tables to join related information together.Ignoring the importance of these considerations, designing with casual approach and filling up data in them like you do in Microsoft Excel will land you in trouble when you attempt to prepare reports out of them. You can see a good example of database design in the C:Program FilesMicrosoft Office11SamplesNorthwind.mdb sample Data base. Open this sample database and select Relationships from Tools Menu to view the structure of various Tables and how they are organized and related one ...

Form Bookmarks And Data Editing-3
2009-11-08 17:24:00
This is the continuation of our discussion on the usage of Form Bookmarks to revisit the records which we have already visited earlier. The links to the earlier Articles are given below:Form Bookmarks And Data Editing Form Bookmarks And Data Editing-2The discussion on Bookmarks is not complete without touching the subject of Searching and Finding records and showing it as Current Record on Form using RecordsetClone.In our earlier examples we have used the Find Control (Ctrl+F or Edit - ->Find?) to search for a record and when found save its Bookmark in an Array Variable in Memory for later use.This time we will use a different method to find the record and bring it on the Form with the use of Bookmark of the RecordsetClone of the Form. For this method we will use an Unbound Text Box to enter the search key value and a Command Button to click and find the record. To keep the VBA Code simple this time we will use the Customers Table rather than Order Details table, because Order Detai...

Form Bookmarks And Data Editing-2
2009-11-01 18:23:00
In the first part of this Article, we were using the saved Bookmarks to revisit the earlier visited records one by one to take a second look, if it became necessary, to ascertain the accuracy of edited information. The Function myBookMarks() that we have created for this purpose can be added with one more Option, (along with 1=Save Bookmark, 2=retrieve Bookmarks, 3=initialize Bookmark List) to display all the edited records together in Data sheet View. But, this method has some side effects and must be aware of it to implement some work around methods in such situations. Here, we will try that with the Order Details Table. In the last example we were using the Bookmark Index Number and OrderID number values as a guide to cross check with the retrieved record. Several Products can be ordered under the same Purchase Order and all Products under the same Order will bear the same OrderIDs too. If OrderIDs are alone used in a Query Criteria to retrieve the records then all records with t...
More About: Editing

Form Bookmarks and Data Editing
2009-10-25 18:31:00
You want to edit information on 25 records on the Form randomly. You will open the main data editing Form. Search for the record by entering the Key Value to find (say Employee Code or OrderID Value) in the Find (Ctrl+F) control and edit the record when found on the Form. This procedure is repeated for all 25 records for the first time because you don't have any other choice to find and edit the information.But, the information you have changed is very critical and any mistakes in them may lead to serious issues. Mistakes can easily creep-in when you go through the finding and editing procedure in a hurry. It is important that you should have a second look at each record to verify and ensure the accuracy of changes. Going through the same procedure to find all those 25 records again by displaying the Find control, keying in the Key Values and clicking on the Find button to reach the required record is not as enjoyable as it did for the first time. But, if you can reach all ...
More About: Data , Editing

Run Slide Show when Form is Idle
2009-10-16 08:34:00
Dear Readers,I am very sorry about last two weeks unexpected events and could not come out with the weekly Articles. I had to go to India on an emergency on 27th September 2009 and the Website also failed on the same day itself due to some errors in the Web Server Configuration changes made by Administrators. I have noticed this serious state of the Website on 8th of October and could bring up the Site only on 9th of October 2009. I deeply regret the inconvenience caused to you.This week, we will create a Slide Show of images on a Form that runs when the Form remains idle for a certain period of time. It works something like the following: When the Main Switchboard Form remains idle for about one minute the Slide Show runs and each image will change on a fixed interval of about 6 Seconds. The Idle Time and Interval Time can be changed according to your specific needs.The idle time of the Form is calculated based on the inactivity (i.e. no interaction with the User) of the Main Swi...

Filter Function Output In Listbox-2
2009-09-25 14:01:00
Last week we have seen the usage of Filter() Function with a simple example and I hope you understood how it works. We have assigned constant values to the Source Array elements directly to keep the VBA Code as simple as possible. We can filter data on Forms by setting Criteria on the Filter Property of Forms. Similarly, we can use conditions in Queries to filter information from Tables as well. But, the Filter() Function gives a unique way of filtering data from an Array of information loaded from Tables or Queries and create output quickly based on matching or non-matching options. Let us try out the Filter() Function in an Address Book Application to quickly find persons or places that matches with the specified search text and display them in a List Box. We will use Names and Addresses from the Employees Table of Northwind.mdb sample database for our experiment.Following is the User Interface design that we planned to create and explains how the User will interact with it to di...

Filter Function output in ListBox
2009-09-18 15:45:00
This FILTER is not related to a Query or WHERE clause in SQL or Filter settings on a Form. It is a built-in Function. Its usage is very interesting and it is useful to quickly filter out data from an Array of information through text matching. We will use this Function to search for values across more than one field of data from a Table, extract matched items or mismatch items, as the case may be, and display them in a List Box. But first, let us look into a simple example to understand its usage. Copy and Paste the sample VBA code given below into a Standard Module in your database: Public Function myFilter()Dim X(7) As Variant, Y As VariantDim J as Integer, msg as StringX(0) = "Strawberry Milk"X(1) = "Chocolates"X(2) = "Milkshake"X(3) = "Mango Juice"X(4) = "Icecold Milk"X(5) = "Apple Juice"X(6) = "Buttermilk"X(7) = "Vanilla Icecream"'Extract all items containing the text "milk" from Array...

Dynamic ListBox ComboBox Contents
2009-09-11 18:10:00
How about displaying different Set of un-related Values in a List Box; Values in different column layouts interchangeably? Perhaps, the change over can be with the click of a Button or based on some other action from the User.When we create a List Box or Combo Box we are provided with three different options in MS-Access:Table/Query, Value List or Field List to choose from in the Row Source Type Property to fill with values in them. We normally use one of these Options to create a Combo Box or List Box and insert other Property Values, like Column Count, Column Widths, Bound Column etc. manually. But, we can use a User Defined Function in the Row Source Type Property besides the values mentioned above to fill with Values in a List Box or Combo Box. Even though this Function is known as a User Defined Function it is actually defined by Microsoft Access and given in the Help Documents with specific rules as how to use it with various parameter Values and VBA Code structure. All we h...
More About: Contents

Office Assistant And Msgbox Menus-3
2009-09-04 15:55:00
After going through the earlier Articles on this subject I hope that the Readers are now familiar with programming the Balloon Object of Microsoft Office Assistant. You have seen that you can use this feature with few lines of customizable VBA Code to display MsgBox text formatted with Color, underline and with your favorite Images on them. We can display Menus on them to obtain responses from Users, besides the buttons that we normally use like OK, Cancel, Yes, No etc.Since, this Article is the third part of this series I suggest that new Readers may go through the earlier Documents on this subject to learn interesting and simple ways to use this feature in MS-Access before continuing with this Article. Links to those Articles are given below:Color and Picture in MsgBoxOffice Assistant and MsgBox MenusOffice Assistant and MsgBox Menus-2Last week we have learned how to display Clickable Menu Options in Message Box with the use of Office Assistant. The Image of that example is gi...

Office Assistant And Msgbox Menus-2
2009-08-28 09:32:00
This is the continuation of last Week's Article: Office Assistant and MsgBox Menus. Readers may go through that Page first, if you have not already done so, before continuing. Last week we have learned how to use Office Assistant for MsgBox in a simple way and seen how to create a Menu and present it to the User, with the Labels Property of the Balloon Object. We have seen that we can display the Menu from Labels().Text Property in three different ways by setting the Values of BalloonType Property: BalloonType = msoBalloonTypeButtonsThe User can click on any of these Buttons to select one of the Options presented.BalloonType = msoBalloonTypeBulletsBalloonType = msoBalloonTypeNumbersThe second and third BalloonType Values displays the Labels().Text in different styles but they cannot be selected by the User. So, we can use these options for different situations in Programs. Let us look little closer to the overall behavior of the Balloon Object when you display MsgBox with Offic...

Office Assistant and MsgBox Menus
2009-08-19 16:55:00
In last week?s Article: Color and Picture in Message Box we have seen a method to use Office Assistant quickly to display a Message Box with formatted text. We are not going to discuss further on the formatting part but I have a general feeling that Readers would like to know how this simple method can be used to obtain responses from Users, out of several options presented to them, and do different things based on their selection of choices. I have already covered this topic by creating Functions like MsgOK(), MsgYN(), MsgOKCL() etc., with the use of Office Assistant. These can be called with only the Message Text Value alone or Message Text and Title Values as Parameters, from anywhere within the Application like the built-in Function MsgBox(). I made an attempt to simplify the usage of Office Assistant through the above mentioned Functions and others, which otherwise needs several property values to be passed to the Office Assistant?s Balloon Object for displaying. But, in the...

Color and Picture in Message Box
2009-08-14 15:41:00
Image of a Microsoft Access Message Box, with the use of Office Assistant, is shown below. The Message Box pops up after the User changes the Appointment Date field value with a new date and the Message Alert asks the User to reconfirm whether she really needs to replace the earlier Date 20/07/2009 with the new value 25/07/2009 or not.The Field Name text is underlined and field values (old and new) are displayed in different Color . Company Logo is displayed above the message text.Want to find out quickly how this works? Copy the following VBA Code into a Standard Module in your Database:Public Function MyAssistant()Dim msg As StringDim AppointmentDt As DateDim AppointmentDt2 As DateDim logo As StringAppointmentDt = #7/20/2009#AppointmentDt2 = #7/25/2009#logo = "{bmp D:ImagesCoLogo.bmp}"msg = logo & vbCr & "Existing {ul 1}Appointment Date:{ul 0}{cf 252} " & AppointmentDt & "{cf 0}" & vbCr & vbCrmsg = msg & "Replace wi...
More About: Picture

Microsoft Excel Power in MS-Access
2009-08-07 10:29:00
There are times that Microsoft Access Application Users ask for Report Data exported into Excel so that they can work on it and do their own customized analysis. In this case we can create a Macro with the Macro Command OutputTo or Visual Basic Docmd to export the Data from a Table or Query and open the Data in Excel automatically.The sample Macro Command and Parameter setting will look like the image given below:The same action in Visual Basic Code is given below:Function xPort2XL() DoCmd.OutputTo acTable, "Products", "MicrosoftExcelBiff8(*.xls)", "C:My DocumentsProducts.xls", True, "", 0End FunctionBoth can be run from a Command Button Click from the Main Switch Board. But, if the User is able to do whatever he/she does in Microsoft Excel , like writing expressions for Calculations, Formatting, Chart Preparations, Printing and so on from within Microsoft Access itself that will be a different experience altogether, right?. They can eve...
More About: Power

Unsecured Database and Users Log
2009-07-31 15:46:00
When Data Entry or Editing actions are performed on important Tables in Database s a Time-Stamp with User Name is normally saved on each record to mark that event. This is done through the Form's Before Update Event Procedure. A sample procedure is given below:Private Sub Form_BeforeUpdate(Cancel As Integer) Me![EditedBy] = CurrentUser Me![EditedDt] = NowEnd SubThese fields will be added to the Data Entry/Editing Form from the Table but will be kept hidden or disabled to prevent from manual changes. The familiar function =Now() gives the Date/Time Stamp value and the CurrentUser built-in function provides the User's Name from the current instance of the database opened in User's Workstation. We are focusing on the usage of CurrentUser function. The CurrentUser function can return the User Name value correctly from a secured database (from a database that is implemented with Microsoft Access Security features) shared on a Network. When each authorized User attemp...
More About: Users

Msaccess Report and Page Totals
2009-07-24 16:53:00
Ms-Access Functions Sum, Count, Avg etc. cannot be used in Page Header or Footer Areas of Report s for creating Page-wise Summary Values. These will work in Report Group Header/Footer or in Report Header/Footer areas only.That doesn't mean that you cannot do any calculations on Page Header/Footer Areas. You can write expressions to print useful information without using the above categories of functions.For Example: When you design Reports with built-in Report Wizard you have seen MS-Access uses expressions in the Page Footer Area to display Date/Time and Page Numbers.The Report Wizard uses the Function =Now() in a Text Box to print Date and Time and the Expression ="Page " & [Page] & " of " & [Pages] to display Page Number information in the Page Footer area.Even though we cannot use this method to calculate and print Page-wise Total Values, we can use it to print the Running Sum values on every page in Page Header and Page Footer Areas. We do...

Detail and Summary from same Report
2009-07-17 07:26:00
You don't have to design two different Report s; one for Detail Listing of records with Group-wise Totals and another one for Group-wise Totals alone. We can play a small trick to get both outputs from the same Report depending on the User's choice.Recommended reading before proceeding with this topic:Hiding Report Lines ConditionallyHiding Records and Group Footer CalculationsHiding Group Header/Footer and Detail SectionsFor hiding of Report Lines conditionally there are other methods too. For example the following VBA Code (instead of the earlier simple method we have tried) can give you the same result for hiding Detail Section Report Lines:Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If [OrderID] = 10280 Or [OrderID] = 10297 Then Report.MoveLayout = False Report.NextRecord = True Report.PrintSection = False Else Report.MoveLayout = True Report.NextRecord = True Report.PrintSection = True End IfEnd SubW...
More About: Summary