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"

Where are you getting this error message. Tell me the form. I hope it is the same database.

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

Please tell me the name of the form.

project updating. if i add all the data but leave the sub cont text box blank then i will receive that error

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.

if you don't mind can you tell me what you want to do then I can prepare the table structure for you.

ok then.. i got ur point.. but, if mine, i really in a blank mode which table i should modify..

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

will get back to you shortly

thank you very muchh

can you tell me why you require transmaster.

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

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.

Attached Files

Contarct_db.zip (77.1 KB, 8 views)

thank you so much maximus.. u helped me a lot.. thanx for ur time... =)