Recent content by stinger

trying to manage results of student, i need specific format for result card, I am attaching my db and images, a form image where we should add exams in list box like assessment-1 and so on, also attaching the result card, there should be dynamic number of exams and subjects, just add first 4...

I simply want to delete all controls like text box from a form named MyForm through code

Sub RemoveOldControlsAndAddNew() Dim newControl As Control Dim valuesArray() As Variant Dim totalWidth As Single Dim controlWidth As Single Dim currentLeft As Single Dim i As Integer Dim frm As Form Dim ctl As Control valuesArray = Array("Value1", "Value2", "Value3", "Value3") totalWidth = 5 *...

Form Name is MyForm i want to delete all text box from form and make new, if there are not any controllers code work fine and make new controllers(text box) but when i want to run it second time its not work, this code delete 1 text box and give error controller name already in use Sub...

thanks arnelgp

Thank You Very much its look very closer what i need, Thanks Dear I will See it in Detail and will come back,

sorry not got you, condition for final Marks is ok thats fine that is what we need, we need condition for grand total as well, there should be less or more exam type like assessment-1, assessment-2, assessment-3 and so on , if assessment-1 ,2 ,3 have marks less than 50% total marks of that exam...

Thanks for Your response, in query3 grandTotal must contain only those marks which are greater than 50% of total marks of that exam, for example if assessment-1 total marks for class 1 are 200 and obtained marks are 99 then it should not include in GrandTotal

hope this will make sense, sorry I am not good in English

Any assistance from you would greatly simplify things for me, and I would truly appreciate it.

I often use MS Access for small tasks, I am not very good at it, I am already using a small exam system which is not dynamic and I have to change it frequently, I want to create a dynamic cross tab query which I need help with, I have a query named assessmnetTotals which has a column named...

4-16-24 ****************** use the current db object instead of creating an external connection Set rs = CurrentDb.OpenRecordset("select * from dataTbl") I am practicing external connection , coz planning to use on network

this line is to clear the list box except 1st line because there is header in first line

i am attaching my database file , check the WRITE_DATA( ) function in module "dateSetter", after saving the data in this function i immediately open a form "RegSlip_form" and set the record source "SELECT dataTbl.* FROM dataTbl WHERE (((dataTbl.rollint_fld)=[TempVars]![rollint])); " some time...