Search results

  1. S

    Table Design Help

    Dear Members I have a question regarding table design i m trying to develop a simple Student Fee Management System I have student table Student ID Name etc Fee Detail table Fee detail ID student ID (FK) Fee ID (FK) Discount Fee Account table Fee ID Tuition Fee (monthly)...
  2. S

    Database design help

    Dear members I need help in design small database what i need is a system to charge students Fee every month ( charging twice issue was resolved with CJ's advise). What i really want is to add Fee to student account even if number of students are in hundreds process should be really simple and...
  3. S

    Solved Composite Key Advise

    Dear Members I know this question has been answered many times but still i need some help in my project i m designing a student fee collection system how can i create a unique feeID for every month that include month and year information FeeID needs to be unique so that student can't be...
  4. S

    Change month according to Current System Date

    Dear All! I need help from all experts i have Month Table (MonthID, MonthName) I want to change MonthID in another form combo box Like if current date is Ist Jan to 31st Jan (Month ID Is 1) if Current Date changes to 1st Feb (MonthID should change to 2) Regards
  5. S

    Unmatched Records notification

    Hello everyone I m working on a small project can anyone help me with a vba code to identify unmatched records between 2 Data Tables and remind user through msg box to resolve the problem and it would be really helpful if msg box show which records are unmatched
  6. S

    Solved Subform Record Selection

    Hello, I am using Access for sometime now i need help regarding subform selection. I have Customer Main Form with subform linked with customer ID. Subform includes 5 fields Email ID Customer ID Email Type (Combo box with selections "Work", "Personal") Email Address Primary (Yes/No Field)...
Top Bottom