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
Rounding Function MRound of Excel
2008-12-06 09:33:00 Normally we round numbers in calculations when the fractional part is 0.5 or more to 1 (next highest integer) or truncate it altogether. But, there are times that this fractional part itself to be rounded to a certain level so that it can be used for disbursement of money, like wages.For example, in Currencies when the value ends up in 15 cents, 30 cents they should be rounded to 25 cents, 50 cents respectively for determining the requirement of correct number and denominations of Coins for disbursement. If we decide we need only 50 Cents Coins then a value of 25 Cents or more should be rounded to 50 Cents and less than 25 Cents to zero.So, we need a function that can accept a value as precision and find multiples of that value and when the remainder value is half or more of the precision value it should be rounded to the next level. Not necessary that it should be a fractional value it can be any value as precision.google_ad_client = "pub-2376623373770548";/* Body468x60, created ... More About: Excel , Function
Custom Calculator and Eval Function
2008-11-29 07:21:00 When we think of a Calculator the image that comes into our mind is the traditional type with button labels 0-9 and with Arithmetic Operators. We have it in Windows Accessories Menu that can be converted into a Scientific Calculator as well. So we don't need to build that again in MS-Access.We are considering another type of Calculator that can accept a User Defined Expression (consisting of Data Field Names, Constants, Arithmetic Operators, Parenthesis to alter the Order of Calculations), evaluate that expression and provide a quick result.We don't need to embark on a fancy design task for this Calculator. All we need is a Text Box to enter the Expression, a Command Button and few lines of Code. The result of the calculation can be displayed either in MsgBox or in another Text Box. Before we start working on the Calculator Project, let us take a look at one of the built-in functions EVAL(), which is the main work-horse of our Custom Calculator. With this Function we don&...
Data Editing And Security Issues
2008-11-21 18:18:00 Data Entry and Editing is a major activity for maintaining the information up-to-date in databases, before we are able to prepare any meaningful output for human consumption. It is important that we make these tasks easier to the User by providing Combo Boxes, Check Boxes or Calculated Fields, like Payment-Due-Date after 30 days of Material-Delivery-Date and so on.Another important aspect is data security. I am not referring to the protection against unauthorized access from outside, for which we have adequate built-in MS-Access Security features that can be put to use. Here, our emphasis is on unintentional changes or deletions of important information by Authorized Users. For example, assume that our Employee database has a Memo Field that holds important detail information on educational and past experience of employees. Normally when the Cursor (Insertion Point) moves into a field the entire field contents will get highlighted and selected. At this point if the User's att... More About: Issues , Data
Event Trapping Summary On Datasheet
2008-11-14 21:12:00 How do we use Event Procedures like LostFocus(), GotFocus() on Datasheet view? How to display Summation of numeric values on Datasheet view?For answering both questions, we need a sample Table and a Datasheet Form. Import the following Tables from the Northwind.mdb sample database from C:Program FilesMicrosoft OfficeOffice11SamplesNorthwind.mdb. Order_DetailsProductsWe require the Products table also, because it has a reference in the ProductID field of Order_Detail Table in a Combo Box. We don't want to leave the ProductID field empty on the Order_Detail Table, without the Products Table.To Create a Datasheet Form, click on the Order_Detail Table, select Form from Insert Menu and select Autoform: Datasheet from the displayed list of options in the Formwizard.A Datasheet form will be created and will open the Table contents in Datasheet View.Select Save As? from File Menu and give the name Order Details for the Form. The Datasheet Form will be saved, but it will not be clo... More About: Summary
Event Trapping Summary On Datasheet
2008-11-14 21:12:00 How do we use Event Procedures like LostFocus(), GotFocus() on Datasheet view? How to display Summation of numeric values on Datasheet view?For answering both questions, we need a sample Table and a Datasheet Form. Import the following Tables from the Northwind.mdb sample database from C:Program FilesMicrosoft OfficeOffice11SamplesNorthwind.mdb. Order_DetailsProductsWe require the Products table also, because it has a reference in the ProductID field of Order_Detail Table in a Combo Box. We don't want to leave the ProductID field empty on the Order_Detail Table, without the Products Table.To Create a Datasheet Form, click on the Order_Detail Table, select Form from Insert Menu and select Autoform: Datasheet from the displayed list of options in the Formwizard.A Datasheet form will be created and will open the Table contents in Datasheet View.Select Save As? from File Menu and give the name Order Details for the Form. The Datasheet Form will be saved, but it will not be clo... More About: Summary
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...
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
More articles from this author: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 1, 2, 3, 4, 5, 6, 7 |
|
 |
|
 |
