Results 1 to 7 of 7
  1. #1
    Join Date
    May 2002
    Posts
    46

    Unanswered: Date() ref on report not working in 2002 runtime

    I am using the Date() function on a report in my database. Everything works fine when I preview the report from my full version of Access 2002. However, when I view the report in the runtime environment on a separate machine, #Name? appears.

    Could there be a missing library somewhere in the runtime environment?

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    Set the date in code and see if this fixes your problem.

    Did you run testing in your development environment using runtime?

  3. #3
    Join Date
    May 2002
    Posts
    46
    That did it - thanks for your help!

  4. #4
    Join Date
    Apr 2002
    Location
    Thailand
    Posts
    81
    I have a similar problem. When some people start my mdb on their computers the Date-fuctions wont work. Making most of the reports useless. To fix this - missing references must be fixed on their computers. But tis a quite complicated procedure for a normal user which is complicating the distribution for me.

    What u mean set in code? I have date everywhere. In queries, on forms on reports.

    Is there any way of making the references set, the same for all in a runtime?

  5. #5
    Join Date
    Feb 2002
    Posts
    403
    Your question is different. The set in code applied to a specific problem with a report, and it is common to set the date in code to overcome this problem.

    Are you using developer to package your application?

  6. #6
    Join Date
    Apr 2002
    Location
    Thailand
    Posts
    81
    So far I have just been dishing out the mdb file to other people in the company. Its not ready yet. But later on I was thinking about using developer to make a runtime. Especially if it can help me prevent problems when installing the database on other computers. Want to be able to send a CD to the people who are going to use it.

    Jo´

  7. #7
    Join Date
    Feb 2002
    Posts
    403
    Developer will allow you to set the references and distribute the references with the database. However, it is not 100% reliable.

    In the interim, I wondered about an MDE file, if you set the references in that it might do the trick?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •