Hey guys!

I have an Access 2003 database. In this database we input start dates for when a student starts with a certain course, and end dates. What I want to do ( to make my life so much easier ) is to write a Macro to automatically print that particular subject's Exam.

The Macros Option Access provides are not very helpful here. So, I decided to write the VBA code inside a module. The code I wrote was this :
Code:
Public Sub RunWordMacroOrSub()

'Check Tools/Reference Microsoft Word Object Library
'declare variables
Dim wdApp As Word.Application
Dim wdDoc As Word.Document

'Word application stuff
Set wdApp = New Word.Application
wdApp.Visible = False
Set wdDoc = wdApp.Documents.Open("Blah Blah Blah.doc")
wdDoc.PrintOut

'done
wdApp.Quit
Set wdDoc = Nothing
Set wdApp = Nothing

End Sub
Problem now is, How do I Run / execute this code from an Access Macro
I have tried the RunCode option like this :
Code:
Modules![Test1]!RunWordMacroOrSub
Nothing happens, not even an error.

Does anyone have any idea what I did wrong, or can anyone suggest a better way to print a Word document from Access

Any help would be greatly appreciated.

Hannes