Keeping records of my hosta collection

17 years ago

HI Hostalovers,

Collecting hostas is a lot of fun! Being an hostaholic is a lot of fun!.....going outside on a daily basis to see and admire your hosta collection is a lot of fun! I have started like anybody else by saying to myself that I would limit myself to no more than 100 different kinds...at the most.. ..then I pledged not to go beyond 300 max.... Unfortunately, I have had this 'sickness' for 5 years now and my collection presently totals 557 different named hosta varieties and a total of 880 hostas in my yard. Now that's a lot...for me anyway...being retired and not getting any younger....Beginning this year, I'm taking it more easy....

In order for me to keep and maintain control over my hosta collection, I found it necessary to organize my photos and garden sketches in files on my computer so that I would have a pretty good idea where everything is and how they have developed over the years...and are still improving in size and beauty as they mature. Using Word I have a folder for each hosta variety detailing its characteristics. I also use Excel spreadsheets listing my hosta inventory each year, entering also the size and eyes of each hosta variety on a yearly basis.

Most importantly, I am using Microsoft Access to enter pertinent information on all my hostas. This is my most effecient tool where I can obtain countless numbers of combinations and permutations. I am showing hereafter the way I have setup my hosta database hoping that this may enlighten and help other hostalovers that possess a reasonable knowledge of these software programs. You will notice that some holes have no info, so I would appreciate your help to fill in those 'holes'.

I have copied what is written above from my website where I added a new topic entitled ACCESS DATABASE - SPECIAL PROJECT 2007. There is a lot of information that may help some of you guys...especially if you are a newbie...

If interested please click on the link below. Here's an example of what you will see and read:

Papou

Here is a link that might be useful: Papou's Hosta Database

Sort by:Oldest

Comments (24)

greenguy
17 years ago
I don't know how you do it. I have a hard enough time just keeping up with planting, watering and weeding.
0
ken_adrian Adrian MI cold Z5
17 years ago
key word ... RETIRED .... lol .... ken

