Welcome to SPN

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

Sign Up Now!

Instr function not defined--- Version conflict?

Discussion in 'Information Technology' started by JoeA2006, Jul 28, 2006.

  1. JoeA2006

    JoeA2006
    Expand Collapse
    Guest

    I have copied an Access file to the network. Everything looks good from my
    machine. However when the user works with the database, one of the subforms
    has no data.
    I tried to even go into design view on his machine and I get a message
    "Instr function no defined".... I have SP-3 and he does not. Could the
    version be the problem? Would I need to change the app, or would updating to
    SP-3 on his machine help?... I did not think it was a version problem because
    the data showed up until I made a change and re-copied it .. but the data
    shows up fine on my machine
     
  2. Loading...

    Similar Threads Forum Date
    General Namdhari Join Sikh Mainstream Hard Talk Sep 15, 2015
    Politics “Untouchability Is An Instrument In The Hands Of The Upper Castes” Breaking News Oct 28, 2012
    World In Israel, Spate Of Ultra-Orthodox Incidents Rattle The Secular Mainstream Breaking News Jan 10, 2012
    General Great Sikh Instrumentalists: Music no vocals Videos Dec 7, 2011
    Multicultural Minstrel - Sikh-Aussie Dya Singh Gurmat Sangeet Nov 13, 2011

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:

    > I have copied an Access file to the network. Everything looks good from my
    > machine. However when the user works with the database, one of the subforms
    > has no data.
    > I tried to even go into design view on his machine and I get a message
    > "Instr function no defined".... I have SP-3 and he does not. Could the
    > version be the problem? Would I need to change the app, or would updating to
    > SP-3 on his machine help?... I did not think it was a version problem because
    > the data showed up until I made a change and re-copied it .. but the data
    > shows up fine on my machine


    That PC has a missing reference.
    Open any module in Design view (or click Ctrl + G).
    On the Tools menu, click References.
    Click to clear the check box for the type library or object library
    marked as "Missing:."

    An alternative to removing the reference is to restore the referenced
    file to the path specified in the References dialog box. If the
    referenced file is in a new location, clear the "Missing:" reference
    and create a new reference to the file in its new folder.

    See Microsoft KnowledgeBase articles:
    283115 'ACC2002: References That You Must Set When You Work with
    Microsoft Access'
    Or for Access 97:
    175484 'References to Set When Working With Microsoft Access' for
    the correct ones needed,
    and
    160870 'VBA Functions Break in Database with Missing References' for
    how to reset a missing one.

    For even more information, see
    http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. JoeA2006

    JoeA2006
    Expand Collapse
    Guest

    When I look at the references in the VBA editor, on the users machine ,it
    looks like the same references are checked as are when I look at it on my
    machine. Both machines are Access 2000. The references checked are Visual
    Basic for Applications,Microsoft Access 9.0 Object library, OLE Automation,
    Microsoft ActiveX Data objects 2.1 Library and Microsoft Windows common
    controls sp6. Do I need to check some of the others. It looks like from the
    information you directed me to, some of the others need to be checked. I did
    not find any marked as "missing" but there were only 5 boxes checked.

    "fredg" wrote:

    > On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
    >
    > > I have copied an Access file to the network. Everything looks good from my
    > > machine. However when the user works with the database, one of the subforms
    > > has no data.
    > > I tried to even go into design view on his machine and I get a message
    > > "Instr function no defined".... I have SP-3 and he does not. Could the
    > > version be the problem? Would I need to change the app, or would updating to
    > > SP-3 on his machine help?... I did not think it was a version problem because
    > > the data showed up until I made a change and re-copied it .. but the data
    > > shows up fine on my machine

    >
    > That PC has a missing reference.
    > Open any module in Design view (or click Ctrl + G).
    > On the Tools menu, click References.
    > Click to clear the check box for the type library or object library
    > marked as "Missing:."
    >
    > An alternative to removing the reference is to restore the referenced
    > file to the path specified in the References dialog box. If the
    > referenced file is in a new location, clear the "Missing:" reference
    > and create a new reference to the file in its new folder.
    >
    > See Microsoft KnowledgeBase articles:
    > 283115 'ACC2002: References That You Must Set When You Work with
    > Microsoft Access'
    > Or for Access 97:
    > 175484 'References to Set When Working With Microsoft Access' for
    > the correct ones needed,
    > and
    > 160870 'VBA Functions Break in Database with Missing References' for
    > how to reset a missing one.
    >
    > For even more information, see
    > http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    It is vital that everybody that uses the same front-end have the Same
    Service Packs, due to this kind of stuff & to prevent it if distributed

    Pieter



    "fredg" <fgutkind@example.invalid> wrote in message
    news:ncm4fss32am0.146b9b9scxohs.dlg@40tude.net...
    > On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
    >
    >> I have copied an Access file to the network. Everything looks good from
    >> my
    >> machine. However when the user works with the database, one of the
    >> subforms
    >> has no data.
    >> I tried to even go into design view on his machine and I get a message
    >> "Instr function no defined".... I have SP-3 and he does not. Could the
    >> version be the problem? Would I need to change the app, or would updating
    >> to
    >> SP-3 on his machine help?... I did not think it was a version problem
    >> because
    >> the data showed up until I made a change and re-copied it .. but the data
    >> shows up fine on my machine

    >
    > That PC has a missing reference.
    > Open any module in Design view (or click Ctrl + G).
    > On the Tools menu, click References.
    > Click to clear the check box for the type library or object library
    > marked as "Missing:."
    >
    > An alternative to removing the reference is to restore the referenced
    > file to the path specified in the References dialog box. If the
    > referenced file is in a new location, clear the "Missing:" reference
    > and create a new reference to the file in its new folder.
    >
    > See Microsoft KnowledgeBase articles:
    > 283115 'ACC2002: References That You Must Set When You Work with
    > Microsoft Access'
    > Or for Access 97:
    > 175484 'References to Set When Working With Microsoft Access' for
    > the correct ones needed,
    > and
    > 160870 'VBA Functions Break in Database with Missing References' for
    > how to reset a missing one.
    >
    > For even more information, see
    > http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
     
  6. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    It is vital that everybody that uses the same front-end have the Same
    Service Packs, due to this kind of stuff & to prevent it if distributed

    Pieter



    "fredg" <fgutkind@example.invalid> wrote in message
    news:ncm4fss32am0.146b9b9scxohs.dlg@40tude.net...
    > On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
    >
    >> I have copied an Access file to the network. Everything looks good from
    >> my
    >> machine. However when the user works with the database, one of the
    >> subforms
    >> has no data.
    >> I tried to even go into design view on his machine and I get a message
    >> "Instr function no defined".... I have SP-3 and he does not. Could the
    >> version be the problem? Would I need to change the app, or would updating
    >> to
    >> SP-3 on his machine help?... I did not think it was a version problem
    >> because
    >> the data showed up until I made a change and re-copied it .. but the data
    >> shows up fine on my machine

    >
    > That PC has a missing reference.
    > Open any module in Design view (or click Ctrl + G).
    > On the Tools menu, click References.
    > Click to clear the check box for the type library or object library
    > marked as "Missing:."
    >
    > An alternative to removing the reference is to restore the referenced
    > file to the path specified in the References dialog box. If the
    > referenced file is in a new location, clear the "Missing:" reference
    > and create a new reference to the file in its new folder.
    >
    > See Microsoft KnowledgeBase articles:
    > 283115 'ACC2002: References That You Must Set When You Work with
    > Microsoft Access'
    > Or for Access 97:
    > 175484 'References to Set When Working With Microsoft Access' for
    > the correct ones needed,
    > and
    > 160870 'VBA Functions Break in Database with Missing References' for
    > how to reset a missing one.
    >
    > For even more information, see
    > http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  7. JoeA2006

    JoeA2006
    Expand Collapse
    Guest

    I opened the Access file up on another users computer that has the same
    Access version I have and the data for that one subform does not show up, but
    I still see it from my machine. Do I need to rebuild the query and copy over
    the old version? I am running out of ideas as to how to solve this. Thanks

    "Pieter Wijnen" wrote:

    > It is vital that everybody that uses the same front-end have the Same
    > Service Packs, due to this kind of stuff & to prevent it if distributed
    >
    > Pieter
    >
    >
    >
    > "fredg" <fgutkind@example.invalid> wrote in message
    > news:ncm4fss32am0.146b9b9scxohs.dlg@40tude.net...
    > > On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
    > >
    > >> I have copied an Access file to the network. Everything looks good from
    > >> my
    > >> machine. However when the user works with the database, one of the
    > >> subforms
    > >> has no data.
    > >> I tried to even go into design view on his machine and I get a message
    > >> "Instr function no defined".... I have SP-3 and he does not. Could the
    > >> version be the problem? Would I need to change the app, or would updating
    > >> to
    > >> SP-3 on his machine help?... I did not think it was a version problem
    > >> because
    > >> the data showed up until I made a change and re-copied it .. but the data
    > >> shows up fine on my machine

    > >
    > > That PC has a missing reference.
    > > Open any module in Design view (or click Ctrl + G).
    > > On the Tools menu, click References.
    > > Click to clear the check box for the type library or object library
    > > marked as "Missing:."
    > >
    > > An alternative to removing the reference is to restore the referenced
    > > file to the path specified in the References dialog box. If the
    > > referenced file is in a new location, clear the "Missing:" reference
    > > and create a new reference to the file in its new folder.
    > >
    > > See Microsoft KnowledgeBase articles:
    > > 283115 'ACC2002: References That You Must Set When You Work with
    > > Microsoft Access'
    > > Or for Access 97:
    > > 175484 'References to Set When Working With Microsoft Access' for
    > > the correct ones needed,
    > > and
    > > 160870 'VBA Functions Break in Database with Missing References' for
    > > how to reset a missing one.
    > >
    > > For even more information, see
    > > http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
    > > --
    > > Fred
    > > Please respond only to this newsgroup.
    > > I do not reply to personal e-mail

    >
    >
    >
     
  8. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    You can always try opening it with the /Decompile switch to get rid of all
    compiled code before putting it on the net

    shortcut: Decompile
    Target: <Path to MsAccess.exe> <Path to Database> /DECOMPILE

    HTH

    Pieter


    "JoeA2006" <JoeA2006@discussions.microsoft.com> wrote in message
    news:9BCDB8EB-B616-42EF-853A-CA4DDB87A2F6@microsoft.com...
    >I opened the Access file up on another users computer that has the same
    > Access version I have and the data for that one subform does not show up,
    > but
    > I still see it from my machine. Do I need to rebuild the query and copy
    > over
    > the old version? I am running out of ideas as to how to solve this. Thanks
    >
    > "Pieter Wijnen" wrote:
    >
    >> It is vital that everybody that uses the same front-end have the Same
    >> Service Packs, due to this kind of stuff & to prevent it if distributed
    >>
    >> Pieter
    >>
    >>
    >>
    >> "fredg" <fgutkind@example.invalid> wrote in message
    >> news:ncm4fss32am0.146b9b9scxohs.dlg@40tude.net...
    >> > On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
    >> >
    >> >> I have copied an Access file to the network. Everything looks good
    >> >> from
    >> >> my
    >> >> machine. However when the user works with the database, one of the
    >> >> subforms
    >> >> has no data.
    >> >> I tried to even go into design view on his machine and I get a
    >> >> message
    >> >> "Instr function no defined".... I have SP-3 and he does not. Could the
    >> >> version be the problem? Would I need to change the app, or would
    >> >> updating
    >> >> to
    >> >> SP-3 on his machine help?... I did not think it was a version problem
    >> >> because
    >> >> the data showed up until I made a change and re-copied it .. but the
    >> >> data
    >> >> shows up fine on my machine
    >> >
    >> > That PC has a missing reference.
    >> > Open any module in Design view (or click Ctrl + G).
    >> > On the Tools menu, click References.
    >> > Click to clear the check box for the type library or object library
    >> > marked as "Missing:."
    >> >
    >> > An alternative to removing the reference is to restore the referenced
    >> > file to the path specified in the References dialog box. If the
    >> > referenced file is in a new location, clear the "Missing:" reference
    >> > and create a new reference to the file in its new folder.
    >> >
    >> > See Microsoft KnowledgeBase articles:
    >> > 283115 'ACC2002: References That You Must Set When You Work with
    >> > Microsoft Access'
    >> > Or for Access 97:
    >> > 175484 'References to Set When Working With Microsoft Access' for
    >> > the correct ones needed,
    >> > and
    >> > 160870 'VBA Functions Break in Database with Missing References' for
    >> > how to reset a missing one.
    >> >
    >> > For even more information, see
    >> > http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
    >> > --
    >> > Fred
    >> > Please respond only to this newsgroup.
    >> > I do not reply to personal e-mail

    >>
    >>
    >>




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page