Recent content by amber17

Hi All, Just to let you know, I finally figured out what was causing the error,Steve your right the error messages are misleading. I begged the IT department to revert my outlook back to Outlook XP and this fixed the problem. I suspect it was due to me using Microsoft outlook Object Library 11...

Hi Tom, Yeah sorry it is just a typo should read : IIf([expr1]=7,Left([SMSC],4)+"0"+Mid([SMSC],5,1)). I think I need to find a away of my access 97 to recognize these functions. I modified the query and ran the following IIF([expr1]=7,Left([SMSC],4)), and got the same error so I don't think it...

Hi The Database compiles properly on everyone else's machine just not mine. As for the references thing I have done this already and the only reference that differs from my colleague is that I have Microsoft Outlook object Library 11.0 where as heres is version 10.

Hi, I am a novice on access so I apologize now if this is a stupid question. I have just has my PC reformatted and Access 97 reinstalled, however now I can no longer log into our work database. I get the following error: Run-time error '3075': Function isn't available in expressions in query...

Hi Alex and Jerry, I tried using the suggested late binding code and it has worked a treat, with some other minor modifications. Thanks for your help, greatly appreciated.

Hi, I apologize now if I am asking a silly question, but to say I'm new to access would be an understatement. I have a database that auto generates emails. The database sits on a server and is accessed by users using Microsoft outlook 10. We recently had a machine upgraded and the IT department...