[Rockhounds] Database template?

[Julie Siebel]

Larry - please do send it along to me (assuming it's under 10mb, which I 
think is my current attachment limit).

(In Design View, I'm not seeing an image tool, though I will keep looking.)

>From what I glanced at for 2003, it looked likeya need to set up an OLE link 
if you were doing anything other than bitmaps (.bmp).

We use a program called jpeg wizard, which saves programs at 1/3 to 1/10th 
the size of Photoshop at much higher quality - lol - so that is how the 
pictures would be saved. (I recently was saving a thumbnail out of 
Photoshop - 125 x 85 pixels - because I was in a hurry, and I was IN 
Photoshop. At ZERO quality - ugly/blocky/smeary -  Photoshop saves it as 
26.8k. At NO reduction in quality, Jpeg Wizard saved it at 11k. If you 
actually compress it, you can get it down to 3k with no visible loss of 
quality. At highest quality in Photoshop, it's 42k. Clunky interface, but 
great code.)

Anyway, so it's jpgs we need to save, and I probably should have specified, 
sorry. Still would like to see your DB, though!

Julie

----- Original Message ----- 
From: "Lawrence Rush" <larryrush at worldnet.att.net>
To: "Rockhounds at drizzle.com: A mailing list for rock and gem collectors" 
<rockhounds at lists.drizzle.com>
Sent: Friday, October 24, 2008 2:47 PM
Subject: Re: [Rockhounds] Database template?


Julie: I use MS Access 2000 for my mineral catalog.

Although I haven't added pictures to my mineral records, the instructions
look straight-forward:

In Design View;

Hit the Image tool;

Hit "insert picture"

I would be happy to send you my record format, if it would help. I use 7
fields per record, with 11 entry elements in all.

Larry Rush

===============================================

----- Original Message ----- 
From: "Julie Siebel" <julie at pandemoniumgraphics.com>
To: "Rockhounds at drizzle.com: A mailing list for rock and gem collectors"
<rockhounds at lists.drizzle.com>
Sent: Friday, October 24, 2008 5:36 PM
Subject: Re: [Rockhounds] Database template?


> Well, I'm just trying to figure out a logical sort of format for John. I 
> *have* Access (free from Microsoft for a beta test for another app - lol), 
> but I haven't worked in it much for the last 5 years, because my main 
> client (that's the person kind of client, not the web kind ;) uses SQL 
> Server.
>
> I know that it's possible to display pictures in Access, though I'm not 
> really clear of the "how" of it.
>
> John wants to store a picture, with a mineral name, secondary name/habit, 
> three locations (site, county, state), date collected, date purchased (for 
> purchased minerals), and if it was a trade or whatever, who he got it 
> from. And a "notes" field, of course.
>
> He's not looking for chemical formulas or anything - just a pretty generic 
> DB. I was hoping someone out there had a template that I could just 
> modify.
>
> Thanks,
>
> Julie
>
>
>
>
> ----- Original Message ----- 
> From: "J Bryan Kramer" <codeburner at gmail.com>
> To: "Rockhounds at drizzle.com: A mailing list for rock and gem collectors" 
> <rockhounds at lists.drizzle.com>
> Sent: Friday, October 24, 2008 2:22 PM
> Subject: Re: [Rockhounds] Database template?
>
>
> I don't recall anything detailed about using MS Access there was some
> general talk about databases and someone had written one. I have done some
> Access work(tho it's been awhile), what do you need to know?
>
> BK
>
> On Fri, Oct 24, 2008 at 17:10, Julie Siebel
> <julie at pandemoniumgraphics.com>wrote:
>
>> John was asking me about putting pictures/mineral information in MS 
>> Access
>> (we have Access 2003). He swears there was a long discussion about that 
>> on
>> the list in the past six months, but I can't find it. (I may be being
>> deceived by the email headers - lol - but I *am* searching.) Anyone 
>> remember
>> when that happened?
>>
>> Thanks,
>>
>> Julie
>>
>>
>> --
>> _______________________________________________
>> Rockhounds at drizzle Mailing List
>> Subscription Services:
>> http://lists.drizzle.com/mailman/listinfo/rockhounds
>> List Home Page, with a link to the List Usage Policy:
>> http://www.eclecticlapidary.com/Rockhounds/index.html
>>
>
>
>
> -- 
>
>
> "The thunderbolt falls on an inch of ground; but the light of it fills the
> horizon."
>
>                       Ralph Waldo Emerson
>
> J Bryan Krämer
> North Florida, USA
> photos at:
> http://pbase.com/photoburner
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>  text/plain (text body -- kept)
>  text/html
> ---
> -- 
> _______________________________________________
> Rockhounds at drizzle Mailing List
> Subscription Services:
> http://lists.drizzle.com/mailman/listinfo/rockhounds
> List Home Page, with a link to the List Usage Policy:
> http://www.eclecticlapidary.com/Rockhounds/index.html
>
> -- 
> _______________________________________________
> Rockhounds at drizzle Mailing List
> Subscription Services:
> http://lists.drizzle.com/mailman/listinfo/rockhounds
> List Home Page, with a link to the List Usage Policy:
> http://www.eclecticlapidary.com/Rockhounds/index.html

-- 
_______________________________________________
Rockhounds at drizzle Mailing List
Subscription Services:
http://lists.drizzle.com/mailman/listinfo/rockhounds
List Home Page, with a link to the List Usage Policy:
http://www.eclecticlapidary.com/Rockhounds/index.html