PS: pappy ... yeah right.. this is the year you will cut back on acquisition ... like we all will .... lol
0
Related Discussions
record keeping?
Q
Comments (5)
I have no tags but keep a rose book which has a list of all my roses and then other lists saying in which part of the garden that rose is (i.e. front triangle, back rectangle, roses along the slope etc.) In that some notebook I have a list of roses I've discarded, a wish list, a list of what roses I've acquired from which nursery with dates, a list of roses in a public garden that I liked in a climate similar to mine, and any other information I find useful. I have only about 90 roses so this is sufficient for me. Obviously, if your numbers run into the hundreds a more sophisticated approach may be called for.
...See More
Keeping Garden Records
Q
Comments (19)
The simpler the record keeping, the more likely it will be kept up. After several trials, I determined this to be my best plan: Make a folder under 'Documents' on my computer. Put Files made in a word processor into this Folder, each named for a flower bed or garden area. ADD a recent photo of the area in each file. Write a few lines about what I hope to accomplish in this bed and how it looks right now. Be sure to DATE the notes. Make a table with four columns and as many rows as there are plants in the bed. Label the columns: Cultivar - Planted - Outcome - Comments Save the File, return to it as I make changes or remove plants or need to record new ideas. Add pics as the bed changes. Sometimes I make little sketches using 'Paint' just to record where I hid bulbs so I won't forget. All you need is a bunch of little circles and squares. Label them the way that is easiest. Save as a .gif file and insert it the way you add a pic. Everything is in one place for a particular garden area, for reference. Nell For a more elaborate record: Use a Spreadsheet if you're following a budget and keeping up with expenditures, or keeping up with how many hundreds of daffodils and lilies. Use a separate Database if you want to keep up with a large number of different cultivars, i.e. naming all your different tulips and muscari, or planting a dozen different heucheras and dozens of different hostas. The simpler the record keeping, the more likely it will be continued.
...See More
Keeping a photo record of hosta plants
Q
Comments (43)
Jo when you started with hostas and put the "67" after your name, it was a mere blip in time, how long did that last, maybe one week? and you were headed for 100 if I recall correctly. And that may work for you. You have an active life, but you are also compulsive about maintaining your hosta records. Am I right or not? HA,.....I thought so. Now I'm trying to break that hierarchical habit I've had all my life, especially when I was a librarian before I discovered boats and computers. So I like KEY WORDS or TAGS which is so simple a term even the youte of today can understand it. And I am trying to have my files this year posted on Flickr with tags before they upload, but all on my computer or CLOUD are organized by camera file name, by date, and with all sorts of tags--except the ones I need to search with like "gold" or "Solberg" or whatever lets me find it in response to someone's question on this forum. In the end, we all have to know WHICH hosta fulfill certain attributes. I don't rely on an outside service (like Flickr) to be a forever solution to my photos. OH no. I went through Webshots folding up and turning into an observer site only, lost my photos from there. Then I had an external harddrive fail on me. So I'm pretty concerned about keeping the pictures themselves. It's a fun thing for me. I can sit here and immerse myself in viewing the pictures I took, refresh the mental notes I made to myself about who was who when they had missing names. I'd check the past photos. It works for me. And that is one reason I take pictures with more than one hosta in them. If I lose the nametag, and I know who it's neighbor is, then I look for the picture of the known neighbor, and voila, I see who the would-be NOID is. That is also why I try to identify all the hosta in the photo too. Does anyone else watch their photos as a full screen slideshow? Do you say the names of the hosta before the slide changes? And for those you missed, do you go look at them next day to see who they are? Well, I do that. Seems to me you could put it on a manual slideshow, so you can play NAME THE HOSTA at your next club gathering, or your family gathering if everyone is into the garden thing. I'd play it. Lose, probably. Except where my own personal garden comes in. I'm getting much better. I think watching the slideshow helps a lot. Okay, now that really wasn't off topic was it? It simply says how I use my indexing. ;)
...See More
Plant Record Keeping
Q
Comments (25)
Thanks Les, Nance & Steve :) The photos are a mix of my own photographs and some off the internet. If I buy a bigger plant, I will use my own photo, but if it is a very young plant, I'll use one off the internet. No particular source, I look at several sites and pick my favorite photo. As far as learning Excel, I'm kind of self taught. Several years ago, when I had never used Excel before, my boss forwarded me an email with an Excel attachment. The document was a series of statistical pie charts & line charts. She said "you're doing these from now on" and that was all the direction I was given. So I basically dissected that spreadsheet and played with it until I could figure out how she created those charts. It was a great learning experience. Now I use Excel for everything! One of my most important Excel documents is not garden-related. I'm 49 and my memory isn't always reliable ("didn't we just buy that refrigerator?"), so I created a spreadsheet "Important Events & Purchases". I keep a tab for each year, and document all of our major purchases, like appliances, cars, etc. along with purchase price. Other columns include home improvement projects, vacations, health issues , and events (such as weddings, deaths, new jobs, etc). Yeah, I love Excel, lol. Wendy
...See More
Related Professionals
Avocado Heights Landscape Contractors · Addison Landscape Contractors · Broadlands Landscape Contractors · Gaithersburg Landscape Contractors · Vashon Landscape Contractors · Wentzville Landscape Contractors · Raytown Landscape Contractors · Randolph Driveway Installation & Maintenance · Asheville Fence Contractors · Bellmawr Fence Contractors · El Monte Fence Contractors · Kuna Fence Contractors · Millbrae Fence Contractors · Carson Solar Energy Systems · West Jordan Solar Energy Systems
ken_adrian Adrian MI cold Z5
17 years ago
i forgot to mention ... the older cultivars... e.g. abby, big boy etc .... might be covered in the original schmid tome ... in the big section in the back ....

good luck

ken
0
sidney1515
17 years ago
WOW! Nice job!

Cut back on your acquistions? hohohohoho
I have found a way around that part. I'm not making that promise till all my mail ordering is done. . .less guilt for the rest of the year that way. . lol

