Sample Project

[ammu_sridhar]

Hello all,

I am new to this forum and to MS Access. I have to build a small project as follows. I have a fill one table with the columns "Emp Id", "Name", "Sex", "Age", "Salary" etc... which I should import from a notepad file where the values are seperated by symbol "|". Then I need to design a form where I should be able to enter some text for name, check box for Age in different groups, toggle button for sex etc..etc... and press "Query" button. Then I should get the results in the below format. I should able to change my select criteria and query again. Then new rows should be displayed.

"Emp Id" "Name" "Sex" "Age" "Salary"
1234 sdfsdfdsf m 34 6456
4564 scsdfw m 23 3454
6786 vdfgfgdf f 23 45654

Could anybody give me a code for this. Any kind of help from anybody is greately appriciated.

Thanks
Sri

 

[ezfriend]

I rather teach you how to fish, but I was in your shoe before so attached is the fish.

 

[ammu_sridhar]

Dear Friend,

Thank you very much for your support. It is of great help for me.

Thanks
Sri

 

[DCrake]

When you hand your assignment in be careful you have not told everybody where you got your mdb from as they will all be the same and your teacher will know you have not done the work yourself.