Recent content by CrostonScottish

Anybody help me with some code that i am having difficulties with? I have found some code for sample reports produced by microsoft which i would like to use in a report in my database. One code is to "Draw vertical lines in a report that can grow" with the event procedure on the detail...

Thanks some fantastic, sound advice. I always try to run before i can walk. Your suggestions are great and i will certainly get back to the drawing board. As a complete novice you pick up bad habits and realise your mistakes only when you get stuck and some one points out the holes. Thanks...

Append Query Thanks for the prompt response. I am afraid you are dealing with quite a novice in terms of Access. I am not sure i fully understand you. My VBA is almost non-existant so not sure i understand transforming the append query. My problem before i get in to that is building a...

I am having a few problems that i am sure someone can set me right with. I have a database for students and enrolements on courses. Each Student Record form has a subform based on the SQL below: SELECT tblLINKStudent_Course.lngStudentID, tblLINKStudent_Course.lngCourseID...

Automate email error Thanks for that. It was all a bit of a guess that i needed to use rst! to send email to specific person but didn't know that much VBA to be able to spot the mistake. Its working like a dream. Thanks again

I wonder if anybody can help. I have a code that i have used successfully in previous databases to automatically send an email based on a record set. The problem i have is that this database does not use set email addressess placed in the code as in the past. I would like the email to be sent...