Search results

I have an Access application that creates excel spreadsheets and emails them to a number of users. I have a requirement to include an excel macro with the spreadsheet when it is sent to the users, so that when they open the spreadsheet in excel the macro runs and reformats the spreadsheet...

Yes I've joined the two tables, and here's the code I'm using to get the email address: Private Sub Form_Open(Cancel As Integer) Dim rst As Recordset Dim rst2 As Recordset Dim db As Database Dim str_first As String Set db = CurrentDb() Set rst = db.OpenRecordset("data") Set rst2 =...

Anyone fancy helping an old Mainframe dinosaur as he tiptoes his way through access? My problem is this: I have two tables, the first contains username (field1) and a narrative (field 2). My second table contains username (field 1 which relates to username on table 1) and email address. I'm...