Announcement

Collapse
No announcement yet.

Reporting

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Reporting

    When I open a domain, click on an object in left column, Go to Tools, Run Report: received Visual Basic error box, Compile Error, Can't find project or library. Not just this workstation, all others. Using Hyena on a NT4 Terminal Server. Hyena4.3, Access 2002. This function has been working.

  • #2
    Re: Reporting

    If the code stops (after you go into Debug) on the first line in the module, then its probably due to Access not being installed with all of the options. Try uninstalling and reinstalling Access on one of the computers and select all of the installation options. Access uses Visual Basic for Applications as its "engine" and it sounds like that is not installed.
    Kevin Stanush
    SystemTools Software Inc.

    Comment


    • #3
      Re: Reporting

      <div class="ubbcode-block"><div class="ubbcode-header">Quote:</div><div class="ubbcode-body">Originally posted by ssharp:
      <span style="font-weight: bold">When I open a domain, click on an object in left column, Go to Tools, Run Report: received Visual Basic error box, Compile Error, Can't find project or library. Not just this workstation, all others. Using Hyena on a NT4 Terminal Server. Hyena4.3, Access 2002. This function has been working. </span></div></div>


      Using Hyena on Terminal Server, NT4. Reinstalled Access 2002. Tried to run a report of users and received same result as above.

      Comment


      • #4
        Re: Reporting

        Go to Tools->Settings->Reporting and make sure the Path to Hyenarpt.mdb report database is pointing to your Hyena directory. For example, if you installed Hyena in the default location it would be:

        c:\program files\hyena

        Let us know if this helps.

        Comment


        • #5
          Re: Reporting

          Sorry for delay. Path to Hyena DB is C:\Program Files\Hyena. Access is installed on E drive. Report halts in Function Run report at CMD=command.

          Comment


          • #6
            Re: Reporting

            Send a screen of the actual error message that you first see when you run a report to [email protected] and we'll see if we can offer a solution for this.

            Comment


            • #7
              Re: Reporting

              <div class="ubbcode-block"><div class="ubbcode-header">Quote:</div><div class="ubbcode-body">Originally posted by cmccullough:
              <span style="font-weight: bold">Send a screen of the actual error message that you first see when you run a report to [email protected] and we'll see if we can offer a solution for this.</span></div></div>
              I also have exactly the same problem. It seems that the cmd = command line in the Access code module is not being processed.I've been throuhg the .dll checks etc etc. Environment is WinXP & Office XP

              Help, please!!

              Comment


              • #8
                Re: Reporting

                Access is missing the VBA component, which gives it the ability to run Visual Basic code, which is what you are seeing when it stops on that error.

                I would try the Access install again choosing Custom, and look at all options for anything related to VBA and text import.

                Unfortunately we don't have any additional information on this as it is an Access issue. You may have to do an uninstall of Office, and then install again, to get to the point where you can select the additional options.

                Comment

                Working...
                X