Page 1 of 6 123456 LastLast
Results 1 to 15 of 86
  1. #1
    ngeng4 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    93

    error message


    how can i solve this error message?
    "The Microsoft Jet Database engne cannot find a record in the table 'table name' with key matching field"

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Where are you getting this error message. Tell me the form. I hope it is the same database.

  3. #3
    ngeng4 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    93
    yerp. it is in the same db. in the updating form. if i fill up a new data, i cant save it and this error msg appear

  4. #4
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Please tell me the name of the form.

  5. #5
    ngeng4 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    93
    project updating. if i add all the data but leave the sub cont text box blank then i will receive that error

  6. #6
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Basically the error tells you that there are no matching data in the following table:

    Let me explain suppose I build two tables
    Table1:{Id_Code,name,Class}
    Table2:{Link_id,fatherName,MotherName,Details}


    Now I link Id_code and Link_id just as you did in your database.

    No I make a Entry in Table1:
    Id_Code=1
    name=Siddthartha Majumdar
    Class=2

    Now observe if I make a entry in table 2 like this it is valid:
    Link_id=1
    fatherName=Alokesh Majumdar
    MotherName=Joya Majumdar
    Details=Computer Expert

    this is valid as this data has a supporting in table1 i.e. Id_Code has the number 1.

    Now observe if I make a entry in table 2 like this it is invalid:
    Link_id=2
    fatherName=Alokesh Majumdar
    MotherName=Joya Majumdar
    Details=Computer Expert

    I will get an error that their are no matching valeus in table1 because table1 doen't have an Id_Code=1

    Now you have to find where lies the problem.

  7. #7
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    if you don't mind can you tell me what you want to do then I can prepare the table structure for you.

  8. #8
    ngeng4 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    93
    ok then.. i got ur point.. but, if mine, i really in a blank mode which table i should modify..

  9. #9
    ngeng4 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    93
    okay sure.

    i have to create a database that contain a project name, used product, [contractor,client, architect,C&S and QS for the project], completed year, project type, and sub contractor.

    so basically, i need a table for project, information about it [contractor, client, architect, C&S and QS], and the detail [used product and sub contractor].

    is this really clear for you? thank you so muchh

  10. #10
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    will get back to you shortly

  11. #11
    ngeng4 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    93
    thank you very muchh

  12. #12
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    can you tell me why you require transmaster.

  13. #13
    ngeng4 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    93
    because i dont know how to link those table. so i feel like i need 1 table to link all those thing between project, information and sub cont detail and product detail. each project will use maximum of 6 product and maximum of 3 sub contractor. thats y if u can see in my previous db, ive create both [sub cont and product] in the different table

  14. #14
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Sorry I could not be more elaborate as I had only 45 min to get through the database. I am in the office right now. anyways let me explain what I have done.

    as you open the application a Statup form will open with two options:
    1) Open project Update (New)
    2) Open Project Update (All Records)


    The First Option as understood will open a blank, The second option will open the Form tblProjectDetails with all the records.


    Open a Blank Form Fill up all the Fields above the Product Labels and Click on the Button Confirm Project Details. Once You do that Two Buttons Enter Products and Enter Sub-Contractors will be enabled. Now select a Product in the product combo box and click on Enter Product button the product is entered and you will see it displayed on the Product entered List Box. Try Entering more then 6 Products You will get a error prompt.

    Same Procedure to be followed for Sub-Contractors.

    To delete a product Click on the product in the Product Entered List box. Select The option Delete product (Option Group below Sub-Contractor entered List Box) and Click on Button Remove.

    Same Procedure to be followed for Sub-Contractors.



    Delete Button in the form navigation Controls(NEW,NEXT,PREVIOUS) will delete all entries in the various fields related to a particular ProjectID.


    You can do much more set more validation conditions like if a project status is completed then only you can type completed year etc.

    explore the database. Hope it will be some help to you.

  15. #15
    ngeng4 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    93
    thank you so much maximus.. u helped me a lot.. thanx for ur time... =)

Page 1 of 6 123456 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Error Message in Access2007
    By Storm91 in forum Access
    Replies: 3
    Last Post: 02-18-2010, 02:56 PM
  2. Text too long, error message
    By taylormotm in forum Access
    Replies: 13
    Last Post: 06-18-2009, 07:24 PM
  3. where do i start with this error message?
    By Student4Life in forum Access
    Replies: 0
    Last Post: 01-09-2009, 04:12 PM
  4. FROM Clause error message
    By skylite in forum Queries
    Replies: 2
    Last Post: 10-23-2008, 05:47 AM
  5. If / Then Error Message
    By Schwagr in forum Forms
    Replies: 4
    Last Post: 03-30-2006, 06:28 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