Topic: help me

Hello
I worked on a program for the first time
I want to print the name of each student on a page, provided that it is not repeated within 24 hours
It means that if he asks for his name again, he will be rejected until after a full day again

I hope you can help me

Post's attachments

Attachment icon Students2.rar 373.28 kb, 168 downloads since 2022-12-29 

Re: help me

Hi,
You could try it like this (please see the attachment).
I have changed your form a bit to make it easier to test - there is a new tablegrid (tablegrid2) which shows which students are available for printing (ie have not been printed in the last 24 hours). 
Additionally, you may also filter by the student name in which case tablegrid2 will only show those students that have been filtered in tablegrid1 AND have not been printed in the last 24 hours).
Any newly created student is always made available for initial printing.
You can remove any extra tablegrids, columns etc you don't need once you are happy that it is doing what you want.
Derek.

Post's attachments

Attachment icon Students2.zip 419.38 kb, 114 downloads since 2022-12-29 

Re: help me


Thanks derek

But there is a problem
It prints all names at once
I want to choose an individual student
Is it possible to search by number as well and print?

Thank you

Re: help me

Hi,
Just printing an individual student is much easier (see attached).
It is now also possible to search by either student name or student number.
Derek.

Post's attachments

Attachment icon Students3.zip 419.6 kb, 161 downloads since 2022-12-30 

Re: help me

derek
you are my hero
Thank you

Re: help me

Adilzain2030
Where are you from??

Re: help me

derek

Can only one record appear in the tablegrid when searching without showing the rest of the records?

Re: help me

Hi,
Just change your search criteria; 
In the attached example, it uses a combobox to search by student name (to retrieve one record) and an edit field to search by student number (with the filter set to exact match (=) rather than fuzzy match (%s%)..
Derek.

Post's attachments

Attachment icon Students4.zip 419.73 kb, 133 downloads since 2023-01-13