Why does item_send function not work

[tekkyun]

As you can gather from subject title, I'm new to vbscript in outlook so I'm sure this question is simple!
A couple of days ago, I generated a form with function that opened access database when the user pressed the send button. The database then queries the outlook form data and updates a data table.
It was working fine, now for some reason the function doesn't work and the database isn't triggered. What might have changed to stop it working?

function as follows...
Function Item_Send()
set WshShell = CreateObject("WScript.Shell")
wshshell.Run """D:\Program Files\Microsoft Office\Office\msaccess.exe""H:\HolidayBooker\HolidayBookerData.MDB", 2, false

End Function

 

[tsuji]

[tt]wshshell.Run """D:\Program Files\Microsoft Office\Office\msaccess.exe""[highlight] [/highlight]H:\HolidayBooker\HolidayBookerData.MDB", 2, false[/tt]

 

[tekkyun]

Tsuji,
Not sure what you mean. I tried copying and pasting your code to replace mine, but it makes no difference.

 

[tsuji]

>Not sure what you mean
Would an argument be positing right by not separating with the executable by a space or more?

 

[tsuji]

[tt]...exe""[highlight] [/highlight]H:\Hol...[/tt]

 

[tekkyun]

Tsuji,
I've left space where you suggest. The function still doesn't run. Could there be another reason?

 

[tekkyun]

Sussed it. I was working on another instance of the form without the code in it!.....well I did say I was new to this!
Thanks for your help tsuji

 

[tsuji]

I'm so relieved!