Recent content by Sa7ar

Thanks and I will read more about database design, thanks for the advice :)

well that's because the first post was three weeks ago and alot have changed since then, and now I have one table instead of three and the primary key is auto number :)

I'm not using the registration number as the primary key at all what I meant was that the registration number is unique for each product but I can't use it and I didn't have any other unique field that can be used as the primary key so now I just use auto number field as the primary key for this...

now I'm using one table for all products but i can't use the registration number as the primary key because some products still didn't get their registration number as they are still under-registration thanks RainLover

HaPPy NeW Year :)

well .. importing didn't work so I will try to get access 2010 and I'm sure I will get to learn alot from what you added to this database thank you so much for your help :) :)

khodr could you please attach the converted database ? :)

ok :) great

well .. I have access 2007 that is why it couldn't open a 2010 access database

really appreciate your help :) but the database attached won't open :( >> Unrecognized database format "F:\project DB\copy of DB project 16 dec 12.accdb"

Thanks for the tip about compact and repair option :) I didn't enter any data into the database because I thought that would make the size of the database smaller but I guess it didn't work :D. sorry about that I know there is still alot for me to learn.. thanks for your help I think bounding...

I'm hoping you could help me :)

I have uploaded a sample of my database, here is the link: It is on mediafire http://www.mediafire.com/download.php?hmpxlkkom4l6i4n

I'm sorry for the late reply but the database couldn't be attached here (and I don't know why..)

Thank you Aleni :) I made the query and now in the record source I have this statement > SELECT AllProducts_Table.Status FROM AllProducts_Table WHERE (((AllProducts_Table.Status)="Under-Registration")); But now all the fields say > #Name? and in the design view of this form it shows this >...