Pending release of CONTACTfile version 5

At last, the long-awaited version 5 is nearly ready for you!  This new version has a completely different contact-manager interface, which is more intuitive to use, and which will eventually replace some of the forms you’ve got to know and love.  Also the WHOLE LOT of code has been re-written, to smooth out the places where it’s been a bit cumbersome, and to make it all a bit more consistent.   

Creating a new table in an external database using code

I often wondered how to do this - especially if you needed a new table with an Autonumber ID!  This is how I did it. (For some reason the line breaks refuse to display, and I’ve put in double breaks to be sure - I hope you can make it all out! Read the rest of this entry »

Viewing an Excel file from Access database

This is a useful little subroutine, as it opens a file (given as a parameter) into Excel, and displays it, without having to have the Excel reference set.  However, do make sure that the Microsoft DAO 3.6 Object Library is set.  It works with Access 2000 and later.

Sub OpenExcelFile(ExcelFileName) 
Dim xlApp as Object
Dim xlWorkBook as Object
Set xlApp = CreateObject(”Excel.Application”)
Set xlWorkbook = xlApp.Workbooks.Open(ExcelFileName)
xlApp.DisplayAlerts = False
xlApp.visible = True
End Sub

MS Access VBA Developer Code

Just to announce that I intend to use this space to put any interesting VB code I come across or use.  If anyone would like to contribute, then please do!

Office 2010

All clients please note that CONTACTfile now has Office 2010 compatibility. 

NEW and FREE

CM Databases have just published their completely new product - FREE to anyone who wants it.  It’s a simple program called TimeKeeper, and it’s for use at presentations or similar, where you need a coundown display.  Goto www.cmdatabases.co.uk/timekeeper.htm for further details and free download.

FREE offer for clubs, societies, and not-for-profit organisations

Most of you will, by now, know of our offer that’s running from August 2010 to October 2010.  It’s a three month offer.  It’s NOT- as some people have wondered, an offer that allows you to use CONTACTfile Club free for only three months!  So long as you recommend the product to two others, you can have it FREE FOREVER!  See www.contactfile.co.uk/offer.

CONTACTfile 4.4

Just to say that I love the way you can now limit what my staff can see on the database.  Now that certain staff can only see their own sales progression, it makes life much easier for me.  Thank you!

Security issues

I am just wondering about security issues.  We currently use CONTACTfile on a network, and would like some of the functionality limited so that only one appointed person can make changes - namely, the listing of categories, person types, and contact group names.  Is this possible please?

The who-did-what routine

Thank you for your reply to the who-bought-what question.  I have updated, and I see that you have a Tracker routine too.  This is very useful.  So thanks are due once again.