Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    North Yorkshire, UK
    Posts
    9

    Unanswered: Form #Name? and #Error Messages

    I have a query which spans several tables, and successfully extracts all required data exactly how it should. The database is a match score archive and statistics system for a table tennis league, and contains tables for Home Teams; Away Teams; Fixture Details; Start Times; Home Nights (the night of the week the teams play at home) and Home Venues.

    This all works correctly in the query, which looks up all stored data about all fixtures. However, when I place this data into a form, the two Team Name fields (AwayTeamName and HomeTeamName) are missing, and have #Name? instead. All of the other fields work correctly, so this is quite a mystery to me. I tried changing the control source to the records in the tables, and for some reason this gave the Team Name for both teams. (The fields are both called TeamName, but are in different tables). I tried chaning to control source to the query, but this only gave me #Name?. Adding Square brackets into the expression gave me #Error instead, but no useful values.

    Attached is the layout of my relationships.

    Can anyone explain this to me, or help me at all?

    Thanks in anticipation, Joe Seed
    Attached Thumbnails Attached Thumbnails relationships.jpg  

  2. #2
    Join Date
    Dec 2003
    Location
    North Yorkshire, UK
    Posts
    9
    And this is the design view of the query:

    (Sorry about the size; resizing reduced the quality too much, because I don't have a good graphics package on this PC)
    Attached Thumbnails Attached Thumbnails query.jpg  

  3. #3
    Join Date
    Dec 2003
    Location
    North Yorkshire, UK
    Posts
    9
    BUT, I changed the join property between tblTeams and tblFixtures in the query to type 3 instead of type 1, and it worked successfully - this sounds like a bug to me. Has anyone else experienced this, or does anyone know why it happens?

Posting Permissions

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