Recent content by ENEMAL

I will do exactly like you suggested

Thanks pat, but anytime I split my ms access app into FE and BE, I find it difficult to distribute as the link between them will be broken and cannot link them via vba. I think I will have to find away of doing that.

Thanks lightwave I'm very clear now. Thanks again

Please can someone help me to clearify some issues that have confused me and sorry if this question is not ok for this forum. I have always read that upgrading from ms access database to sql server is always better idea because perfomance is better in sql server , but i'm confused. 1. with ms...

Thanks Gina that will really get me started. i will patiently study that complicated relationship Thanks again

I'm trying to setup a student grading system(SGS) but finding it difficult to set up the tables and the appropriate relationship. The SGS is as follows 1. the school system runs an academic session so i will create a table called SESSION 2. each session is divided in to three parts called...

Having read about table relationship, i discovered that my schema was wrong . I will have to start a new thread regarding that. Thanks for all your response .

I have two tables. TblClassess and Tblstudent Tblclass has these fields (pk_ classid, classname , year) Tblstudent fields are stdID , FK_classid , studentName , status, others The two tables are related by pk_classid and FK_classid Now I have a main form base on Tblclass and a subform...

Uncountable thanks to you apr and Sorry for the late reply. I was on a very long journey. But after following all your steps, everything worked perfectly just as I wanted. I used SessionID instead of Session_ID ( without underscore ) because my table has no underscore . Thanks again

I have exausted my novice knowledge over this. I have three tables namely StudentRecord, session and payments StudentRecord has these fields StudentID (pri. Key) Name Address ..... Session has these fields SessionID (pri. Key) StudentID ( f. Key) Schoolyear Payments has these fields...

I need an assistance in first database in access. Iam creating a student database in ms access2007 but finding difficult to go further. In my database, I have created the following Student-info-table SemesterTable SessionTable PaymentTable Then a query from the payment that shows student...