Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Report problem

Discussion in 'Information Technology' started by David M C, Jul 28, 2006.

Tags:
  1. David M C

    David M C
    Expand Collapse
    Guest

    I have a database app setup that works fine on one PC. I have copied it to
    another PC and the reports don't work. The problem is associated with
    controls that concatenate strings.

    Here is one example:

    =[CompanyName] & Chr(13) & Chr(10) & [Address]+Chr(13)+Chr(10) &
    [Address2]+Chr(13)+Chr(10) & [City]+Chr(13)+Chr(10) &
    [County]+Chr(13)+Chr(10) & [PostCode]

    This works fine on one PC, but comes up with the error "The function you
    entered cannot be used in this expression". One of my controls also uses the
    Mid function. Again, this works fine on one PC, but comes up with "#Name" on
    the preview, but no other errors.

    The DB is set up with Frontend/Backend. The Backend is on my server, the
    front end gets installed on each PC. I have the current version of DB on a
    network share. The users run a batch file to copy the latest version to their
    PC's. I have checked they are running the correct version. I have checked the
    version on the network share from my PC (it works fine). Each PC uses XP Pro
    and Office 2003 Pro.

    Any ideas what to check? I've checked the references and they all match.

    Dave
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    You most likely have a references problem. You can read about it and easily
    fix it:

    Allen Browne has this great information.

    http://allenbrowne.com/ser-38.html

    and Doug Steele has this:

    http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "David M C" <DavidMC@discussions.microsoft.com> wrote in message
    news:4D5E683B-B1CC-4A72-B91C-1BB687DE1BC3@microsoft.com...
    > I have a database app setup that works fine on one PC. I have copied it to
    > another PC and the reports don't work. The problem is associated with
    > controls that concatenate strings.
    >
    > Here is one example:
    >
    > =[CompanyName] & Chr(13) & Chr(10) & [Address]+Chr(13)+Chr(10) &
    > [Address2]+Chr(13)+Chr(10) & [City]+Chr(13)+Chr(10) &
    > [County]+Chr(13)+Chr(10) & [PostCode]
    >
    > This works fine on one PC, but comes up with the error "The function you
    > entered cannot be used in this expression". One of my controls also uses

    the
    > Mid function. Again, this works fine on one PC, but comes up with "#Name"

    on
    > the preview, but no other errors.
    >
    > The DB is set up with Frontend/Backend. The Backend is on my server, the
    > front end gets installed on each PC. I have the current version of DB on a
    > network share. The users run a batch file to copy the latest version to

    their
    > PC's. I have checked they are running the correct version. I have checked

    the
    > version on the network share from my PC (it works fine). Each PC uses XP

    Pro
    > and Office 2003 Pro.
    >
    > Any ideas what to check? I've checked the references and they all match.
    >
    > Dave
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Ooops, sorry. Doug Steele's site is now at:

    http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "David M C" <DavidMC@discussions.microsoft.com> wrote in message
    news:4D5E683B-B1CC-4A72-B91C-1BB687DE1BC3@microsoft.com...
    > I have a database app setup that works fine on one PC. I have copied it to
    > another PC and the reports don't work. The problem is associated with
    > controls that concatenate strings.
    >
    > Here is one example:
    >
    > =[CompanyName] & Chr(13) & Chr(10) & [Address]+Chr(13)+Chr(10) &
    > [Address2]+Chr(13)+Chr(10) & [City]+Chr(13)+Chr(10) &
    > [County]+Chr(13)+Chr(10) & [PostCode]
    >
    > This works fine on one PC, but comes up with the error "The function you
    > entered cannot be used in this expression". One of my controls also uses

    the
    > Mid function. Again, this works fine on one PC, but comes up with "#Name"

    on
    > the preview, but no other errors.
    >
    > The DB is set up with Frontend/Backend. The Backend is on my server, the
    > front end gets installed on each PC. I have the current version of DB on a
    > network share. The users run a batch file to copy the latest version to

    their
    > PC's. I have checked they are running the correct version. I have checked

    the
    > version on the network share from my PC (it works fine). Each PC uses XP

    Pro
    > and Office 2003 Pro.
    >
    > Any ideas what to check? I've checked the references and they all match.
    >
    > Dave
     
  5. David M C

    David M C
    Expand Collapse
    Guest

    Thanks, fixed now. It was a mssing reference (MapPoint 2004). The PC's in
    question don't have MapPoint installed, but the forms/reports they were using
    don't require MapPoint. I just copied the missing tbl file into the Access
    directory and it all worked.

    Thanks,

    Dave

    "Arvin Meyer [MVP]" wrote:

    > Ooops, sorry. Doug Steele's site is now at:
    >
    > http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "David M C" <DavidMC@discussions.microsoft.com> wrote in message
    > news:4D5E683B-B1CC-4A72-B91C-1BB687DE1BC3@microsoft.com...
    > > I have a database app setup that works fine on one PC. I have copied it to
    > > another PC and the reports don't work. The problem is associated with
    > > controls that concatenate strings.
    > >
    > > Here is one example:
    > >
    > > =[CompanyName] & Chr(13) & Chr(10) & [Address]+Chr(13)+Chr(10) &
    > > [Address2]+Chr(13)+Chr(10) & [City]+Chr(13)+Chr(10) &
    > > [County]+Chr(13)+Chr(10) & [PostCode]
    > >
    > > This works fine on one PC, but comes up with the error "The function you
    > > entered cannot be used in this expression". One of my controls also uses

    > the
    > > Mid function. Again, this works fine on one PC, but comes up with "#Name"

    > on
    > > the preview, but no other errors.
    > >
    > > The DB is set up with Frontend/Backend. The Backend is on my server, the
    > > front end gets installed on each PC. I have the current version of DB on a
    > > network share. The users run a batch file to copy the latest version to

    > their
    > > PC's. I have checked they are running the correct version. I have checked

    > the
    > > version on the network share from my PC (it works fine). Each PC uses XP

    > Pro
    > > and Office 2003 Pro.
    > >
    > > Any ideas what to check? I've checked the references and they all match.
    > >
    > > Dave

    >
    >
    >
     

Share This Page