04/01/2011 by CONTACTfileProgrammer.

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 »

Posted in Code | No Comments »

20/12/2010 by CONTACTfileProgrammer.

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

Posted in Code | No Comments »

15/12/2010 by CONTACTfileProgrammer.

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!

Posted in Code | No Comments »