Search results

I can't seem to successfully deal with this error. The scenario is as follows. I call the above routine when the user clicks on a save button I have added to the form, which launches an email. with the option of having the User see it first. That works fine. If the user chooses to not send...

Thanks RG I was aware of that. As all the other forms in the database have a save button, I was trying to keep the approach uniform. (I understand that it is more work).

Thanks Thanks all My problem was that I did not have a reference to microsoft outlook libary in my code

Hi All I have a form with 2 combo boxes which are used to select the data displayed in the continuous form. The form shows Student ID, Student Name, and a field called Attend (text box, with drop down allowing "Y" or "N"), (which is to be updated to show if the student attended the course or...

thanks Would you mind looking at the post below to see where i am going wrong http://www.access-programmers.co.uk/forums/showthread.php?t=143881&goto=newpost

Thanks for the reply Would you mind looking at the thread below to see what I am doing wrong http://www.access-programmers.co.uk/forums/showthread.php?t=143881&goto=newpost

I have a private sub which i am trying to use to sends emails from a form At the moment I call the sub from within an ON click event (On add New Button) when a user saves a record,. Will this work, or does the code to send emails have to be on a button of its own. send email(On Click event)...

I have a private sub which i am trying to use to sends emails from a form At the moment I call the sub from within an ON click event (On add New Button) when a user saves a record,. Will this work, or does the code to send emails have to be on a button of its own. send email(On Click event)...

Thanks David That is just what I needed to know Pat

Hi I have searched the forums, and tried to emulate the code samples found but to no avail Can someome please advise on why my code is not working. The message box "about to Call Send Email" appears, but then nothing else happens. I do not get the Msgbox " In Email". The code below is part...

Thanks for the help For the vaiable to be available across the different forms where in the code do I decalre the PUBLIC variable (Can it be declared in one of the forms code) Thanks in advance

Hi I have a form called View Courses This form is displayed when the user clicks a button on either the Viewstudent form, or the Searchstudent form. The View Courses form is based on a query, which uses the student ID from the calling form. I have created 2 versions of the Viewcourses form...

Thanks lagbolt. Sort of took your approach. I changed the record source of the subform to a query Then added the following code in the on click event of my add student command button If DCount("[StudentID]", "qryClassesSubform", _ "[StudentID] =...

thanks Zaeed THe problem with your suggestion, is that the user can add student then close the form, reopen form and add student again. (the combo box is based on tblstudents) ANy other help would be welcome Pat

the studentID field on the subform is a dropdown - from tblStudents. The user selects the student from the combo box then clicks on command button to add student hope this helps PS The subform record source is built using the code builder to extract data from the above tables Thanks

I have a main form and subform. based on a query. The main form shows courses/schedules with the subform showing students based on this course/schedule combination. The main form has 2 combo boxes. 1 select course name - (source, query on tblCourses) 2 select schedule - (source, query on...

Thanks pbaldy That was the problem. What a waste of 2 hours Pat

Hi I want to add extra fields to my subfrom (which is a continuous form). I have clicked on record source property in the subform, amended the query to include the new tables and fields, and saved the changes when closing the design window. but the record source has not changed on the...

thanks Rich

Hi I have a main form with several command buttons. When a new record is added to the sub form . I dont want access to update the record automatically. I only want the record Saved when a Save buton is pressed on the main form (This is to allow certain validation on the subform/main form to be...