Free Tools for Microsoft Access

Sign in to queue

Description

Hosts Crystal Long and Adrian Bell, both Access MVPs, discuss free tools available for Microsoft Access. They provide demos as well as links to the free tools, to help you learn all about Access!

 

Day:

1

Code:

MVPTT

Embed

Download

Download this episode

The Discussion

  • User profile image
    strive4peace


    Hello, thanks for stopping by.

    Do you have free tools, videos, or other resources to share for Microsoft Access?  .. or Excel, Visio, Word, or any Microsoft Office productPlease comment with your links (choose to open in a new window) and descriptions, thanks.  No commercial products please.  Note: Comments are only open for a short time.  

    ___________________

    now begins the links to free tools and resources discussed in the presentation:

    Contact Template for Access download
    (including Project Management and additional tables for common business needs)
    www.msAccessGurus.com/Contacts.htm

    Popup Calendar for Access download
    www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-and-above_topic597.html

     

  • User profile image
    strive4peace

    (free tools and resources from the presentation, continued) 

    crystal's library on Rogers Access Library:
    www.rogersaccesslibrary.com/forum/long-crystal_forum71.html

    Analyzer for Microsoft Access download
    http://analyzer.codeplex.com/

    The Analyzer for Microsoft Access is an essential tool for every Access developer, and anyone who wants to have a better understanding of what is in their Access database.  It is open source and everything it collects is exposed.

    Code Documenter for Access, Excel, Word, and PowerPoint download
    AccessMVP.com/strive4peace/CodeDocumenter.htm

  • User profile image
    strive4peace

    (free tools and resources from the presentation, continued) 

    Debugging VBA:
    bytes.com/topic/access/insights/648856-debugging-vba

    Log Code and Property References download
    bytes.com/topic/access/insights/957647-log-code-property-references

    Open Database Bypass Startup Code using VBA
    YouTube.com/watch?v=othsyC4iRb0


  • User profile image
    strive4peace

    (free tools and resources from the presentation, continued) 

    Database Analyser
    bytes.com/topic/access/insights/945024-database-analyser

    Invoking a Database From the Command Line
    bytes.com/topic/access/insights/873647-invoking-database-command-line

    Log Code and Property References
    bytes.com/topic/access/insights/957647-log-code-property-references

     

  • User profile image
    strive4peace

    (free tools and resources from the presentation, continued) 

    Control External Processes using Scripts - FTP
    bytes.com/topic/access/insights/966046-control-external-processes-using-scripts-ftp

    Adrian's Profile on Bytes
    bytes.com/profile/51203/neopa/

    Have a suggestion to improve Access?
    http://access.uservoice.com/

     

  • User profile image
    strive4peace

    (free tools and resources from the presentation, continued) 

    YouTube channels with video tutorials:

    mostly Access -- some about other Office products such as Excel, Word, and PowerPoint
    www.youtube.com/user/LearnAccessByCrystal

    Windows and Windows Phone development:
    www.youtube.com/user/LearnByCrystal

    Access development:
    www.youtube.com/channel/UCOaLVmvtYcv6PHM08IzqlvQ

  • User profile image
    strive4peace

    (free tools and resources from the presentation, continued) 

    Access Forum on Bytes.com
    bytes.com/topic/access/
     
    Tips and Tools by MS Access Gurus:
    msAccessGurus.com/freetips.html

    There are several extremely useful downloads linked on this page.

  • User profile image
    Bhavneet

    Excellent talk Crystal!

    For more Microsoft Access by Crystal Long, check out her online course at https://www.goskills.com/Course/Access-Basics.

  • User profile image
    Bhavneet

    Excellent talk Crystal!

    For more Microsoft Access by Crystal Long, check out her online course at www.goskills.com/Course/Access-Basics.

  • User profile image
    Jan Karel Pieterse

    I have a free tool to backup the backend of an Access front-end/backend system: http://www.jkp-ads.com/accessdownloads.asp

  • User profile image
    Ken Puls

    I have a collection of articles for Access/Excel programming the can be found at http://www.excelguru.ca/list.php?category/68-Access-VBA-Programming

    The main focus of these articles is how to use VBA and SQL to pull data from Access into Excel and push Excel Data into Acces.

  • User profile image
    strive4peace

    thank you for commenting, Bhav.  

    I spent many months last year making a 40-lesson course on developing an Access database application from the ground up (Bhav and Cecilia kept me inspired).  That course is posted on GoSkills.  Three (3) of the lessons are free -- look for the "Try it!" message.  Currently, they are:

    Welcome to Access
    What is Access? How can Access help you? Main Object Types

    Perspective on Access Objects
    Overview of the Access objects covered so far. The main object types are Tables, Queries, Forms, Reports, Macros, and Modules.

    Page Breaks and Page Setup
    Identify Page Setup options and learn how to force a new page between sections of a second grouping using a few lines of VBA.

    GoSkills has video tutorials in many topics and focuses on Microsoft Office. Three lessons in each course are free.


  • User profile image
    strive4peace

    Jan Karel, I did not realize you had such a useful tool for Access!  Excel could benefit from this too since Access databases are a great way for Excel users to share data ~ and maybe that is why you first wrote it? 

    I have used your very helpful page on API declarations:

    http://www.jkp-ads.com/articles/apideclarations.asp

    and downloaded your Treeview tool:
    www.jkp-ads.com/Articles/treeview.asp

    thanks for sharing, jkp ~

    ~~~

    Ken, thank you for sharing your link.  Ken Puls also has video tutorials on GoSkills.  He is an expert with Excel and a great speaker and teacher.

     

  • User profile image
    strive4peace

    Ken, I took a look at your topics on
    www.excelguru.ca/list.php?category/68-Access-VBA-Programming

    now that I see your page, I also see that I have looked up your Outlook email integration code before (and Ron's too) -- thanks!  I did not know, however, that you have code to work with PDFCreator ... plan to explore that ... and some of your other cool tools and articles

    ~~~

    also on Channel 9 about Access:
    Microsoft MVP Virtual Conference 2015 -- Access Web Apps, Bing Maps, linking to SQL Azure from Access desktop, Excel workbook, and SSMS
    with Julian Kirkness, Brent Spaulding, and Pat Wood
    channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps

  • User profile image
    strive4peace

    to post a link to open in a New Window on Channel 9:

    after you paste the link, while you are writing your message:

    1. highlight the link in your message and COPY to the clipboard (ie: Ctrl-C)
    2. select the link icon on the message tools -- Dialog Box opens
       (chain icon to Insert/edit link)
    3. PASTE copied link into URL (ie: Ctrl-V)
    4. edit Display text, if desired
    5. choose to open in --> New Window

    if you post a comment without signing in, your links won't be hyperlinks

    if you have too many links in your message, you will get a message that it is spam. Edit and write multiple comments to get all the links in.

  • User profile image
    Roger​JCarlson

    Roger's Access Library is a collection nearly 500 small sample databases, created by myself and other professional developers including MVPs.  Each sample is designed to solve an individual problem, with only those objects and code needed to solve it.

    Roger's Download Samples

  • User profile image
    Roger​JCarlson

    Roger's Access Blog is a collection of over 200 articles on Access topics ranging from Access Basics to Database Design to Queries to Reports to VBA/Programming and more. 

    Main blog: Roger's Access Blog

     

  • User profile image
    argeedblu

    I have a YouTube video illustrating creating relationships in the relationship window https://www.youtube.com/watch?v=QR13gvthia0

  • User profile image
    hunterpaw

    All of Crystal's free tools are top quality. I have used Crystal's Analyzer on several databases.  It provides a wealth of information so quickly! Other tools can take a very long time to gather the data but the Analyzer is the quickest I have ever seen. 
    I look forward to using Adrian's Log Code and Property References Database. It looks like it will be very helpful when improving on Access databases developed by others.

  • User profile image
    Tom van Stiphou

    Great session Adrian and Crystal. Every Access developer needs those tools and more.

    As an example here is a replacement for the standard Shift+F2 zoombox, and it takes only a minute or two to add to your project by simply importing one form, module, and macro: http://accessmvp.com/TomVanStiphout/ZoomBox.htm

  • User profile image
    dat​Adrenaline

    Always good to listen to the presentations, good presentation.  I have a couple utilities that I want to add to the list:

    Who's Connected / Who's Logged On: This utility allows you to point to an Access database and then provides you with a list of who is connected to that file.  The utility will indicate the computer attached to the file, plus if you have the correct permissions, the remotely logged on user!  In addition you can set or unset the "Passive Shutdown" property, which can be extremely useful! You can read more about the utility, as well as download it, on UtterAccess:

    http://www.utteraccess.com/forum/index.php?showtopic=1897146

    Search For Text: This little gem of a utility is something I wrote back in the Access 97 days and I won't develop a database without even today!  What the utility does is pretty simple: It will tell you all the objects and properties a string pattern exists, and with some object types (Forms, Reports and Queries) you can do an "Edit and Continue" to change a property with the searched pattern.  There are a few paid apps out there that to similar tasks, but this one is all Access (its a single form that you import into your db), plus its free!

    http://www.utteraccess.com/forum/index.php?showtopic=1992076

    If any questions arise, please get let me know.

  • User profile image
    Argyronet

    Package Solution Wizard

    With no doubts, as you certainly know, in MSAccess 2013, the Package Solution Wizard has been removed.
    The Package Solution Wizard allowed you to package an MSAccess desktop database file along with Access Runtime and to distribute the files to others.

    It is the reason why I decided to develop a new Wizard for this version.

    You can download them from the links (at the bottom of the page) :

    http://argyronet.developpez.com/office/access/runtime/2013/

    You must subscribe an account to download.

    I'm sorry, the tutorials are written in french because the forum is french and I'm french myself and I live over there.

    But, the both tools have the both language US/FR.

    I didn't found sufficient time to translate the tutorials in English.

    If any questions arise, please get let me know.

  • User profile image
    Argyronet

    Package Solution Wizard

    Same as MSAccess 2013, MSAccess 2016 has also its Package Solution Wizard removed.
    The Package Solution Wizard allowed you to package an MSAccess desktop database file along with Access Runtime and to distribute the files to others.

    It is the reason why I decided to develop a new Wizard for this version.

    You can download them from the links (at the bottom of the page) :

    http://argyronet.developpez.com/office/access/runtime/2016/

    You must subscribe an account to download.

    I'm sorry, the tutorials are written in french because the forum is french and I'm french myself and I live over there.

    But, the both tools have the both language US/FR.

    I didn't found sufficient time to translate the tutorials in English.

    If any questions arise, please get let me know.

  • User profile image
    AlexDybenko

     More useful tools for Access, as well as tips and code sample, you can find on my blog http://accessblog.net

  • User profile image
    AccessWisdom

    @strive4peace:Great work Crystal and Adrian!

    I have a few links people may be interested in, as well.

    We have more than a dozen free videos about Access Web Apps from our AWA Users Group:  http://accessusergroups.org/access-web-apps/meeting-recordings/

    There is a list of other Access User Groups you can join here:  http://www.worksmartdb.com/free-groups/

    I have a free book about 18 projects you can do with Microsoft Access.  This was updated for Access 2013.  http://www.worksmartdb.com/free-book/

    - Andy Tabisz

     

  • User profile image
    TomUrtis

    Hi, Crystal and Adrian, thanks for this informative video.

    Access being an Office application, here's a way to export an Excel spreadsheet into an Access database table, using a VBA macro that resides in and is executed from Excel.

    Suppose you have an Access database named Database1.accdb that contains a table named Table1 with 8 fields. In Sheet2 of your Excel workbook, you amass records during the day that are added to Table1 at the end of the workday. To automate the daily task of transferring the day's records from Excel to Access, you would maintain the Excel table with the fields in the same order as they are found in Table1 of the Access database, as shown in this link:

    http://www.atlaspm.com/toms-tutorials-for-excel/toms-tutorials-for-excel-export-excel-spreadsheet-into-access-database-table/

  • User profile image
    TomUrtis

    Hi again --

    Was thinking that the viewers of your video may appreciate how Access can be controlled from Excel using VBA. For example, a quick way to delete an Access table from Excel is at this link: http://www.atlaspm.com/excel/access/.

  • User profile image
    wrmosca

    Hi all

    Nice job, Crystal and Adrian!

    I have a few free tools at my website http://www.thatlldoit.com/Pages/utilsaddins.aspx Please drop by and poke around in my site. In addition to free tools I have code samples and How-To's for the more serious users.

    ***Utilities***
    ** Properties Setter - My most popular utility by far. This tool lets you connect to an Access ACCDB, ACCDE, MDB, MDE or MDA and see the database settings, startup form and whether or not it has an AutoExec Macro. Think of it as a Startup wizard.

    You can change the settings using the Properties Setter without opening the target file. Did you set the database to disallow the Bypass Key? You can reset it. Need to change any of the other database settings? Just check the boxes you want changed. And click the Engage button.

    ***Add-ins***
    ** Show User Roster - This is an Access Add-in that is meant to be used in the back end of a split database that utilizes Access User Level Security (ULS). It can display a list of all current users in the database, telling you which ones are suspect (may have not exited properly and hung the LDB file).
    ShowUsers has the functionality to let you block any new users from opening the database, and there is a built-in messaging feature that asks logged in users to log out.

    ** Table Restorer - Ever accidentally delete a table? ACK! I hope you have a backup. Nah, you don't need a backup. You can restore the table with this add-in.
    As long as you don't delete another object and you don't compact or close the file, you just open TableRestorer from your Add-ins list and click a button.

    ** One of the things that has a always bothered me is the fact that Microsoft did not include a way to do bulk object exports. You can only do one object at a time. Sometimes you can do a work-around by importing the objects into another database, but this is not possible if you want to get objects from a workgroup-protected database into an unprotected database.
    ExportAll is an add-in that does just what its name says. It lets you export multiple objects at one time. The only thing I haven't figured out yet is how to carry the relationships along with it. But, hey, with all the time this will save you, you can rebuild the relationships and still be ahead of the game.

  • User profile image
    Kent

    If you want to be a professional Developer then you will need to understand the Development Lifecyle and how to manage it. You will also need to give your clients a good reason to have you develop an application for them that THEY OWN, using Access.

    www.osel.solutions has articles on these and other concepts on design principles that every professional Access Developer should understand.

  • User profile image
    theDBguy

    Thanks to Crystal and Adrian for starting this topic. Since we are in a sharing mood, I would like to offer the very first demo I created, which can be downloaded at http://www.accessmvp.com/thedbguy/demos/fillablepdf.asp

    When I created this demo, I couldn't find any resources for filling in a fillable PDF form with data from an Access table. I hope some of you may find it useful.

  • User profile image
    AdrianBell​MVP

    Thank you to all for the comments, feedback and resources.  Some wonderful stuff here.

    To ensure I don't get left behind I'll just post links to a couple of new articles I've posted on Bytes.com that explain how to control external processes (using scripts) from within MS Access, making use of a table to store the basic template of the script.  I hope people find them useful.  I gave a presentation very recently for the UK Access Users Group which seemed to go down well.

    The two links are (One has a link within it to a new YouTube video for anyone interested) :
    Control External Processes using Scripts - FTP
    Control External Processes using Scripts - CMD

    I hope, like many of you here I suspect, that this thread can help to increase the interest we all have in Microsoft's wonderful tool - Access.

    -Ade.

  • User profile image
    hunterpaw

    Thank you Crystal and Adrian!

    You can find more free tools and help from Crystal at this page The Free Access Web App Reference from Access MVP Crystal Long

    You can find hundreds of links plus free downloads at my Microsoft Access and SQL Azure Information Center for Developers

  • User profile image
    excelisfun

    Thanks for the fun with Access!

  • User profile image
    strive4peace

    As Adrian, I see some wonderful stuff in this wealth of links -- thanks for commenting and sharing, Roger, Glenn, Gina, Pat, Tom, Brent, Jean-Phillipe, Alex, Andy, Tom, Bill, Kent, DBguy, and Mike

    ~~~

    It is good for Access developers to learn Excel too. Tom Urtis, Ken Puls, and Jan Karel Pieterse have great resources for Excel. Roger's Access Library also has code for Excel and automation.

    ExcelisFun (Mike Girvin) has a channel on YouTube for learning Excel with thousands of free videos, indexed in the video description to quickly jump to times, and workbooks.
    www.youtube.com/ExcelisFun

    Another channel on YouTube with lots of Excel videos is Bill "MrExcel" Jelen:
    www.youtube.com/bjele123

    ~~~
    Adrian's new video about controlling external processes using Access and VBA to run a dynamic FTP script is on YouTube here:
    https://www.youtube.com/watch?v=fMWWcoXnzHc

    ~ crystal

  • User profile image
    strive4peace

    awesome, thanks, Wayne! Peter Doering recommended EverythingAccess.com as a good resource* as "Wayne Phillips' site, inventor of vbWatchDog and the only guy who ever re-engineered an mde/accde."

    *and indeed it is! I just love, love your file property information tool!!! I use it a lot and recently found another interesting property -- Content Created is the original creation date of a file even if it has moved and gotten new dates in the popular columns.

    http://www.everythingaccess.com/tutorials.asp?ID=Accessing-detailed-file-information-provided-by-the-Operating-System

    I'll check out rubberduck too ~

    Peter also suggested these German sites as good resources:

    - Karl's Access-FAQ on www.donkarl.com

    and particularly this one since it mentions other links:
    www.donkarl.com/?FAQ9.2

    - Gunter's ribbon site www.accessribbon.de (you may know www.accessribbon.com)

    He said that especially Gunter's site is full of samples. 

    ~~~

    Another fantastic resource for Access is Allen Browne's site. Allen's site provides essential information to become a great developer.  I look reserved words up a lot there too:
    http://allenbrowne.com/tips.html

    Allen's site was a rock for me when I really got into the nuts and bolts of developing with Access.  Reading his pages give you a solid foundation for how Access works.  He has lots of code samples that impart understanding and make light bulbs come on.

    ~~~

    for Access samples with magic and the 'impossible': here is Stephan Lebans' table of contents: http://lebans.com/toc.htm

  • User profile image
    strive4peace

    on Access links ... thank you, thank you ~

    In addition to Roger's own immense collection, Roger's Access Library is a haven for many other great developers such as A.D. Tejpal, who has nearly a couple hundred samples for Access that are indexed here:

    http://www.rogersaccesslibrary.com/forum/samples-by-adtejpal-alphabetical-index_topic405.html

    AD has prolific contributions on MS Access Professionals, a yahoo technical group started by Bill Mosca for questions about Access that is free for anyone to join here:
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Glenn teaches Access and other Office applications.  In addition to the video mentioned, Glenn has a blog here:
    http://argeedblu.blogspot.com/

    Gina has a great collection of links, tips, and her site is very nice to look at too ~

    Pat is far too humble.  His site is a great resource for using Azure -- reference information, tips, and code for getting around some of the issues.

    Tom van Stiphout has a better zoom box and more if you explore the other links ... including his implementation of Simil (fuzzy string matching), which uses a DLL called by VBA, includes all source code, and a video explanation referenced here:
    http://accessmvp.com/TomVanStiphout/Simil.htm

    Brent only listed a couple of his many great tools. I have used Brent's code to manipulate and get information about arrays, date/time ranges, queries and other objects, ... down to nuts and bolts with bitwise math, connecting to data in other formats such as text files, and linking to data in other places using DSN files.

    Jean-Phillippe's tools are currently in French ... valuable information since the Package Solution Wizard is gone ... and logic is logic, right?  Here is the Bing Translation site where you can paste a URL, or phrase, and everything can be translated to English or another language:   https://www.bing.com/translator

    Thomas Moeller has an awesome site for Access.  It is in German, but he provides the Microsoft Translator tool in the upper right so it is easy to switch any of his pages to English. Keep meaning to see how he does that ....
    http://team-moeller.de/

     

  • User profile image
    strive4peace

    Alex shares his vast knowledge about Access, SQL Server, and more on his brilliant blog packed with tips and valuable information.

    Thanks, Andy! I sent for your free book.  Andy Tabisz and Juan Soto will be on MVP Tech Talk about Access, so watch for them.

    Tom Urtis, so glad you posted. Great links. Your blog has many interesting articles that I would love to learn about ...  I need a vacation just so I can catch up on reading ~

    Bill, thank you.  Your Properties Setter is indeed, a tool that no developer should be without.  You have so many good tools ~ and even more for those on MS Access Professionals ... and what would a page written by you be without slipping in some humor somewhere?

    Because "there's more to life than a keyboard", some such as Bill and Roger, also post creative musings ...

    Kent, thanks for sharing.  In addition to being very wise in business, Kent has some amazing tools ... did I miss a download section, for, like, your great query editor?

    theDBguy has several good resources listed on the home page of the link he gave for the Fillable PDF Forms Demo.
    http://www.accessmvp.com/thedbguy/

    He is one of several Access MVPs with resources to share listed on the page set up by Arvin Meyer here:  http://www.AccessMVP.com

    Adrian, thanks; Well said. It was great doing the show with you. 

    Pat, so glad you posted links; you have such a wonderful site and great compilation of knowledge for Azure.

    Mike "ExcelisFun" Girvin ~ you know I couldn't let this go by without a link to your amazing resources ...

    Wayne, thanks for sharing  ~ your contributions are colossal.

    ~~~

     some of my favorite links, to start from, on MSDN are:

    Object model (Access VBA reference)
    https://msdn.microsoft.com/en-us/library/office/ff192120.aspx

    Visual Basic language reference
    https://msdn.microsoft.com/en-us/library/office/jj692818.aspx

    Object model (Excel VBA reference)
    https://msdn.microsoft.com/EN-US/library/office/ff194068.aspx

    Word VBA Reference
    https://msdn.microsoft.com/en-us/library/office/ee861527.aspx

     

    ~crystal

  • User profile image
    AdrianBell​MVP

    If I were to thank everyone as Crystal has, I'd be here all day, and all the readers would too.  I'm glad Crystal got that one.  She knows more of you than I do.

    I have to say that I'm excited to start learning and playing with Wayne's vbWatchdog soon.  I simply don't use such tools in my everyday work due to my desire to have all my familiar environment around me wherever I go.  Unfortunately for that approach, I've had my ear bent so many times about how great and easy it is, that I can put it off no longer.  That's every time I do a talk or meet up with other MVPs - vbWatchdog, vbWatchdog.

    That said, there are so many great resources and I'm so grateful you all chose to post links in here.  This may come to be the go-to place for free Access material.  That would be so great.

    Stay well -Ade.

  • User profile image
    wrmosca

    @RogerJCarlson:  I've been using and referring others to your pages for years. Especially AD Tejpal's samples. Thanks for keeping it going all this time.

    Bill Mosca

  • User profile image
    Thomas​Moeller

    If you want to check the Quality of your VBA-Code the TM VBA-Inspector is a good startingpoint:
    http://www.team-moeller.de/en/?Add-Ins:TM_VBA-Inspector

    Enjoy!

  • User profile image
    davidjpp

    I have documented how to link Visio to Access Web Databases at https://blog.bvisual.net/2015/09/16/linking-an-access-web-database-to-visio/

     

    And how to create a schema from External Data Recordsets at https://blog.bvisual.net/2014/03/26/creating-a-schema-from-visio-external-data-record-sets/

    David Parker, MVP (Visio)

  • User profile image
    Jack

    Wonderful talk Crystal and Adrian!!! The Contact List looks terrific Crystal. Almost makes me want to get back to writing Access Databases...

    Jack

  • User profile image
    Adnan Mehmood

    Very informative talk Crystal Long. Got alot of information. Keep it up.

  • User profile image
    GeoffreyG

    Great Video Crystal and Adrian!  Nice Contacts Application Crystal!  

  • User profile image
    Bill Jelen

    For Access assistance, check out the Access forum at MrExcel.com: http://www.mrexcel.com/forum/microsoft-access/

  • User profile image
    strive4peace

    Adrian, thank you.  Yes, there are certainly a lot of great links here! ... and perhaps it is time to start thinking about another video?

    Bill Mosca, I am so glad you mentioned AD Tejpal's great collection too.  RogersAccessLibrary has so much from many developers.  I have a library page there as well. Roger deserves a big pat on the back for setting it up and keeping it going all these years ... as do you for MS_Access_Professionals, which is a free forum to ask questions and get answers about developing with Microsoft Access.

    Thomas, thanks for pointing out TM VBA-Inspector, which is an amazing free tool to gain a quick overview of potential errors.  This is invaluable to new developers, and even experienced developers ... especially when you take over a project done by someone else ... and it can help you find and fix your own common bad habits.

    David, glad you jumped in. Visio is a useful tool to know and many Access developers need to learn how to take advantage of it.  Thanks for the great links

    Jack Cowley, it is an honor and heartwarming to be on a thread with you again ... however,  you forgot to mention anything about wine ... perhaps that delicious Sauvignon Blanc you told me about recently? Thanks for the fish.

    Adnan, thank you ~ happy to be helpful

    Geoff Griffith, thanks.  I see your main page on www.ImagineThought.org is under construction ... perhaps it may have a section with articles and resources in the future? Geoff used to be on the Access team, and then was an MVP for Microsoft Access.  He has great knowledge about Access, SQL Server, Visual Studio, Windows, and much more -- and has written books on Access you can find in stores and online.  

    Bill Jelen (aka MrExcel), thanks for mentioning the free Access forum on MrExcel.  This is also a fantastic place to ask Excel ! and other Office questions too ~

    MrExcel.com/forum

    ~~~

    note:

    you can post a comment without signing in -- however if you want links to be hyperlinks, you should post using a Channel 9 account, which is free ~

    Comments are only open for 30 days. The window to say something is closing ~

     ~ crystal

     . . . (: have an awesome day ~

  • User profile image
    Roger​JCarlson

    I've got a new blog post about Office Automation integrating Word and Excel

    Automating Microsoft Word and Excel from Access

     

  • User profile image
    Roger​JCarlson

    And another new blog post about Excel Charting from Access

    Easy Excel Charting from Access

  • User profile image
    Roger​JCarlson

    And lastly, a new blog series explaining methods of exporting data from Access to Excel from simple manual methods to Office Automation.

    How do I export Access data to Excel - Part 1

    How do I export Access data to Excel - Part 2
    How do I export Access data to Excel - Part 3
     
  • User profile image
    Graham​Mandeno

    Thank you, Crystal and Ade!  This is a great talk - very informative and also entertaining.

    Also, it's great to see such a useful collection of resource links in one place.  One that I don't see, which also links to many others, is Tony Toews' Access Page at
    http://www.granite.ab.ca/accsmstr.htm

    Keep up the good work - you are truly "Most Valuable"!

  • User profile image
    Duane Hookom

    Great information Crystal and Adrian. I've got some free samples primarily at www.access.hookom.net. Other samples are hosted by Roger Carlson at www.rogersaccesslibrary.com.

  • User profile image
    zmbd

    Often we see references to the filesystem object when needing to work with simple text files; however, there is a set of standard functions in VBA for file control are the often quite difficult to find any information for, for example, the basic File operation commands, such as DIR(), CHDRIVE(), CHDIR(), FILECOPY(), NAME(), KILL(), and commands to handle the basic text input/output.

    Using these types of commands along with the string functions can provide a very valuable set of tools without the need to add any library references or late binding object to use the file scripting object.

    You can archive materials, save settings, offline error logs, and I’m sure that many of us have had the need to import text from a TXT/CSV file and do not want to deal with opening an ADODB or DAO recordset for a single file or two (or creating scehema.ini for a ton of text files (!)).

    I have a short article posted at Bytes.com ( [url]https://bytes.com/topic/access/insights/953655-vba-standard-text-file- i-o-statements[/url] ) covering many of these command, with each of the statements hyperlinked to the Microsoft Programmer's Reference site for more detail...

  • User profile image
    JennyD

    Fantastic presentation, Crystal and Adrian! Thank you.  I've used free tools from both of you in the Microsoft Access special interest group I lead at the Philadelphia Area Computer Society.  Next season, in response to a request from a couple of people, I will probably be starting a new group for Access beginners.  This presentation will be a good one to present at some point.

    For my more advanced group I developed a free web app and a YouTube video about adding images to web apps.  Here's the link to the video: Holiday Tutorial by Jenny, Add Image to Access Web App (cc) .  Hope it is helpful to someone.

  • User profile image
    Mary McCarthy

    Hi Adrian and Crystal

    Great Presentation!

    I love the work you've both put in on all those tools. One of these days I will have to take the time to properly analyse all of them instead of just calling Adrian when I need help with something :)

    Seriously I will definitely use the analyser and the log tools on my next Access project. Although so many of my projects these days are in Excel I'm not sure when that will be.

    Congratulations again on a very helpful presentation. Looking forward to the next one.

    Mary

  • User profile image
    Argyronet

    Package Solution Wizard 2013 and 2016

    I've already posted comments concerning the Package Solution Wizard for Access 2013 and 2016 where the tool was removed in the both version.


    You can download the wizard tool from the links (at the bottom of the tutorial page) I've mentionned in the comments above (May 11, 2016 at 1:25PM and May 11, 2016 at 1:34PM)

    (replace 2013 by 2016 in the web link to acceed to the same tool for MSAccess 2016)

    You must subscribe an account on the forum to download.
    This a french forum but the popups are simple to populate.

    The problem was that both tutorials are written in French and I wasn't able to translate them because of lake of time...

    Fortunately, Crytal sent me a link to translate in live the tutorial...
    I wanted to thank Thomas (he is the one who told me about the widget and where to find it) and you can download the Microsoft Translator tool here :

    http://www.bing.com/widget/translator


    If any questions arise, please get let me know.

  • User profile image
    AdrianBell​MVP

    Thank you to all who've posted since I last did.

    Great to hear from you all.

    As Graham Mandeno said it's great to have so many wonderful resources all linked from this thread.  That gives it far more value than it started with.  I'm happy with the presentation, but never could it match up to everything that's been added since.

    I'll just add some of the links to free resources that came in posted as text in case anyone's missed them :
    Jan Karel Pieterse - Downloads for Microsoft Access
    Kent Gorrell - Osel Solutions
    Leo the DBGuy - Fillable PDF Forms
    Wayne Phillips - Accessing detailed file information provided by the Operating System
    - Tutorials for Microsoft® Access
    Bill Jelen (Mr Excel) - Microsoft Access Forum
    Duane Hookom - Hook'D on Access
    Zmbd - VBA Standard Text File I/O Statements

    I suspect many of these will prove helpful to a lot of people.

    Thank you all again :)

Add Your 2 Cents