|
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?
Navigation:
[Reply to this message]
|