Have you turned the macro security settings 'on'? 2007 has a default of
blocking the macro's created in earlier version. By 'setting' the macro's to
enabled they should work. You could also set the location to where the
database is located to the 'trusted' locations (under big Office button in
the ribbon - Access options - Trust Center - trust center settings).
hth

Signature
Maurice Ausum
> Hi Guys,
>
[quoted text clipped - 4 lines]
> Thanks
> Lez
Lez - 29 May 2007 20:42 GMT
Cheers thanks for that Maurice,
I am finding this a real struggle, just looking for familiar options and
settings is a pain. Hopefully the effort will be worth it
Regards
Lez
> Have you turned the macro security settings 'on'? 2007 has a default of
> blocking the macro's created in earlier version. By 'setting' the macro's
[quoted text clipped - 14 lines]
>> Thanks
>> Lez