Sidney
0
bunnycat
17 years ago
Outstanding! So much better than my 4x6 index cards. (snicker)
~Bunnycat
0
greenguy
17 years ago
Yea cut back lol I remember when you said you would be finished buying hostas how long ago was that three years lol

you know you have to get that new one and the other you have been thing about for awhile and the one that was hard to get and ............................
0
papou
Original Author
17 years ago
So true, Greenbuy and Sydney...I admit...I AM AN HOSTAHOLIC!!
This time however...it's my DW that is putting a stop to my fouly. She thinks I'm going overboard....well...we'll see...

Ken, Thanks for the tip re. Schimdt Book.
0
ken_adrian Adrian MI cold Z5
17 years ago
'going overboard'??????

that happened long ago .. i think she is throwing you a life jacket.. grab hold.. you DONT need them all .... ken
0
papou
Original Author
17 years ago
Ken...you're my man! LOL...

I shall obey DW Therese...as a good hubby should do! HOWEVER, if ever in the future she comes to me saying: "Oh, honey, I just saw the most beautiful hosta..we dont have it...will you buy it???...then I shall stand firm and answer: NO!! If she insists, I shall say again: NO!!...and if she insist a third time, I shall say to my beloved wife: "Well, perhaps..."

Papou
0
maidofshade
17 years ago
Nice job. I am trying to do this too but can see myself getting behind as the weather warms up. Once again you are the well organized hosta man!! I just love looking at your website but have to watch out for temptation when it comes to seeing plants in person. I am trying to be good but there are just too many beautiful well grown plants to inspire purchasing more and more. It sounds like your wife just may have some hosta blood in her too. Are you sure you will say NO twice before giving in???????
0
creature
17 years ago
I, too, keep a much smaller record. But one thing that I include is when it starts to come up.
0
greenguy
17 years ago
ken i never thought i would hear such words from you
0
papou
Original Author
17 years ago
maidofshade, You say it correctly: there are so many new hostas out there....and like Ken says: "You dont have to get them all"...as for me, I only buy the "must have" ones....the rest is history....-:)
I went back to school 3 years ago to improve my knowledge of Microsoft Access....it takes a very long time to enter the data in Accessm but once it is done, it's well worth the effort and time.

I may add here that my digital camera has become an indispensable tool. I take hundreds of pics each year and the good news is that it costs nothing....if I don't like a photo, I simply delete it. Lately, I have made a folder of my best shots during 2006...burned approx. 800 pics on a DVD-CD. Once in a while I put that CD in my DVD Player and watch the slideshow directly on the TV screen. Not only is this satisfying to me, but it also help me memorizing the characteristics of my hostas.

Papou
0
blacky1
17 years ago
You're unreal Papou, but I love it. So many great ideas about naming hostas and keeping a journal. Is Microsoft Assess and bundle by itself or does it come with something else? I currently have Microsoft Works and I'm thinking of upgrading to Office.

Lynne
0
User
17 years ago
WOW. The database is impressive...and I thought I was doing a good job with my MS Excel spreadsheet which holds a lot of the same information and some parentage/hybridizer info. However I cannot really manipulate the info the way you can Papou. Nice Job!
0
papou
Original Author
17 years ago
Lynne, If you upgrade to Office XP, everything is in there...Word...Excel....Access...Publisher...and lots more.
Hostabuff, I encourage you to try Access. I used to limit myself to Word and Excel...thinking that Access was beyond comprehension...you know what?....if you can manipulate Excel, you can work with Access...and you dont need to follow a special course...go to Help and it tells you what to do...
Give it a try! If you do and need help, please email me and I shall be glad to help you.

