Search results

Thanks for the reply. So whenever this query is run it will show me all birthdays that between now and 1 months time?

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?

Hi I am not sure how to find this sample? Any chance you can post a link? Cheers

The attached database basically is a customer table with a form. Pressing the word button opens Word and populates the various fields of the leter from the selected Customer record. What I need is to be able to do this for every record in the database but by pressing the same one button

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...

Thanks a lot for your reply. This worked. Not even sure why it was on there! On the same note would you be able to tell me how to update the lstCLASS_INVOICE list box with the payment amount showing as requery doesn't seem to work on Open form as I get an error (it asks for the PUPIL ID) . It...

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...

Hi . Thank for your reply. so how would I close the connection to a list box and reopen it again after I have updated the table using DAO

Thanks for your reply. So if I wanted to use DAO to close the connection to a list box how would I do that?

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...

Thanks for the reply but that won't work as I need to be able to enter duplicate records in each field eg. more than one pupilID in the table. It is only a duplicate when the combination of PUPILID-CLASSID-TERMID have been entered before

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...