<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>LEARN MS-ACCESS TIPS AND TRICKS</title>
	<link>http://msaccesstips.com</link>
	<description>Free MS-Access downloads</description>
	<lastBuildDate>Tue, 15 May 2012 19:35:51 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.3.2" -->

	<item>
		<title>ChDir and IN Clause of Access Query</title>
		<description><![CDATA[Last week we have learned how to change the Directory Path control of VBA to the CurrentProject.Path (active database’s location) with the use of ChDrive() and ChDir() Commands, without altering the Default Database Folder settings under Access Options. If you don’t like to use DOS commands then you can change the Default Database Folder setting [...]]]></description>
		<link>http://msaccesstips.com/2012/05/chdir-and-in-clause-of-access-query/</link>
			</item>
	<item>
		<title>Microsoft DOS Commands in VBA-2</title>
		<description><![CDATA[With the MkDir() Command we were able to create a folder on disk, with the help of a small VBA routine that we have written last week.&#160; We don’t even need a separate program to do this, we can directly execute this command from the Debug Window, like the following example: MkDir &#34;C:\Developers\Projects&#34; The only [...]]]></description>
		<link>http://msaccesstips.com/2012/05/microsoft-dos-commands-in-vba-2/</link>
			</item>
	<item>
		<title>Microsoft DOS Commands in VBA</title>
		<description><![CDATA[Continued from last week’s Article: Disk Operating System Commands in VBA. Once we determine the presence of a file in a folder with the Dir() Command we can do certain operations on the file, like opening that file in it’s parent application through the Shell() Command or make a copy of that file to a [...]]]></description>
		<link>http://msaccesstips.com/2012/04/microsoft-dos-commands-in-vba/</link>
			</item>
	<item>
		<title>Disk Operating System Commands in VBA</title>
		<description><![CDATA[The first edition of Microsoft Disk Operating System (MS-DOS 1.0) was launched in 1982.&#160; The first edition of Microsoft Windows 1.0 Operating System, Disk Operating system with Graphical User Interface (GUI), released on November 20, 1985 – Source: www.wikipedia.org.&#160; The Disk operating System Version under Windows7 is 6.1.7600. Disk Operating System Commands (both Internal and [...]]]></description>
		<link>http://msaccesstips.com/2012/04/disk-operating-system-commands-in-vba/</link>
			</item>
	<item>
		<title>Happy Easter to all our Readers</title>
		<description><![CDATA[Easter is a good time to enjoy all of your many meaningful blessings: family, friends, and of course chocolate molded into tasty bunnies. May you be blessed with God&#8217;s warm love and trust in his living grace this Easter. Have an awesome Easter. Have fun Easter egg hunting and hanging out with family. IIF vs [...]]]></description>
		<link>http://msaccesstips.com/2012/04/happy-easter-to-all-our-readers/</link>
			</item>
	<item>
		<title>Opening Specific Page of Pdf File</title>
		<description><![CDATA[Opening an external file (Word, Excel or Adobe .pdf file) from Microsoft Access is not a big issue.&#160; We can use the HyperLink tool (Ctrl+K) to browse and find a file on disk and setup a Hyperlink on a form.&#160; We can launch the Hyperlink tool from the Hyperlink Address Property of a Label, browse [...]]]></description>
		<link>http://msaccesstips.com/2012/03/opening-specific-page-of-pdf-file/</link>
			</item>
	<item>
		<title>Calculating Time Difference</title>
		<description><![CDATA[How do we calculate difference of time in Hours, Minutes and Seconds between two time period? The time period can be on the same date or across dates. Example-1: Start Time: 21-03-2012 12:30:45 End Time:&#160;&#160; 21-03-2012 13:30:15 Example-2: Start Time: 21-03-2012 12:30:45 End Time: 24-03-2012 15:15:15 In the first example the date values in the [...]]]></description>
		<link>http://msaccesstips.com/2012/03/calculating-time-difference/</link>
			</item>
	<item>
		<title>Centralized Error Handler and Error Log</title>
		<description><![CDATA[In an earlier article with the VBA Utility program we have seen how to scan through a VBA Module (both Standard Module and Form/Report Modules – Class Modules) and insert Error Handler lines automatically, wherever they are found missing.&#160; Find the link to that Article here. I am sure that Utility Program will help you [...]]]></description>
		<link>http://msaccesstips.com/2012/03/centralized-error-handler-and-error-log/</link>
			</item>
	<item>
		<title>Changing Font Color Conditional Formatting</title>
		<description><![CDATA[With conditional formatting feature of Microsoft Access we can apply up to three colors to the font or background of a Textbox, because only three set of conditions can be set on a field at one time.&#160; If we need more than that then what?&#160; Well, we can do that job ourselves by checking for [...]]]></description>
		<link>http://msaccesstips.com/2012/02/changing-font-color-conditional-formatting/</link>
			</item>
	<item>
		<title>Duplicating fields with Conditional Formatting</title>
		<description><![CDATA[To make data entry task faster in Microsoft Access we duplicate certain field values (Ctrl+”) to bring them forward to the current record from previous record field, wherever it become necessary.&#160; If there are more than one field and needs to duplicate the same into more than one record then repeating Ctrl+” everywhere is asking [...]]]></description>
		<link>http://msaccesstips.com/2012/02/duplicating-fields-with-conditional-formatting/</link>
			</item>
	<item>
		<title>How to Use Form Filter on Report</title>
		<description><![CDATA[Normally we use a Query or processed data table as Report Source for printing selected data items, like Customer Invoices or Customer Ledger Statement etc. How do we take a print out of the current record on the Form? Let us try this simple method to start with, before using the Form Filter on Report.&#160; [...]]]></description>
		<link>http://msaccesstips.com/2012/01/how-to-use-form-filter-on-report/</link>
			</item>
	<item>
		<title>Saving Report Pages as separate PDF Files</title>
		<description><![CDATA[You are printing several Customer Invoices as a single Report, running into several pages.&#160; You have problems with this kind of Reports in segregating the Invoices and physically mailing them to the customers.&#160; If all Invoices can be saved on disk in separate PDF Files then it is easy to send them through emails to [...]]]></description>
		<link>http://msaccesstips.com/2012/01/saving-report-pages-as-separate-pdf-files/</link>
			</item>
	<item>
		<title>AutoNumber with Date and Sequence Number</title>
		<description><![CDATA[We always make use the Autonumber feature in tables to create a unique ID field for the table. It is easy to define and always starts the auto-number with 1 and increments by 1 for each record, unless you set the New Values property to Random rather than the default value Increment. What is the [...]]]></description>
		<link>http://msaccesstips.com/2012/01/autonumber-with-date-and-sequence-number/</link>
			</item>
	<item>
		<title>Assigning Module Level Error Trap Routines</title>
		<description><![CDATA[Last week I have introduced a Function to insert Error Handling lines into a VBA Function or Sub-Routine automatically.&#160; Readers commented saying that it is a good utility but its usage is somewhat cumbersome.&#160; Before running that function the user has to spot some text to search for and then run the function with that [...]]]></description>
		<link>http://msaccesstips.com/2011/12/assigning-module-level-error-trap-routines/</link>
			</item>
	<item>
		<title>Utility for inserting VBA Error Handler Code</title>
		<description><![CDATA[We have tried few examples on working with VBA Module Object Properties and Methods. We have learned how to insert a Sub-Routine into a Form Module with expression.InsertLines() method of Module Object with Program. We have also seen how to upload VBA Programs from a Text File into a Form Module with expression.AddFromFile() method of [...]]]></description>
		<link>http://msaccesstips.com/2011/12/utility-for-inserting-vba-error-handler-code/</link>
			</item>
</channel>
</rss>

