Search results

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 >...

Thanks Aleni :) Can you please give me steps for how to bound my form to a query ?

Thank you so much Swemebegur & Khodr :) you're life savers :) I will go for the one table for all products and a status field. Fields for registered and under registration products are slightly different and it would be ok to leave some fields as NA. Two more questions please: :) 1) can you...

oh sorry I misunderstood your question.. I don't know if this option exists in access .. If it does , I would like to know how :D. Good Luck :)

In the design view of a table > under data type > you can find hyperlink and attachment (like word or excel or PDF files) > and then in the datasheet view you can insert the data you want (whether it is a hyperlink or attachment) hope it help :)

Hello I'm still a newbie in the Access world and I need your help :) Here is the situation: I'm using Microsoft Access 2007 I have three tables: the 1st is for product's identification, the 2nd is for registered products, and the 3rd is for under-registration products and the primary key for...