Search results

Thank you JR, I have decided to use your first suggestion and use the Select and Where statement and this works perfectly I have also changed the field name. Thanks again LarryB

Good morning, I have a form button containing the following code to send an email to multiple recipients. It currently reads from a table (tblEmailList) with one field (EMail). The code reads all email addresses using a recordset Dim stSubject As String Dim strEmailAddress Dim...

cheers lad! I'll avail of this treatment next time my brain decides to fail!!

OK I need a slap in the chops!! That works fine. You're a gent! Have a great weekend!

Good morning all. In a form, my aim is to track changes in fields. Once I have a list of changed fields, I'll run code to send an email and list teh fields in teh message body. Email is fine, but I am having problems gathering the data. On update of a field / text box I get an error the...

Good morning all....You can say I'm a novice access user. My background is VBA coding, Access and Visual Basic programming, but that is well over 12 years ago now. Different career paths led me to desktop and network administration. I have been asked create an application in access to pull...