|
|
Posted by The Great Attractor on 05/20/07 09:07
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. :-]
Navigation:
[Reply to this message]
|