LEARN MS-ACCESS TIPS AND TRICKSLEARN MS-ACCESS TIPS AND TRICKSLearn Mail Merge in MS-Access. Learn how to enhance your Microsoft Access Forms with 3D Headings and Animated Controls. Step by step tutorial to prepare Graph Charts in Access. Use of Office Assistant in Access. Easy to implement Examples and Codes. Articles
Sum Min Max Avg ParamArray
2008-11-07 17:56:00 I know your immediate response after looking at the Title will be, "I know all those things, tell me something that I don't know". Well, if you haven't come across the last item (that is an odd one) in the Title before, then that is what I am trying to do here, read on. The first four words are very familiar to us they are Built-in Functions in MS-Access and Worksheet Functions in Excel.We will catch up with the last one later, after checking the usage of Min() Function (will represent the first four items in the title) in Excel and why we have some difficulty with it in MS-Access when compared with Microsoft Excel. We are not forgetting the other Functions DCount(), DSum(), DMin(), DMax() and DAvg() of Access at all. Let us look at the usage of Min() Worksheet Function in Excel. It can find the minimum Value from a Range of Cells in a single Column, from a Row of Cells across Columns or from a Range of Cells spread over several Columns and Rows.google_ad_client...
Textbox And Label Inner Margins
2008-10-31 20:06:00 Let it be a Form or Report, a good design will always catch the eye of the User and the onlooker alike. We all design them, but if we give the same Report or Form to five different people to design, they all will do it differently based on their individual skill and tastes, unless they all use the same built in wizards.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.Your Report may also travel to places through Faxes or E-mails and likely to have a wider audience to it. Where-ever it goes I expect some one to ask who designed it when compared with other Reports floating around. Luckily, MS-Access has all the right Tools you need for designing strikingly beautiful Report... More About: Label
Textbox And Label Inner Margins
2008-10-31 20:06:00 Let it be a Form or Report, a good design will always catch the eye of the User and the onlooker alike. We all design them, but if we give the same Report or Form to five different people to design, they all will do it differently based on their individual skill and tastes, unless they all use the same built in wizards.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.Your Report may also travel to places through Faxes or E-mails and likely to have a wider audience to it. Where-ever it goes I expect some one to ask who designed it when compared with other Reports floating around. Luckily, MS-Access has all the right Tools you need for designing strikingly beautiful Report... More About: Label
Multiple Parameters For Query
2008-10-24 20:22:00 Queries are an essential element in data processing and we use them a lot in various ways. While creating Queries the main issue we are faced with is how to filter data in a user-friendly manner and make things work effortless for the User. We use several methods to facilitate the user to pass values as criteria to the Queries.Creating Parameter Queries and inserting Variables (like [Enter Sales Date]) in Query 's Criteria row so that the Query will prompt for Parameter Values and the User can Key-in them directly and filter records. The Data Type for the Parameter Variable can be defined by selecting the Parameters? Option from the Query Menu when you are in Design view of the Query.Creates Text Boxes or Combo Boxes on the Form and the User fills in values into them and runs the Report or Data views. The underlying Queries will have a reference to the Text Boxes or Combo Boxes on the Form in the Criteria Row, like Forms![MyForm]![myDateCombo], and based on the values in them ...
Multiple Parameters For Query
2008-10-24 20:22:00 Queries are an essential element in data processing and we use them a lot in various ways. While creating Queries the main issue we are faced with is how to filter data in a user-friendly manner and make things work effortless for the User. We use several methods to facilitate the user to pass values as criteria to the Queries.Creating Parameter Queries and inserting Variables (like [Enter Sales Date]) in Query 's Criteria row so that the Query will prompt for Parameter Values and the User can Key-in them directly and filter records. The Data Type for the Parameter Variable can be defined by selecting the Parameters? Option from the Query Menu when you are in Design view of the Query.Creates Text Boxes or Combo Boxes on the Form and the User fills in values into them and runs the Report or Data views. The underlying Queries will have a reference to the Text Boxes or Combo Boxes on the Form in the Criteria Row, like Forms![MyForm]![myDateCombo], and based on the values in them ...
Form Menu Bars and Toolbars
2008-10-17 14:27:00 In the development process of a Database we spent most of our time on creating Tables, setting Relationships, Designing Form s, Reports, planning process steps to bring the data in Reports so that Users can make right decisions on time. Microsoft Access is loaded with plenty of Menu s and Tool Bars to make these designing tasks effortless.Once that part is over and is on the finishing stage we think about the Security issues and how the Users are going to handle the Database in day-to-day activities and what they should do or shouldn't do and so on. We don't want the Users to mess around with the Forms, Reports or any other objects and start implementing their own ideas (may be better than ours) directly, which can be disastrous.By effectively implementing Microsoft Access Security features we can regulate what a particular User or Group of Users can do or cannot do. Along with that one other aspect we consider is removal of the Default Menu Bars, Tool Bars and replacing the...
Form Menu Bars and Toolbars
2008-10-17 14:27:00 In the development process of a Database we spent most of our time on creating Tables, setting Relationships, Designing Form s, Reports, planning process steps to bring the data in Reports so that Users can make right decisions on time. Microsoft Access is loaded with plenty of Menu s and Tool Bars to make these designing tasks effortless.Once that part is over and is on the finishing stage we think about the Security issues and how the Users are going to handle the Database in day-to-day activities and what they should do or shouldn't do and so on. We don't want the Users to mess around with the Forms, Reports or any other objects and start implementing their own ideas (may be better than ours) directly, which can be disastrous.By effectively implementing Microsoft Access Security features we can regulate what a particular User or Group of Users can do or cannot do. Along with that one other aspect we consider is removal of the Default Menu Bars, Tool Bars and replacing the...
Form Menu Bars and Toolbars
2008-10-17 14:27:00 In the development process of a Database we spent most of our time on creating Tables, setting Relationships, Designing Form s, Reports, planning process steps to bring the data in Reports so that Users can make right decisions on time. Microsoft Access is loaded with plenty of Menu s and Tool Bars to make these designing tasks effortless.Once that part is over and is on the finishing stage we think about the Security issues and how the Users are going to handle the Database in day-to-day activities and what they should do or shouldn't do and so on. We don't want the Users to mess around with the Forms, Reports or any other objects and start implementing their own ideas (may be better than ours) directly, which can be disastrous.By effectively implementing Microsoft Access Security features we can regulate what a particular User or Group of Users can do or cannot do. Along with that one other aspect we consider is removal of the Default Menu Bars, Tool Bars and replacing the...
Seriality Control Finding Missing Numbers
2008-10-10 21:22:00 It is part of the Accounting/Auditing activity to maintain control over usage of important Documents like Cheque Books, Receipt Vouchers, Cheque Payment Vouchers, Local Purchase Orders and so on. Usage of these Documents is monitored very closely in business activities so that they are not misused in any way affecting the business and reputation of the Company.These Documents are mostly printed in Books of 20, 50 or 100 sheets with running Serial Numbers and the transactions involving these documents are recorded with the Serial Numbers appearing on the Documents.A periodical check is performed on the actual transactions with the physical documents to ensure that the usage of these documents is in proper order and anything missing by cancellation or any other reason is traced out and documented.We will try out a sample Program to find the missing numbers from the recorded transactions and create a list. We need the following Tables with information for our Program:Parameter Table:... More About: Missing , Control
Seriality Control Finding Missing Numbers
2008-10-10 21:22:00 It is part of the Accounting/Auditing activity to maintain control over usage of important Documents like Cheque Books, Receipt Vouchers, Cheque Payment Vouchers, Local Purchase Orders and so on. Usage of these Documents is monitored very closely in business activities so that they are not misused in any way affecting the business and reputation of the Company.These Documents are mostly printed in Books of 20, 50 or 100 sheets with running Serial Numbers and the transactions involving these documents are recorded with the Serial Numbers appearing on the Documents.A periodical check is performed on the actual transactions with the physical documents to ensure that the usage of these documents is in proper order and anything missing by cancellation or any other reason is traced out and documented.We will try out a sample Program to find the missing numbers from the recorded transactions and create a list. We need the following Tables with information for our Program:Parameter Table:... More About: Missing , Control
Seriality Control Finding Missing Numbers
2008-10-10 21:22:00 It is part of the Accounting/Auditing activity to maintain control over usage of important Documents like Cheque Books, Receipt Vouchers, Cheque Payment Vouchers, Local Purchase Orders and so on. Usage of these Documents is monitored very closely in business activities so that they are not misused in any way affecting the business and reputation of the Company.These Documents are mostly printed in Books of 20, 50 or 100 sheets with running Serial Numbers and the transactions involving these documents are recorded with the Serial Numbers appearing on the Documents.A periodical check is performed on the actual transactions with the physical documents to ensure that the usage of these documents is in proper order and anything missing by cancellation or any other reason is traced out and documented.We will try out a sample Program to find the missing numbers from the recorded transactions and create a list. We need the following Tables with information for our Program:Parameter Table:... More About: Missing , Control
Wave Shaped Reminder Ticker
2008-10-06 22:42:00 We have already seen how to create and install a Reminder Ticker that runs on a straight line on the Main Screen. We could do this with few lines of VBA Code and a Label on the Main Screen. We will try something different this time. This one not runs on a straight line but runs in a Zigzag form. An image of a sample run of this method is given below:To create this Ticker we need a series of labels arranged in a wave like form and each one of them must be named in such a way that we could address them easily in code. A sample design is given below:There are about 42 identical Labels to create. Even if we create them once manually, arranging them in this fashion is not an easy task. But we can do it with a small Program. The Program creates a new Form and creates all 42 Labels, name them as lbll to lbl42, changes other Properties as shown above.Copy the following Code into a Global Module of your Database and save it.Public Function ZIGZAG()'-------------------------------- -------... More About: Wave
Wave Shaped Reminder Ticker
2008-10-06 22:42:00 We have already seen how to create and install a Reminder Ticker that runs on a straight line on the Main Screen. We could do this with few lines of VBA Code and a Label on the Main Screen. We will try something different this time. This one not runs on a straight line but runs in a Zigzag form. An image of a sample run of this method is given below:To create this Ticker we need a series of labels arranged in a wave like form and each one of them must be named in such a way that we could address them easily in code. A sample design is given below:There are about 42 identical Labels to create. Even if we create them once manually, arranging them in this fashion is not an easy task. But we can do it with a small Program. The Program creates a new Form and creates all 42 Labels, name them as lbll to lbl42, changes other Properties as shown above.Copy the following Code into a Global Module of your Database and save it.Public Function ZIGZAG()'-------------------------------- -------... More About: Wave
Wave Shaped Reminder Ticker
2008-10-06 22:42:00 We have already seen how to create and install a Reminder Ticker that runs on a straight line on the Main Screen. We could do this with few lines of VBA Code and a Label on the Main Screen. We will try something different this time. This one not runs on a straight line but runs in a Zigzag form. An image of a sample run of this method is given below:To create this Ticker we need a series of labels arranged in a wave like form and each one of them must be named in such a way that we could address them easily in code. A sample design is given below:There are about 42 identical Labels to create. Even if we create them once manually, arranging them in this fashion is not an easy task. But we can do it with a small Program. The Program creates a new Form and creates all 42 Labels, name them as lbll to lbl42, changes other Properties as shown above.Copy the following Code into a Global Module of your Database and save it.Public Function ZIGZAG()'-------------------------------- -------... More About: Wave
No Data and Report Error
2008-09-28 13:39:00 Report Source Query or Table can end up with no output records. In that case some of the controls with formula on the Report will show #Error on them. An image of a sample report is given below:The #Error at the right top is a control that has a formula for showing the Period for which the Report is currently prepared for. The controls to the right of the word TOTAL are Sub-Totals and Totals of detail line values and all of them ended up with Errors because the underlying Query of the Report doesn't have any record to show for the current period selected by the User.Even though this is not a serious issue if it became necessary to show this Report to some one as a NIL REPORT or printed and kept for future references leaving the controls with errors this way is not in good taste on the part of the Data base Developer.The modified version of the above Report is given below with a Comment, Summary Controls showing Zero Values and Report period printed correctly.I have made few mo... More About: Report
No Data and Report Error
2008-09-28 13:39:00 Report Source Query or Table can end up with no output records. In that case some of the controls with formula on the Report will show #Error on them. An image of a sample report is given below:The #Error at the right top is a control that has a formula for showing the Period for which the Report is currently prepared for. The controls to the right of the word TOTAL are Sub-Totals and Totals of detail line values and all of them ended up with Errors because the underlying Query of the Report doesn't have any record to show for the current period selected by the User.Even though this is not a serious issue if it became necessary to show this Report to some one as a NIL REPORT or printed and kept for future references leaving the controls with errors this way is not in good taste on the part of the Data base Developer.The modified version of the above Report is given below with a Comment, Summary Controls showing Zero Values and Report period printed correctly.I have made few mo... More About: Report
Lost Links of External Tables
2008-09-21 14:46:00 We have already learned several methods to work with external data sources. By linking them to MS-Access Database or directly opening them in Queries by setting SourceDatabase and SourceConnectStr Properties. In either case the Source Data must be present in their original location all the time.But, there is a possibility that the links to some of these tables can be lost either by deleting or renaming the source table by mistake. We will come to know about the error only when we attempt to work with the external tables and chances are that the error pops up in the middle of some process steps.To alleviate this problem run a check on the linked tables as soon as the Database is open for normal operations. If any of the linked Tables is not in place then warn the User about it and shut down the Application if it has serious implications.How do we determine whether a linked external table has lost its connection with the Database or not? It is easy, attempt to open the linked table ... More About: Lost , Links , External
Lost Links of External Tables
2008-09-21 14:46:00 We have already learned several methods to work with external data sources. By linking them to MS-Access Database or directly opening them in Queries by setting SourceDatabase and SourceConnectStr Properties. In either case the Source Data must be present in their original location all the time.But, there is a possibility that the links to some of these tables can be lost either by deleting or renaming the source table by mistake. We will come to know about the error only when we attempt to work with the external tables and chances are that the error pops up in the middle of some process steps.To alleviate this problem run a check on the linked tables as soon as the Database is open for normal operations. If any of the linked Tables is not in place then warn the User about it and shut down the Application if it has serious implications.How do we determine whether a linked external table has lost its connection with the Database or not? It is easy, attempt to open the linked table ... More About: Lost , Links , External
Link External Tables with VBA
2008-09-14 14:50:00 We all know how to link a Table from external data sources manually.Highlight Get External Data from File Menu.Select Link Tables ... from the displayed options.Select the file type (dBase, Excel etc.) in the Files of Type Control.Find the location of the File and select it.Click Link to attach the selected table to the Current Database.If you are linking an external table from a Network Location, use the UNC (Universal Naming Conventions) type location reference (like \hosfs03accountsmyDatabase...) rather than using a mapped drive location reference like H:MyDatabase. You can even use your Local Drive?s share name in this manner \yourPCNameC$DatabasesmyDatabase.mdb.This method ensures that even if the drive mapping changes from H: to K: or anything else, MS-Access will have no difficulty in finding the linked Table. Otherwise you have to go for the Option Tools - ->Database Utilities - ->Linked Table Manager for refreshing the changed location reference of the table. We h... More About: Links
Link External Tables with VBA
2008-09-14 14:50:00 We all know how to link a Table from external data sources manually.Highlight Get External Data from File Menu.Select Link Tables ... from the displayed options.Select the file type (dBase, Excel etc.) in the Files of Type Control.Find the location of the File and select it.Click Link to attach the selected table to the Current Database.If you are linking an external table from a Network Location, use the UNC (Universal Naming Conventions) type location reference (like \hosfs03accountsmyDatabase...) rather than using a mapped drive location reference like H:MyDatabase. You can even use your Local Drive?s share name in this manner \yourPCNameC$DatabasesmyDatabase.mdb.This method ensures that even if the drive mapping changes from H: to K: or anything else, MS-Access will have no difficulty in finding the linked Table. Otherwise you have to go for the Option Tools - ->Database Utilities - ->Linked Table Manager for refreshing the changed location reference of the table. We h... More About: Links
Source Connect Str Property and ODBC
2008-09-06 10:37:00 We have already seen that the usage of Source Connect Str Property combined with SourceDatabase Property of MS-Access Query can be used to open external data sources, like dBase, Foxpro (Version 2.5 or 3.0) and Excel Table, directly and work with them. We have learned how to add the above Property specifications in an IN Clause directly in the SQL of the Query.Data Source like AS400 (iSeries), SQL Server and Foxpro needs an ODBC (Open DataBase Connectivity) Connect String to get access to these System?s data.The best way to learn and understand more about the Connection String Syntax of different ODBC Data Sources is to go through the following steps and look at the Connection String of the Linked Table:Create an ODBC DSN (Data Source Name). Refer the Post Linking with IBM AS400 Tables.Link the Table from the source directly using File - - > Get External Data- ->Link Table.Select ODBC Databases in the Files of Type control.Select the ODBC DSN that you have created from the displayed L... More About: Links
Source Connect Str Property and ODBC
2008-09-06 10:37:00 We have already seen that the usage of Source Connect Str Property combined with SourceDatabase Property of MS-Access Query can be used to open external data sources, like dBase, Foxpro (Version 2.5 or 3.0) and Excel Table, directly and work with them. We have learned how to add the above Property specifications in an IN Clause directly in the SQL of the Query.Data Source like AS400 (iSeries), SQL Server and Foxpro needs an ODBC (Open DataBase Connectivity) Connect String to get access to these System?s data.The best way to learn and understand more about the Connection String Syntax of different ODBC Data Sources is to go through the following steps and look at the Connection String of the Linked Table:Create an ODBC DSN (Data Source Name). Refer the Post Linking with IBM AS400 Tables.Link the Table from the source directly using File - - > Get External Data- ->Link Table.Select ODBC Databases in the Files of Type control.Select the ODBC DSN that you have created from the displayed L... More About: Links
Access Live Data in Excel-2
2008-08-31 10:14:00 This is the continuation of the earlier Post Access Live Data in Excel . Please go through the earlier Article before continuing.If you want to make changes to the Query that you have created for bringing Access Data into Excel you may do so.Click in a cell within the Data Area on the Worksheet.Point to Import External Data (Get External Data in MS-Office2000) in Data Menu.Select Edit Query from the displayed Menu. The Wizard will guide you through the earlier selections and you can modify them before saving the Query.Alternatively you can open Microsoft Query Program (C:Program FilesMicrosoft OfficeOffice11MSQRY32.EXE in MS-Access 2003) and open the saved Query (Refer earlier Post Access Live Data in Excel for Query File's default location) from File Menu, edit the SQL String and view the Output data in the Query Editor before saving the changes.When you open the Query that you have created and saved earlier the Source Data will be displayed in Datasheet View. Click on the SQ... More About: Links
Access Live Data in Excel-2
2008-08-31 10:14:00 This is the continuation of the earlier Post Access Live Data in Excel . Please go through the earlier Article before continuing.If you want to make changes to the Query that you have created for bringing Access Data into Excel you may do so.Click in a cell within the Data Area on the Worksheet.Point to Import External Data (Get External Data in MS-Office2000) in Data Menu.Select Edit Query from the displayed Menu. The Wizard will guide you through the earlier selections and you can modify them before saving the Query.Alternatively you can open Microsoft Query Program (C:Program FilesMicrosoft OfficeOffice11MSQRY32.EXE in MS-Access 2003) and open the saved Query (Refer earlier Post Access Live Data in Excel for Query File's default location) from File Menu, edit the SQL String and view the Output data in the Query Editor before saving the changes.When you open the Query that you have created and saved earlier the Source Data will be displayed in Datasheet View. Click on the SQ... More About: Links
MS-Access Live Data in Excel
2008-08-21 20:31:00 We have already learned tricks to open and work with external data sources like Access Table, dBase Files and Excel Table without linking them permanently. We have tried VBA and Query based methods too.We have yet to try the ODBC connection string in Source Connect Str Property in a Query to open external data files with this method. Even though we can link external data into MS-Access manually we will be trying the VBA based method for linking external files later. But, before going into all that we will try a different trick, for a change in the one way traffic, so to speak, of data flow from external data sources into Access. But it is not exactly one way data flow into Access we can update external data from within Access, with or without direct links. The Data Sources that we have opened after setting Source Database and Source Connect String Properties in Queries are updatable. The changes which you make on these data sets from within MS-Access will be updated back in their... More About: Links , Live
MS-Access Live Data in Excel
2008-08-21 20:31:00 We have already learned tricks to open and work with external data sources like Access Table, dBase Files and Excel Table without linking them permanently. We have tried VBA and Query based methods too.We have yet to try the ODBC connection string in Source Connect Str Property in a Query to open external data files with this method. Even though we can link external data into MS-Access manually we will be trying the VBA based method for linking external files later. But, before going into all that we will try a different trick, for a change in the one way traffic, so to speak, of data flow from external data sources into Access. But it is not exactly one way data flow into Access we can update external data from within Access, with or without direct links. The Data Sources that we have opened after setting Source Database and Source Connect String Properties in Queries are updatable. The changes which you make on these data sets from within MS-Access will be updated back in their... More About: Links , Live
Database Connection String Properties
2008-08-15 08:42:00 Opening external data sources like dBase, Excel, Table from another MS-Access Database directly in VBA Code is only one of the options available to us. Those who are not comfortable with VBA have a better and much easier method available, without linking them permanently to MS-Access Database. In either case one thing is certain that we must know how to reference different external data sources correctly with Source Database Path and Connection String Values. But, these are very easy to learn.We may face little difficulty in finding ODBC (Open Database Connectivity) Connection string Syntax, but this also we can find out by going through some shortcut tricks. Let us not mix the ODBC part now with our current example and we will deal with it later.We have seen that we can display Values from Excel Cells or Range directly on MS-Access Form controls.After going through the earlier examples for opening Access Table, dBase Table and Excel tables directly in VBA, I hope at least few reade... More About: Links , Properties
Database Connection String Properties
2008-08-15 08:42:00 Opening external data sources like dBase, Excel, Table from another MS-Access Database directly in VBA Code is only one of the options available to us. Those who are not comfortable with VBA have a better and much easier method available, without linking them permanently to MS-Access Database. In either case one thing is certain that we must know how to reference different external data sources correctly with Source Database Path and Connection String Values. But, these are very easy to learn.We may face little difficulty in finding ODBC (Open Database Connectivity) Connection string Syntax, but this also we can find out by going through some shortcut tricks. Let us not mix the ODBC part now with our current example and we will deal with it later.We have seen that we can display Values from Excel Cells or Range directly on MS-Access Form controls.After going through the earlier examples for opening Access Table, dBase Table and Excel tables directly in VBA, I hope at least few reade... More About: Links , Properties
Opening Excel Database directly
2008-08-08 10:09:00 In the World of Personal Computers many Applications came and disappeared. One of the very popular Applications was WordStar (Word Processor) used under Operating Systems CP/M (Control Program for Microcomputers) and DOS (Disk Operating System) till 1992. There were dedicated Word Processing Machines in those days using WordStar and competing Software WordPerfect. Microsoft Excel is also one of the very early days Applications, since 1985, and we all know how popular it is.The first Worksheet Program Visicalc came out in 1979 with a bang and branched out into several names Supercalc, Multiplan, Lotus 1-2-3, Microsoft Excel and others putting more power into these clones than the original Worksheet Program Visicalc. (Source: Wikipedia)Like Microsoft Access, Microsoft Excel also has very powerful Automation features that can make working in Excel more interesting. I have published two Articles in articlebase.com featuring two simple macros for Automation. The links are given at th... More About: Links , Opening , Database
Opening Excel Database directly
More articles from this author:2008-08-08 10:09:00 In the World of Personal Computers many Applications came and disappeared. One of the very popular Applications was WordStar (Word Processor) used under Operating Systems CP/M (Control Program for Microcomputers) and DOS (Disk Operating System) till 1992. There were dedicated Word Processing Machines in those days using WordStar and competing Software WordPerfect. Microsoft Excel is also one of the very early days Applications, since 1985, and we all know how popular it is.The first Worksheet Program Visicalc came out in 1979 with a bang and branched out into several names Supercalc, Multiplan, Lotus 1-2-3, Microsoft Excel and others putting more power into these clones than the original Worksheet Program Visicalc. (Source: Wikipedia)Like Microsoft Access, Microsoft Excel also has very powerful Automation features that can make working in Excel more interesting. I have published two Articles in articlebase.com featuring two simple macros for Automation. The links are given at th... More About: Links , Opening , Database 1, 2, 3, 4, 5, 6, 7 |
 |
|
 |
