You are not logged in. Please login or register.
My Visual Database → General → School Fees Management System
Please, can anyone help me with a sample project on the above subject?
Details
*Register students, class, academic year and term
*Fees are created for three terms in a year
*Balance should be brought forward the next academic year
*Admin will create fees eg. For Academic year 2018/2020, term 1
Tuition fee= 20
Ict fee =2 etc
*Fees will be assigned to each class for a term in the academic year
Thank you in advanced
Hello Derek and mvd users,
I'm trying to do something about the above topic. Please can you take a look at the sample and help me with the note specified in the project?
I'm trying to add all members in a class from a combobox to a table in the database.
Any help will be appreciated.
feeManager.zip 4.69 kb, 367 downloads since 2019-08-15
Hi,
Perhaps try it like the attached - it seemed the simplest, but I'm sure there are other ways too.
I added a new form just so you can check that the inserts into the 'stdfee' table are working correctly.
Regards,
Derek.
(also just added a check to stop rows being inserted into stdfee table if either 'fee' or 'class' not selected)
fee manager.zip 340.27 kb, 478 downloads since 2019-08-16
Thank you Derek.
You have really made the work so easy. Really appreciated.
Follow up question
fname ||" "|| lname ||" "|| onameI am using the above code in a calculated field of the database but if the oname is blank, it shows empty record in the tableGrid. Please, any help?
Thank you in advance.
Hi,
You just need to add a check in your calculated field to see if any of the fields that are being concatenated are blank.
Try it like this:
ifnull(firstname,'')||' '||ifnull(lname,'')||' '||ifnull(oname,'')
Regards,
Derek.
Thanks so much
It worked perfectly
Hello family, please how can I show a message of the cell of a tableGrid when that cell is clicked.
I have tried several times but to no avail.
It only works when the event is in a button, but what I want is the event should trigger on tableGrid onCellClick.
Thank you
cellClick.zip 4.3 kb, 357 downloads since 2019-08-19
Make this change in your project:
procedure Form1_TableGrid1_OnCellClick (Sender: TObject; ACol, ARow: Integer);
begin
ShowMessage(Form1.TableGrid1.Cells(1,ARow));
end;Make this change in your project:
procedure Form1_TableGrid1_OnCellClick (Sender: TObject; ACol, ARow: Integer); begin ShowMessage(Form1.TableGrid1.Cells(1,ARow)); end;
Thanks for the prompt response.
I really appreciate it
It works perfectly
procedure Form1_TableGrid1_OnClick (Sender: TObject);
begin
ShowMessage(Form1.TableGrid1.Cells[1,Form1.TableGrid1.SelectedRow]);
end;
TableGrid1_OnClick
procedure Form1_TableGrid1_OnClick (Sender: TObject); begin ShowMessage(Form1.TableGrid1.Cells[1,Form1.TableGrid1.SelectedRow]); end;
TableGrid1_OnClick
Thank you so much for your support
Hello Dmitry, Derek, sibprogsistem and mvd lovers,
I have another issue which I need your help.
The attached project can create student bills and can also assign the bills to the students. My problem now is how to generate the on print button click.
Please find attached for more details.
Thank you in advance.
feeManReport.zip 21.91 kb, 348 downloads since 2019-08-20
Hello Dmitry, Derek, sibprogsistem and mvd lovers,
I have another issue which I need your help.
The attached project can create student bills and can also assign the bills to the students. My problem now is how to generate the on print button click.
Please find attached for more details.
Thank you in advance.
I have been able to figure it out.
Thank you all
@thezimguy
can you upload your corrected project with us, i want to know the print correction.
@Asifmute, what I did was to write SQL statement to retrieve the records I needed in the button using the "REPORT SQL" Action of the button.
Find attached the project.
feeManReport2.zip 13.76 kb, 388 downloads since 2019-08-24
My Visual Database → General → School Fees Management System
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi