The difficult I do immediately, the impossible takes a little bit longer.
Data Model ~ Publications...
I originally started this as a demo to show how to handle mulitcolumn reports with images. It quickly became a way to handle Newsletters, Blogs, RSS Feeds and more. So this Data Model has the extra added bonus of having forms, reports and sample data, however, the balance is up to you!
Publications may have a Logo (image)
There may be Subscribers
There may be several different types of Publications
Publications will contain one or more Articles
There can be multiple Articles to one Publication
Articles may or may not have images
Rearranging of Articles because of deletion ot just because it's not wanted
Subscribers may request different delivery options (Frequency of Publication)
Articles can be printed without a Publication
Articles may or may not have Authors
There may be a need to identify Publications by Tags based on Subscribers
Download Sample (Access 2007 or above and an unzipping program needed. Images not included!)
Most of the Error Code is what I call *Lazy woMan's* code (On Error Resume Next). So, you want to make sure you add proper Error Handling!