Recent content by luapnotro

No, I have another table (just the one this time!) with personal details on each student. The 80 other tables carry details of their daily work and performance - each one referenced by the student ID from the personal details table. Adding a new table is just a few lines of code and I doubt I...

Well, apart from my obvious difficulty in changing the structure of 80 tables instead of one :) what is the advantage of a single table? I'm not duplicating any data by doing it this way and I haven't noticed there to be any added complexity to querying each table as and when required (it's a...

Thanks for that but I was hoping to do this in Access itself - it can't be an unusual thing to want to do with multiple tables. No, it doesn't look like a spreadsheet at all - the tables contain data for 80 students (currently in 13 fields but I want to extend that to 16). I took this design...

I want to add 3 new fields to the structure of around 80 tables (all with identical structures). Is there a way to automate this process? Paul.

I know how to do this but in practice it doesn't seem to work if the Word doc contains images. Is there a way round this or is there perhaps another control available to Access VBA coders which will make it possible to insert .doc files with embedded images? Many thanks!

I'm sorry but my question wasn't about storing the file into a db - it was how to get around the problems of inserting a Word file containing images into a rich text box control or similar. Thanks.

I know how to do this but in practice it doesn't seem to work if the Word doc contains images. Is there a way round this or is there perhaps another control available to Access VBA coders which will make it possible to insert .doc files with embedded images? Many thanks!

I know how to do this but in practice it doesn't seem to work if the Word doc contains images. Is there a way round this or is there perhaps another control available to Access VBA coders which will make it possible to insert .doc files with embedded images? Many thanks!