Results 1 to 7 of 7
  1. #1
    aliaslamy2k is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Apr 2020
    Posts
    31

    Error Message " Too complex to be evaluated"

    Dear Experts,

    I am trying to create a database and after adding relation it gives me an error. I cannot even run the query it pop up a message " Type Mismatch in expression"


    Please find below all screen shots. I wonder what wrong step am i taking in this.

    Kind regards,
    AB
    Attached Thumbnails Attached Thumbnails 1.JPG   Error 1.JPG   Query Error.JPG  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You cannot join number fields to strings.
    empID is a number,
    empName is a string.

    join ID to ID, or name to name.
    the TASK table should use EmpID.

  3. #3
    aliaslamy2k is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Apr 2020
    Posts
    31
    Hi Ranman,

    Thank you so much, I was watching youtube videi where it shows that EmpName is selected as NUMBER and able to enter text in the field.
    But when i tried, I am unable to enter text in number field. Any suggestion how he was able to do that.

    https://www.youtube.com/watch?v=KlzrWoH_Z-0

    Kind regards,
    AB
    Attached Thumbnails Attached Thumbnails Youtube1.JPG   Youtube2.JPG  

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    No, the EmpName (string) should not be in the table. It should be EmpID. (LONG)
    add ID to the table, (new field)
    Make an update query and Join tEmp.Name table to tTask.NAME,
    then fill in EmpID,
    then remove EmpName field.

  5. #5
    aliaslamy2k is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Apr 2020
    Posts
    31
    Hi Ranman,

    Thank you once again!

    I give up on this, i want to make table as it shows in the above youtube channel but i am unable to do.

    Thank you once again for your help

    Kind regards,
    AB

  6. #6
    aliaslamy2k is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Apr 2020
    Posts
    31
    Hi Ranman,

    I would highly appreciate if you could help me to make relation in the tables please. I have attached the sample Access file.
    Attached Files Attached Files

  7. #7
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    As ranman indicated previously you need to link the Primary Key from tbl_Employee to the Foreign Key in TaskDue

    See the revised Db attached
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 10-19-2015, 04:22 PM
  2. Suppress "Error" message following "Cancel = True"
    By GraeagleBill in forum Programming
    Replies: 7
    Last Post: 03-23-2014, 05:40 PM
  3. Replies: 2
    Last Post: 06-07-2012, 02:59 PM
  4. Replies: 3
    Last Post: 12-30-2011, 12:43 PM
  5. Replies: 8
    Last Post: 11-12-2010, 10:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums