INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Installing Runtime

Installed runtime application doesnt work on some machines by StuMunro
Posted: 13 Mar 02 (Edited 18 Mar 02)

I have had a problems with parts of my access app not working correctly on machines without access installed when distributing using the ODE setup wizard. This included #Name? appearing on some fields on my reports.

The cause and solution was as follows.

I was planning on using MS Word to do a mail merge in a future version of my app and had some test code in a module and also had referenced the Word 8 Object library under Tools-References menu when viewing code.

The ODE setup wizard for distributing the application did not include the Word Object library automatically, assume because you would need word installed on target machine anyway.

When any code in the application is run Access appears to check the references each time and if any are missing then it doesnt run the code (or generates an error) even if it has nothing to do with the missing reference.

For the time being I removed the reference from my app and now it installs fine. I will have to add this reference to the setup wizard later even if the target machine will never have word installed, so my app will work without the mailmerge option.

Hope this helps someone as it took me a while to realize it was the word library causing the problem as I had checked all the other such as VBA and DAO, straight away. So check them all...


Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close