Posted by The Great Attractor on 05/22/07 08:58

On Tue, 22 May 2007 00:56:54 -0400, "Doug MacLean"
<Webmaster@Hometheaterinfo.com> wrote:

>
>"The Great Attractor"
><SuperM@ssiveBlackHoleAtTheCenterOfTheMilkyWayGalaxy.org> wrote in message
>news:gi3053d27ogeoin8880akaog9ju04phch7@4ax.com...
>> On Fri, 13 Apr 2007 17:26:46 -0400, "Doug MacLean"
>> <Webmaster@Hometheaterinfo.com> wrote:
>>
>>>"MassiveProng" <MassiveProng@thebarattheendoftheuniverse.org> wrote in
>>>message news:mgcp13tcmcdtqnr7549k371pu8cu25hfrt@4ax.com...
>>>> On Wed, 11 Apr 2007 01:46:35 -0400, "Doug MacLean"
>>>> <Webmaster@Hometheaterinfo.com> Gave us:
>>>>
>>>>>"MassiveProng" <MassiveProng@thebarattheendoftheuniverse.org> wrote in
>>>>>message news:inbo13pkpmppio338v1a92qf5duedgfaoa@4ax.com...
>>>>>> On Tue, 10 Apr 2007 15:07:04 -0400, "Doug MacLean"
>>>>>> <Webmaster@Hometheaterinfo.com> Gave us:
>>>>>>
>>>>>>>Always glad to help out in any way I can. If you need any assistance
>>>>>>>in
>>>>>>>setting things up on your side please just give a shout and I'll do
>>>>>>>what
>>>>>>>you can.
>>>>>>
>>>>>>
>>>>>> Do you happen to have an Access front end or template for one that
>>>>>> you could also post on your site? (or did I just not look hard
>>>>>> enough?) :-]
>>>>>
>>>>> I do have the schema listed online if that would help. It lists the
>>>>>particualrs of the main and new/change tables
>>>>>
>>>>>http://www.hometheaterinfo.com/schema.htm
>>>>>
>>>>>Let me know if this helps.
>>>>>
>>>>>Doug MacLean
>>>>>http://www.hometheaterinfo.com/
>>>>>
>>>>>
>>>>>
>>>>>
>>>> Thanks. I'll be sticking with the excel sheet and access, since MS
>>>> allows use thereof.
>>>>
>>>> I was hoping for something like "Movie Library" from cd software
>>>> solutions, but I won't be paying that turkey $40 for it!
>>>>
>>>> He allows front cover images and whatnot, and it is supposedly an
>>>> access based database.
>>>>
>>>> Heh! Maybe I should take your baseline schema and write one, and
>>>> give you the template for it to critique and put on your site if
>>>> worthy... :-]
>>>
>>>Sure, I'm game.
>>>
>>>Doug MacLean
>>>http://www.hometheaterinfo.com/
>>>
>>
>> Doug,
>>
>> I found a way to get your entire database in one reference, without
>> having to split it up into two sheets.
>>
>> Problem is, the only way I could get it to you is to post it in a binary
>> group like alt.binaries.misc, which is a public posting.
>>
>> It is 31MB instead of your 28MB.
>>
>> The key thing now though is that the first sheet is a lookup table
>> where one ID is put in, and all the data auto-fills.
>>
>> I could not get this to work in Access, but I am not a big Access guy,
>> or it would likely be easy.
>>
>> I also want to add a field where an image of the disc auto-fills in an
>> area set aside for that purpose. I left such an area, but as yet am
>> unable to get the auto-fill feature to point to an image file.
>>
>> Let me know if it is OK to post it, and I will arrange a date to do so
>> where you will be ready to download it from the Usenet group I put it
>> into. Otherwise, I can post a screen shot of the auto-fill page, and
>> maybe entice you a bit. :-]
>
>Let me take a look at it and we can talk about it off line. Can you email me
>the details?


Well... I'd have to set up an email account for that specific purpose
as I do not give out my email addy very often... at all.

I also posted a second pic, as I have a VB macro enabled sheet that
places a pic of the DVD cover on the master page.


For your weekly updates, do you merely add them into the spreadsheet,
and then sort the sheet on the titles field?

[Back to original message]