Search results

Many thanks for this - I am investigating permissions as logging in as that account is requesting access before each email which is not feasible, our IT department have this locked down so I think permissions may be the way forward.

Hi, is there a way to send the email from another email account/address with this code? All references i find seem to refer to olMail. Option Compare Database Option Explicit Private Enum InitialWindowState wsMaximized = 0 wsMinimized = 1 wsNormalWindow = 2 End Enum Public Sub...

I think I did! - Fantastic! I really can't thank you enough for all of your help on this - it works perfectly :D Thank you also for attaching the database to - complete life saver :) Jane

The email looks fine. It has the variable module code and title at the top with the additional letter text I added it just adds only one records where there ar multiple:- Module Code: AA0126 Module Title: Developing Knowledge and Skills within Adult Nursing Care Dear Jane, We have received...

Sorry correction, the records with same email address are not added to the email sent - only one record. In my test query I have 4 records with 2 emails but the email only picks up one record - the loop does not seem to pick up the other record with the same email address. I followed the code...

Hi Frothingslosh, Many thanks for the above. I have now applied this to my command button and successfully calling the module. The email sends but when delivered i see that it has only picked up one record i.e. module title and module code with the first email, it does not pick up the other...

I really dont know how to apply this code using a command button on a form, I just get errors - could you tell me how Frothingslosh?

Hi Frothingslosh I have been going through this code, must confess - I have never heard of air code before. You are right, this is a complex code. I have pasted the code above into a new module which separates the code. Does this code operate differently? I have a command button on a form -...

Hi Frothingslosh, wow that's some code - I am going through it and will come back :)

I would really appreciate your help on this Frothingslosh :)

Hi Mark, Frothingslosh Many thanks for your replies I really appreciate you taking the time to help, you are both so right. I need to rethink code as now this is sending separate blank emails :( I can't seem to find anyone who has cracked how to achieve this. I'll take on board all you...

Hi Frothingslosh I really appreciate your help but confess to making a terrible mess of this as I keep getting an error on part of the If that I added "Compile Error Exit For not within For..Next. Have I misunderstood where to put these elements? Private Sub TestEmail_Click() Dim dbs As...

Hi I know this is an old thread but I am trying to achieve a similar task and I too am struggling. I get a Run-Time Error '3021' No Current Record Found I know there is an issue with the Loop but I am stuck - can anyone help me with this code? Private Sub TestEmail_Click() Dim dbs As...

thanks namliam! :D

Hi namliam but could yo help further, I am really struggling to understand how to apply this in a query. I copy the sql from the query SELECT Master.Username, tblEmployees.lngEmpID, tblEmployees.strUsername, tblEmployees.strEmpName, tblEmployees.strEmpPassword, tblEmployees.strEmpForm...

Thanks namliam, your absolutly correct - my DLookup did not return a result. Maybe the query is the better route. I have the SQL from the Query as you note below. I will try what you suggest to see if I can get it to work. thanks!

Thank you namliam and pr2-eugin for coming back to me. I was looking for a way to cross reference between two tables. The Master table logs the computer user, this username is also in my employees table which I use with the login form. Someone on this forum suggested using a nested Dlookup to...

Hi I wonder if anyone can help, I have been staring at this for so long. I just can't see where the missing operator is. Username, strUserName and strEmpName are all text fields. I keep getting the error message Fun-time error '3075' Syntax error (missing operator) in query expression...

Many thanks, I will give that a go!

Hi Wonder if anyone can offer any advice on this one? I get an error "update or cancel update without add new or edit" which seems to point to this code. I really can't see why, can anyone see what I am missing? I am using MS Access 2010. Private Sub Form_BeforeUpdate(Cancel As Integer)...