Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    re-establish relationship (access 2k)

    after cleaning up 10 yrs of data being entered but not updated in a database of over 3,000 for my volunteer position & then attempted 2 bring up a sub-form in access 2k (it worked correctly before, i received the following error msg "syntax error (missing operator) in query expression '[ID=' ".

    i think i inadvertently changed the name of the indexed field. can i re-establish the relationship with table? how? will this affect anything else?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: re-establish relationship (access 2k)

    Is there a query or SQL that is the source of the subform? You need to check the fields in the query or SQL back against the table to ensure that they are still correct.
    Can you run the query independantly?
    Pat

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: re-establish relationship (access 2k)

    thanx, again, i will respond in this forum this thursday when i use the actual db.

  4. #4
    New Lounger
    Join Date
    Jun 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: re-establish relationship (access 2k)

    the sub-form is based upon a query named "referencedperson". since so many fields are dissimilar, i'm not sure exactly what u mean by correct. i didn't setup the query so i have no idea what it was based on, therefore, i can't rerun it. i know all this isn't much help but any assistance would be appreciated.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: re-establish relationship (access 2k)

    What I meant by correct is, do all the field names in the query match the field names in the table you are referencing, you did mention about changing the name of an indexed field.
    Post the query to the forum here and we will all have a look.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  6. #6
    New Lounger
    Join Date
    Jun 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: re-establish relationship (access 2k)

    when i try to open the query i get the following error msg "invalid use of '.', '!' or '()' in query expression 'ReferencedPerson. [Specific Diagnosis of Referenced Person]'."

    the following is the query in design mode:
    "SELECT ReferencedPerson. [Specific Diagnosis of Referenced Person], ReferencedPerson.ReferencedPersonID, ReferencedPerson.[Role of Caller to Referenced Person]
    FROM ReferencedPerson;"

    Any ideas about where I go from here?

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: re-establish relationship (access 2k)

    Your statement

    "SELECT ReferencedPerson. [Specific Diagnosis of Referenced Person], ReferencedPerson.ReferencedPersonID, ReferencedPerson.[Role of Caller to Referenced Person]
    FROM ReferencedPerson;"

    has a space between ReferencedPerson. and [Specific Diagnosis of Referenced Person] .

    HTH
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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