I upgraded to 2010 recently, so I wasn't aware of these issues when I built this database as they weren't issues in my older version.
I built this database on my desktop. It is in a folder and has subfolders (30 in total) in the same folder, CVS files are dropped into the subfolders and then imported into tables. I moved the database folder (database and all subfolders) from my desktop to another location (like My Documents), and now it pops up with a message saying
"...location\desktop\loss runs\policy30 refers to a location that is unavailable. It could be on a hard drive on this computer, or on a network. Check to make sure the disk is properly inserted, or that you are connected to the Internet or your network, and then try again. If it still cannot be located, the information might have been moved to a different location."
So it seems like Access has some sort of memory that this is where the file was located, and no longer is. But when I import the information it still works correctly and imports the data. How do wipe this memory or get rid of these pop-ups - and it only does the pop-ups for some of the 30 folders, not all of them...
My second question has to do with skipping blank reports. I have a report with 2 subreports in the footers, where the second subreport may or may not have data in it. I have to export the reports to rtf files, so I need to find code to ignore the blank subreport and stop it from producing a blank page (found code for earlier versions but it doesn't work for 2010 - fail).
Any suggestions are greatly appreciated.
Thanks!