Search results

Hi I have a table called TBL_PUPIL and within that it holds the pupils date of birth fldDOB. This is currently formatted DD/MM/YYYY. I want a query to return all pupils whose birthday is in 1 month (30days) or less away and wondered if you could give some advice on how I do this please?

Hello. I have attached a demo I found on this site which is perfect for me to create a letter for a specific person. What I will also want is the ability merge, load and print all the records in the table. I assume I could use a loop stamentment somewhere but would this open word everytime...

Hi, I currently have a database with a pupil table and within that table there is a date of birth field (DOB). What I would like to do is when entering the application, to have a button which navgates the user to a birthday page. This page contains a list box (lst1) which displays people who's...

Hi, Sorry I am pretty new to all of this so I have another question which is stumping me still. I have attached the DB for you to have a look as it will be a lot quicker I guess. No laughing please as like I said I am new to this :) The first form open is FRM_MAIN You then select the top...

I currently havex2 forms - frm1 and frm 2 frm1 has a listbox called lst1 which is connected to a table called tblInvoiceAll there are 3 fields in the listbox which are PupilID, ClassID and TermID. clicking on a slection in the lst1 opens frm2. A selection is made from a pupil list (another...

An explanation into my problem: I currently have a form (frm1) and within that form I have a list box (lst1) The list box displays filtered pupil, course name, course cost, amount paid, amount remaing to be paid When I click on the list box it opens another form (frm2) which allows me to...

Please help. I currently have a form (frm1) with a listbox on it (lst1) lst1 has a filter on it The filter is run from a query (qry1) which displays all current records from a table (tbl1) When I select an item on lst1 it opens another form (frm2) and dependant on what is slected on lst1 is...

Hi I currently have an input form called ENROL_CLASS which has 3 fields. They are: txtPupilID txtClassID txtTermID I have a button call btnEnrolStudnet. All fields have to have data in to proceed. There is a table called CLASSES_TAKEN and an insert query which runs when the btnEnrolStudent...