Happy Onam to all our Readers
Posted On 09 Sep 2011 By a.p.r.pillai. Under External Links.
Image Source: www.dgreetings.com പുന്നെല്ലടകൊണ്ടടപ്രഥമന് - അതില് പൊന്തിക്കിടക്കുന്ന നാളികേരത്തുണ്ട് നെയ്യില് വറുത്തിട്ട മുന്തിരി.. അണ്ടിപ്പരിപ്പുകള് കണ്ണൊന്നിറുക്കി ; ... Continue Reading
No Comments
Copy Paste Data from Excel to Access2007
Posted On 22 Apr 2011 By a.p.r.pillai. Under External Links.
Methods are already built into office applications to transfer data between them. Importing/Exporting data or directly linking to it while maintaining original data in their parent applications. Transfer data into ... Continue Reading
No Comments
Attachment Field in Access2007
Posted On 28 Feb 2011 By a.p.r.pillai. Under External Links.
Working with images or animations in Applications like MS-Access was always fun. I have used Office Assistant for Message Boxes in all my Microsoft Access Applications by creating and installing ... Continue Reading
No Comments
External Files List in Hyperlinks
Posted On 06 Feb 2009 By a.p.r.pillai. Under External Links.
Is it possible to display a directory listing of External Files on a Form and open them in their parent applications? Several queries of different kind received through E-mails pointing towards this objective, from Readers of the earlier Article; File Brower in MS-Access (Common Dialog Control).
6 Comments
Lost Links of External Tables
Posted On 21 Sep 2008 By a.p.r.pillai. Under External Links.
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. ... Continue Reading
No Comments
Link External Tables with VBA
Posted On 14 Sep 2008 By a.p.r.pillai. Under External Links.
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 ... Continue Reading
4 Comments
Source Connect Str Property and ODBC
Posted On 06 Sep 2008 By a.p.r.pillai. Under External Links.
We have already seen that the usage of SourceConnectStr Property combined with SourceDatabase Property of MS-Access Query can be used to open external data sources, like dBase, Foxpro (Version 2.5 ... Continue Reading
1 Comments
Access Live Data in Excel-2
Posted On 31 Aug 2008 By a.p.r.pillai. Under External Links.
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 ... Continue Reading
No Comments
MS-Access Live Data in Excel
Posted On 21 Aug 2008 By a.p.r.pillai. Under External Links.
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 ... Continue Reading
No Comments
Database Connection String Properties
Posted On 15 Aug 2008 By a.p.r.pillai. Under External Links.
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 ... Continue Reading
1 Comments
Opening Excel Database directly
Posted On 08 Aug 2008 By a.p.r.pillai. Under External Links.
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) ... Continue Reading
No Comments
Display Excel Value Directly on Form
Posted On 01 Aug 2008 By a.p.r.pillai. Under External Links.
We have already seen how to open dBase Files directly and work with the data in VBA in the earlier Post Opening dBase File Directly. But, there are other alternatives ... Continue Reading
3 Comments
Opening dBase Files Directly
Posted On 24 Jul 2008 By a.p.r.pillai. Under External Links.
In the earlier Article Opening External Data Sources we have learned how to open another Microsoft Access Database and work with its Tables using Code. I have made a revision ... Continue Reading
No Comments
Opening External Data Sources
Posted On 18 Jul 2008 By a.p.r.pillai. Under External Links.
Linking of external data sources like dBase, Excel or Tables from another Microsoft Access Database, in a Back-End, Front-End scenario, is the most common and efficient method to work with ... Continue Reading
No Comments
Linking with IBM AS400 Tables
Posted On 19 Jun 2008 By a.p.r.pillai. Under External Links.
We can convert IBM iSeries (AS400) DB2 Table into dBase Format, download and Link or Import into MS-Access Databases. The downloading procedure must be created and run from AS400 Menus. ... Continue Reading
2 Comments
Download Free Software:Desktop Utilities, Mobile Communication, Games etc.
