Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JackSapsford

  1. JackSapsford

    Microsoft Access 2000 - Function Is Not Available...

    Hi Combo, The templates are valid and working for other people. As for creating word again, I'm not sure why that is there, this is code that I have inherrited from the last guy who created it. I'm also not at all familiar with VBA. Thanks, Jack
  2. JackSapsford

    Microsoft Access 2000 - Function Is Not Available...

    Hi All, So I managed to solve that error by recompiling the MDE on a diferent PC. The issue I now have is that this SQL query was part of building a word document however I now have some users who can't create word documents, it doesn't error it just doesn't open word at all that I can see, see...
  3. JackSapsford

    Microsoft Access 2000 - Function Is Not Available...

    Hi All, This is the full sql query at the moment: "INSERT INTO tbl_CORRESPONDENCE ( TO, FULL_ADDRESS, DEAR, CONTACT, FAX_NO, [JOB NUMBER], JOBTITLE) SELECT IIf([CONTACT MASTER],'',IIf(IsNull([CONTACT TITLE]),'',[CONTACT TITLE] & ' ') & IIf(IsNull([CONTACT INITIALS]),'',[CONTACT INITIALS] & '...
  4. JackSapsford

    Microsoft Access 2000 - Function Is Not Available...

    Thanks for the response Andrzejek, I'm afraid that was nothing but a Typo in me copying over the error message. I wish it were that simple!
  5. JackSapsford

    Microsoft Access 2000 - Function Is Not Available...

    Hi All, I am by no means an Access expert. I know very little infact. However I am getting pressure to look at an error message that about 20% of our users are getting. We have an Access database that was written in access 2000. This is still to this day mission critical. The issue I have is...
See more

Part and Inventory Search

Back
Top