Recent content by Nengster

Hi, I'm trying to concatenate an email string using a loop function however it does not seem to work. Here is my code. Does anyone seem to have a solution to this problem. Dim emaddr Dim emaddrapp strForm = "frmMailer" strSelect = "Select" 'initialise string emaddr = Empty Do While Not...

Hi, I would like to create a report that would allow me to display records based on the name of the course, the company particulars date of the course as well as the number of particpants of the course in question on a particular date. The date and name of the courses are not fixed at the...

I have created a registration form that will allow me to register for certain courses that I am conducting. The idea is that a client can attend many courses on the same day, many courses on many days as well as the same course on many days. I have set up the form such that it will allow me to...

Thanks for the suggestion. But the problem is that every month the course dates as well as the number of courses held are different hence I cannot fix the number of date fields on the report but instead it has to be able to extract from my table the dates in which the courses are held and then...

Would anyone care to provide asssitance on how I may to able to produce a report as if I am creating an excel worksheet based on data entered into my table monthly? Here is an explantion of what I am trying to achieve in Access. I have 2 tables: One that stores my contacts list, and another...