Papou
0
mctavish6
17 years ago
papou, your organizational skill are inspiring. You must be a virgo or have strong virgo influence! I have not a drop of virgo unfortunately. I suppose it's made up for somewhere else - ha! I think if you have grass, you have room. I intend to widen the garden around my lawn (and cut down on the lawn) this year. This will be about 6-12 inches surrounding a 10 x10 lawn. As the lawn gets smaller, I will want only to be able to put 2 chairs there and smell the grass when I cut it. McT
0
User
17 years ago
As I scrutinized each of my little seedlings...waiting for some characteristic to pop out that I can't see now, I was thinking...the Access database could be very helpful in the hybridizing process...
0
Lykaon - Ohio Zone 6a
17 years ago
Access has tons of 'Wizards' that can help you along as you are learning. You can pull something off like Papau's database with only minimal self-training and the use of the help sections.
0
papou
Original Author
17 years ago
Lykaon78, Thank you for email invitation. I'm putting your name in my "Resource Persons" file. It's good to know that you use Access in your professional life. I still have to know more about the Queries...and how you do it. Right now, I limit myself to the binocular on the top toolbar.

Papou
0
megaul
17 years ago
papou,

You are, have been, and continue to be, an inspiration here in Hostadom.

Your organizational skills and photography are legendary in my hosta mind. I aspire to be a fraction as knowledgeable and talented as you.

Thank you and please continue. We need you expertise.

:-)Marsha
0
papou
Original Author
17 years ago
Marsha, Thanks for your compliments....Hey dont forget to enter your top 10 favorite hostas on my other post. The survey is going real well...and is being done at the same time as a similar survey on Hallsons Gardens (Chris Wilson website).

Papou
0
hagey
17 years ago
Papou,
We like your version of record keeping. We have a similiar one but not as much info and I have some questions on the way we set ours up. I would like to ask some questions and wondered if I could e-mail them to you? We have recently lost some of the XP and were told we needed to replace it. We wondered if perhaps you would tell us what we need to buy as Ron wondered if our Microsoft XP is what we need or replace it with an updated version?
We have 770 varieties of hostas listed on spreadsheet but it will not print on landscape. We tried to save it to a disk and it will not let us do that. That is why the repair people told us to rerun the XP. We are not at home until after next weekend, and our disk is at home.
Your help will be greatly appreciated. Betty
0
papou
Original Author
17 years ago
Hi Betty,
First of all, your platform Windows XP SP2 is just fine. Windows Vista just came out but I would not buy it yet as it may have a lot of bugs...wait a bit...at least this is what I'm going to do befor switching to Windows Vista.
More importantly is your Office package. From Office 97, I have upgraded to Office 2000, and last year to the latest Office XP.That seems to work fine with me.
You have a lot of hostas. WOW!! 770 is a lot. It may be that you have reached over the limit that your blank CD can handle. Let's pursue this privately if you dont mind. My email is ghislain@hawk.igs.net
The last CD that I burned took 550megs. If we exchange coordinates, we could possible send each other our CD backups. Hoping to hear from you.

Ghislain Seguin (Papou on Garden Web)
0

Keeping records of my hosta collection

Comments (24)

greenguy

ken_adrian Adrian MI cold Z5

Related Discussions

Related Professionals

ken_adrian Adrian MI cold Z5

sidney1515

bunnycat

greenguy

papou
Original Author

ken_adrian Adrian MI cold Z5

papou
Original Author

maidofshade

creature

greenguy

papou
Original Author

blacky1

User

papou
Original Author

mctavish6

User

Lykaon - Ohio Zone 6a

papou
Original Author

megaul

papou
Original Author

hagey

papou
Original Author

COMPANY

BUSINESS SERVICES

GET HELP

CONNECT WITH US

Keeping records of my hosta collection

Comments (24)

Related Discussions

Related Professionals

papouOriginal Author

papouOriginal Author

papouOriginal Author

papouOriginal Author

papouOriginal Author

papouOriginal Author

papouOriginal Author

COMPANY

BUSINESS SERVICES

GET HELP

CONNECT WITH US

papou
Original Author

papou
Original Author

papou
Original Author

papou
Original Author

papou
Original Author

papou
Original Author

papou
Original Author