|
|
Posted by Doug MacLean on 05/29/07 04:49
"The Great Attractor"
<SuperM@ssiveBlackHoleAtTheCenterOfTheMilkyWayGalaxy.org> wrote in message
news:nvb553di4b78iqec68nl4e0rj7kqb53j5n@4ax.com...
> 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?
Updates are done at least once, often twice a day. This is all done in a SQL
backend and exported into the spreadsheets so it is new with each update.
--
Doug MacLean
Home Theater Info
http://www.hometheaterinfo.com
Navigation:
[Reply to this message]
|