Recent content by Cameron.Turner

John Big Booty - thanks for the response (which is awesome btw). Any ideas on how I can overcome it without major database redesign?

Hi All, Not sure there is a solution to this one, but I thought I'd ask anyway :) I have a main form with a subform embedded. The parent/child links are all working perfectly. The data inserted into the subform is dependent on selection from a combo box on the main form. This also works...

Hi, Unfortunately, this process has to run automatically. I am a contract consultant and won't be here in a few weeks. It needs to run by itself pretty much so I can't be setting up a process to link files. I was thinking if there was an If statement I could use saying if the file was READ...

Hi David and Dave, Thanks for your excellent suggestions and feedback. Unfortunately, I can't use suggestion #2 (linking spreadsheets) as the users create their own files each week and even though I have provided them a naming convention, they never follow it :). Also, there are just too...

To the hive mind.... I am importing a named range from hundreds of excel workbooks in specific file locations into an Access Database. The code below works fine except when someone in the business has the excel file open. The import function doesn't work because the file is READ ONLY. When the...