Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: changing a datapath in access 2000

    i am trying to change a document path that has a # sign followed by a space. access 2000 will not recognise the characters after the # sign. i am trying to replace the space after the # sign with a \. i am attaching a screen shot of the table i am working with, thanks for the help.

    Last edited by idlewild70; 10-18-04 at 10:25.

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    access sees # as the beginning of a date, use chr(35) instead.

Posting Permissions

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