Search results

What I'd be inclined to do is have separate Courses and Students tables. tbl Courses would have say Course ID, Course Name, Seats Available, Seats Remaining tblStudents would have say Course ID, Student Name Then I'd create a Course form with Students as subform linked by Course ID. You...

I'm using DoCmd.TransferSpreadsheet acExport to send data from a form to Excel and would like to be able to format the resulting spreadsheet, eg autofit columns, centre columns etc directly from Access. This code does the basic job of creating a destination subfolder in the folder containing...