Photo by Melody

Upper Midwest Gardening: Organizing & Documenting *my* Seeds and Plant Info

Communities > Forums > Upper Midwest Gardening
bookmark
Forum: Upper Midwest GardeningReplies: 199, Views: 344
Add to Bookmarks
-
AuthorContent
julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
3:21 PM

Post #1926526

The subject of using spreadsheets and databases for keeping information about seeds and plants came up in another thread here in the UMG forum. I'm adding my contribution to that discussion here so as not to hijack the other thread. LOL

First a little on the history of the "why" I did it and then I'll show you a bit about the "how" and what the results are.

"Chapter One"
(I'll let you know when my 'chapters' are ready for comment...ok? In the meantime, you can read but please don't post any comments here until I'm finished. LOL I'm "creating" and can't be disturbed. HAHAHAHA)

'Chapter One'
Gardening is not a recent addiction for me, I loved flowers and gardens all my life. But it was only after a 'forced' retirement that I found myself with time enough to actually get into it. With the circumstances being that I'm too old to make the same mistake more than twice (LOL) I needed to keep track of gardens. That meant I wanted to know what plants and/or seeds I'd tried to grow, where I got them, what specific needs they had and how could get *more* of them in the future?

I started out by trying to keep paper notes, then I tried paper notes in an electronic form. I tried desperately to locate a commercially available gardening planning/planting/plant info piece of software. I bought several and each time I opened them and tried working with them I got frustrated. All I could think was "This is SO lame...if I had written this, I would have made it so and so...(easier to use/have better or more complete info/ give the user more options to change field or add field names/ and make it simple to add photos)."

I'd been working with databases in my old job for 20 years...(Yes, Stacy...that means I go back to the age of D=dinosaurs, DOS and Dbase! LMBO). I didn't really *want* to sit back down at my desk for the all the hours I knew it would take to write the program but I kept thinking how much *easier* it would be on me if I had the ability to search records and filter them according to my current curiosity.

Finally, last winter - after spending a LOT more money than I care to admit, I sat down, wrapped my head around the project and developed a user interface that fit *my* needs and *my* level of gardening expertise. In other words, I built my own *house*. hehehe

With that said, I have to give credit where credit is due. NO house is built entirely without building upon the efforts or *knowledge* of others. My house was built on the work of Tom Clothier and his "Germination Tables". http://tomclothier.hort.net/

Before I began thinking in terms of developing my own database system, I used Tom's gracious offer to download his database. (You can find that resource here: http://tomclothier.hort.net/page48.html ) From there I put my brain to work, imported his info into a flat database table in MS Office's database 'Access'. (Note: 'Access' is a part of MS Office but usually isn't bundled in the Office package and has to be purchased seperately in most cases.)

It didn't take me long to realize that I had more information that I needed/wanted access to than Tom had included in his, basically, seed germination database. Little by little I added more 'stuff', made the user 'front end' friendlier and based more on the way *I* liked to use a database. I wanted pictures, web links, space to write my own notes, I wanted to know if...well...I wanted the most *complete* source of information I could come up with.

Results of the endeavors will be added a bit later.

~end of Chapter One~

~Beginning to write Chapter Two - The difference between a Spreadsheet and a Database ~


julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
3:39 PM

Post #1926543

Chapter Two
~The difference between a Spreadsheet and a Database~

A couple of people have asked what the difference is between a spreadsheet and a database.

LOL

The difference for me is that I *hate* working spreadsheets! I've seen a lot of people who use spreadsheets to keep their records but I've figured out how to make them behave the way *I* want them too. I can't tell you how many times I've tried to rearrange info in a spreadsheet (Using commands similar to those I'd use in a database) only to find that I'd completely and totally destroyed the structure and voided ALL connecting information. ("Aw GEEZ...I *did* it again!" All to often!)

Anyway, without going into the "technical" differences between the two, I'm just going to say that at the very beginning of my 'real world' job of keeping an enormous number of records documenting manufacturing projects (Vendors, purchase orders sent, rec'd, invoices processed and paid), and not having a corporate office to guide me, I had no choice but to learn to do *something* that made my 'one woman' office run the best it could. And still give corporate the information *they* needed.

A database was the only thing I about at the time. And besides, spreadsheets reminded me of numbers (accounting :-O), and numbers scared me to death! LOL So I never bothered to LEARN how they worked or why.

~that's the end of THAT~
LMBO

~writing Chapter Three - The Screen Captures~



julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
3:47 PM

Post #1926550

(C3-section one - The opening screen)
When I open my database, I have a 'switchboard' screen where I can choose which area of the database I want to work in. (I have a part of the database that alows me to enter an index of sorts for magazine articles, tv shows, and other info I collect). Most of the time, I go directly into my plant database main form. This is what I see:

(C3-s2 in process)

Thumbnail by julie88
Click the image for an enlarged view.

julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
3:54 PM

Post #1926558

C3-s2
This screen is the first record of my entire database...it's the one that lets me stay cool and collected and presents me with little more than the basic structure and a few hints of what info I want to enter or what I'll see when I get to the plant/seed I'm recording or looking up.

Database opening screen:
(C3-s3 in progress)

Thumbnail by julie88
Click the image for an enlarged view.

julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
4:07 PM

Post #1926583

I haven't mentioned it yet, but there is a system of "Tabs" to the right of the plant photo...each tab holds a different type of infomation.
jsr notes = My own notes on what I consider "important" or "Must see"
General Info = All the specifics (zone hardiness, exposure, etc)
Prop-Seeds = Tom's Germination tables, mostly
Prop-Other = Other methods of propagation for THIS plant
Abbreviations = My code key for various fields
Suppliers = Web Links for vendors
Info Links = Web links for *really* good gardening info
TBA = To be announced (Just another way iof saying "Im not done yet" LOL

C3-S3 ~The General Info Tab~
Here's is the infomation available to me for this particular Achillea cultivar.

(C3-S4 in process)

Thumbnail by julie88
Click the image for an enlarged view.

julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
4:17 PM

Post #1926591

C3-S4 ~ "Prop - Seeds" Tab

On this tab I find (mainly) the info I imported from Tom Clothier's database, with a few little extras of my own. (You'll also notice that I have left programing notes to myself. hehehe) Plus, there's a working link on this tab that takes me directly to TC's web site so I can get to his other articles and information quickly and easily.

(C3-S5 in progress)

Thumbnail by julie88
Click the image for an enlarged view.

julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
4:21 PM

Post #1926597

C3-S5 ~ "Prop - Other" Tab

If I had info on various methods of propagation other than by seeds, I'd enter it on this tab.

(C3-S6 ~"Info Links" Tab in progress)

Thumbnail by julie88
Click the image for an enlarged view.

julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
4:23 PM

Post #1926600

C3-S6 ~"Info Links" Tab

This the tab where I "store" my most used resouces for plant and gardening information.

Thumbnail by julie88
Click the image for an enlarged view.

julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
4:26 PM

Post #1926603

OK...Now, I'm finished with the uploads I wanted to keep together in sequence without much in the way of comments from myself or (hopefully) you guys. LOL

I'm going back now to edit out all the "in progress" remarks and will come back to add the "Chapter 4 ~ "What I can do with my database information that makes it worth the time and effort".

NOW, I'll let you have at it. LOL

~julie~
julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
4:27 PM

Post #1926604

Reserved for CHAPTER 4

~julie~
jasmerr
Merrimac, WI
(Zone 4b)

December 16, 2005
5:05 PM

Post #1926665

Julie,

This is great! I haven't had time to really look at it carefully, but I sure will.

Jody
julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
5:06 PM

Post #1926667

Jody...glad you came in...and thanks bunches!
~julie~
Anitabryk2
Long Island, NY
(Zone 6b)

December 16, 2005
7:23 PM

Post #1926808

way cool - Gave me some wonderful ideas! I love it. I can also tell it took alot of time. How long did it take you? Now, you mentioned that you downloaded Tom's db..but it wasn't like this? What you are showing us is your 'baby', correct?
Anita
Erynne
Hillsburgh, ON
(Zone 5a)

December 16, 2005
7:57 PM

Post #1926833

Julie,
Looks and brains! Do you have any idea how dangerous you are? LOL!!
You are so organized and well, you got me impressed! I'd be mighty embarrassed to show you my note-keeping; a binder with a bunch of scrawled info.

Awaiting chapter 4!

Erynne
julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
8:38 PM

Post #1926873

Anita, Thank you! I hope I *did* offer some good ideas with my database.

Now...to your question about basing my database on Tom Clothier's material.

If you download one of those databases on Clothier's site, you'll get *all* the seed starting info. (That's where the info you see in the pic in part C3-S4 post above came from.) I think he has two versions up there. One is 'comma delineated' and I *think* he has one that will import into the MS 'Works' software...but don't quote me on that. I used the "comma delineated" information and just imported it into a new Access database. At that point, all that my database had in it was a table with the information...and it would look very similar to your Excel spreadsheet.

Yep! What you're seeing is entirely *my* baby. I added the GUI (graphic user interface) because, for me, it was so much easier to "see" the information at a glance. And that "At a glance" characteristic is why I added the "Tab" system feature. I just hate being unable to quickly spot exactly what I'm looking for. At the same time, I don't like being inundated with more info than I need at the moment.

How long did it take me to design and build the application? You've got to kidding! LOL I'm STILL working on it! Seriously, It was up and running in a couple of weeks. But it only took me that long because I wasn't sure what I wanted to *do* with it in the beginning. Stacy will back me up on this, if a person wants a database built they'd better know *what* they want it to do before they start. LOL Otherwise, you'll end up with a lot of mistakes BUILT-IN that can't be easily undone later. (Just ask me HOW I know that! hehehe)

And there's *my* ARIANNE! LOL
You're so funny. "Brains and beauty" HA!! (Ok, so I added the 'beauty' part...I needed a 'lift' today.) And as for being 'dangerous'. LMBO I'm only dangerous to myself...just ask my DH. hehehe

For your information, ANY notes or scribbles that can be rummaged through sometime in the future (and made sense of) are far better than nothing at all. Geez...when I first started taking 'notes' on how long it took Morning glory seeds to germinate in the middle of June, I was using Post-IT notes...and sticking them to anything that stand still. (I'm still finding those notes in the bottoms of cell-pack trays. :-D

Sweetie...I'm not organized...I just like to pretend! LOL And looking inside my database gives a feeling that I *really* do have things under control (but *I* know better! ~evil grin here~)

Chapter 4 will probably come sometime tomorrow, when I have time to "think" again.

Today, I got more cookies baked and packed up, and made two batches of homemade Pizza dough (along with getting a gazillion phone calls, doing regular chores, and fending off the DH trying to get me to finish decorating the Christmas Tree. (I think he's tired of tripping over the boxes I've got strung out all over the place. hehehe)) Yep! Sure...I'm organized. If I were organized, I'd be having *someone ELSE* doing it all for me. :-D

~julie~
sarv48
south of Grand Rapid, MI
(Zone 5a)

December 16, 2005
10:05 PM

Post #1926967

Julie would you jump across the lake and do mine for me???? Pretty please...computer things just buffalo me. I write everything in a gardening notebook, but usually lose it and start another one. I have several floating around the house. I'm impressed...
julie88
Muscoda, WI
(Zone 4b)

December 16, 2005
10:14 PM

Post #1926979

Thanks Sarv! That's a special compliment coming from you. (i'm glad you didn't say "jump IN the lake" LOL)

~julie~
momof2d
Des Moines, IA
(Zone 5a)

December 17, 2005
9:55 AM

Post #1927595

Julie thats mighty impressive, with that information you could almost start your own gardening /plant business. Very nice! I'm not even as organized as keeping a 'paper' journel but I think I'll try this summer so my children and grandchildren can see what takes up so much of my time.
sstateham
Rockford, IL
(Zone 4b)

December 17, 2005
12:05 PM

Post #1927655

I will back Julie up (as requested) on knowing what you want before you build a database. Since all the tables have to relate to each other, and the forms and fields relate back to the tables, if you don't really think ahead you can end up with a lot of "undoing" to do.

Julie - I'll D-Mail you. I just have to get that database to play with. Fantastic job!!
julie88
Muscoda, WI
(Zone 4b)

December 17, 2005
12:39 PM

Post #1927681

momof2d...thank you. I've often given thought to doing just that. Having a business working with plants has never seemed like "work" to me. And if I did start a business, the very first thing I'd do is rewrite my database to include modules that would make my paperwork easier.

Stacy...LOL...I kinda thought you'd react that way. LOL And I knew you'd understand all the relational aspects of designing a database like this one. And as for the "undo-ing" (hehehehe) I *never* get around to doing that part! I just live with the extra queries, and reports and forms...LOL...to scared to delete them for fear I take some necessary links out at the same time. LMBO

Got your D-mail...will answer it now. Oh, and THANKS!!

~julie~
Equilibrium

December 17, 2005
12:45 PM

Post #1927698

Totally impressed! Jaw hitting keyboard!
julie88
Muscoda, WI
(Zone 4b)

December 17, 2005
12:54 PM

Post #1927710

~grin~
Pick it up 'Lib'...you don't look your best from that angle. LOL

Thanks SO much!

~julie~
Equilibrium

December 17, 2005
2:08 PM

Post #1927785

Are you aware that you could program drop down menus in to that? Example would be for sources. Let's say I buy most Tall Pitchers from Sarracenia Northewest but sometimes I buy them from Dangerous Plants. I have seen software where once you add the name of a nursery, you can select if from an alphabetized drop down menu or add a new nursery the next time you add a plant. That's kind of a neat function. I don't know if you would be interested in something like that but it would be cool. Come to think of it, you can use drop down menus for anything from zones to type of plant. I've also seen where one can sort by plants based on their common name or the Latin name or plants beginning with the letter a or plants that flower white or plants that are on a wish list, etc.

I'm not computer literate by any means and can barely fill in the blanks at times so how do I know this... I paid somebody to create a program for me to use. She never finished. She went off and got married and to be quite blunt after looking at what you've created... she wasn't as good or as thorough anyway. Story of my life, I paid for something that is incomplete. I have her work saved to my desktop. If you would like, I could forward it to you and you could see if she came up with anything that might interest you. She did have a drag and drop feature in what she created for photos which was nice. Just D-Mail me your regular e-mail address and it's yours if you even want it.

Lauren
julie88
Muscoda, WI
(Zone 4b)

December 17, 2005
3:11 PM

Post #1927849

HI Lauren...yes, I know that drop down menus can be programed into most fields. I didn't use them because I because I wanted the flexibility to enter the info as I wanted it...or even skip entering anything if that's what I chose to do or didn't have time.

The links for the suppliers was one of those "afterthoughts" placed on a tab-card just because I wanted to be able to *know* the links were easily available when I could think of the name of the company or find the danged link in my browser. hehehe


You have D-Mail!

~julie~
Equilibrium

December 17, 2005
3:40 PM

Post #1927873

Hey Julie, it's been a few months since I even looked at what she did because... why bother... she never finished but, the fields that had a drop down menu didn't have to be filled if you didn't want to. It was one of those automatic type deals. If you bought say different plants from the same online nursery, you could enter one plant and the information for where you bought it and then by the time you moved on to adding the second plant, you could just click on the online nursery and it would prefill the space. The only time you had to add information was when you purchased from a new source. And, you could leave the field empty if you wanted to just skip adding anything. It was sort of neat because you didn't have to re-fill the name, address, phone number, fax number, url and all the other goodies if you didn't want to because after you did that once you never had to do it again whenever you bought a plant from there. I also liked that feature because I could store info on people who sent me gifts and such. It would have been nice to receive a plant and be able to go right into the file to click on their e-mail address and be able to hyperlink right then and there into my e-mail to send them a thank you. I don't know if she got to the hyperlink to websites or the projection into an e-mail client but she was working on it or had worked on it. I am really totally computer ignorant and all of this is waaaaaaaaaaaaaaay over my head.

I'm trying to think of anything else she did. Oh yes, she was working on allowing me to change the background field to a color or to a muted soft pastel image. I don't know if she ever got that far.

I'll go and get the application over to you. Heck, use anything you want for yourself because what's there is bought and paid for by me so I don't care. And, it is in Access!
julie88
Muscoda, WI
(Zone 4b)

December 17, 2005
4:17 PM

Post #1927924

Lauren, if the module hasn't been "locked" I can change all those things for you. Don't know for sure if I can put a live link in the drop downs or not...never tried it. And I'm not good at integrating my DBs into feeding other progs (like the email client). But I *can* tell you how to change your color set up if you'd like. (As I said...IF the module hasn't been 'locked')

I'm looking forward to seeing it! Thanks for the offer!

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

December 17, 2005
4:49 PM

Post #1927983

O.K.,,,Now I'm Feeling *Really* Stupid,,,

I'm one of those *Geeks*,,,LOL that Love working with Databases and Spreadsheets. However this is getting Way too organized for me,,,ROFLOL,,,

Julie,,,
Now I *Know* why you haven't been around the Garden much lately,,,you've been working your fingers and brain way too much with this cool database,,,it's awesome.

Now I am feeling *Really Guilty* about just winging it and may have to *Try* to organized,,,LOL

Kelly
julie88
Muscoda, WI
(Zone 4b)

December 17, 2005
5:11 PM

Post #1928031

Uh...what do you mean "Way over your head?" tsk tsk tsk...I don't think so! LOL

Kelly, building up this database was the only way I had of staying sane last winter after I'd finished the Winter Seed Sowing. I'll tell you how bad it really was. DH gave me the entire set of Garden Gate back issues (9 volumes) for Christmas last year. Would you believe that I actually scanned in the indexes for each year and manually entered all but the last 3 into my database? How's that for being bored out of my mind? (I had to stop when I had my cataract surgeries and couldn't see the fine print anymore...so they still aren't completed.)

About you getting "organized". Are you *sure* you want to *do* that? LOL Organization is highly overrated. :-D

Thanks for the compliment!

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

December 17, 2005
5:20 PM

Post #1928050

Julie
LOL,,,I'm not sure I Will get organized,,,heck, why start now?????ROFLOL

Glad you had both of those projects to keep you going last year. Winters can get pretty long and boring.

I know I can do the DB or SS,,,just not sure if I Want to get that into it right now,,,have a couple other projects I am into,,,so they may have to wait til next year,,LOL

I'm Organizing my Hosta info,,,in a SS,,,and a DB,,,how's that for Nuts??????LOL

Kelly
julie88
Muscoda, WI
(Zone 4b)

December 17, 2005
5:21 PM

Post #1928054

Which programs are you using? (I find index cards work well. hehehe)

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

December 17, 2005
5:25 PM

Post #1928057

LOL,,,I'm thinking of just going to that,,,I'm using Microsoft stuff,,,haven't worked on it for a while now with Christmas coming,,,I prolly won't remember what I was doing and why when I get back to it,,,LOL

edited 'cause I still can't spell,,,let's just say My Fingers won't cooperate,,,LOL

This message was edited Dec 17, 2005 12:41 PM
Equilibrium

December 17, 2005
5:38 PM

Post #1928081

Hey Julie,
You have mail.

Thanks for all your offers but quite frankly, I'm not computer literate enough to even understand what you offered me. I'm still trying to figure out what a stand alone module is. Does this say it all?

You geeks out there have fun. I think I'll just wait for a software application to come out that I can buy and don't have to fiddle with. I am just no good at this type of thing and am at the point in my life where there are too many remotes for my tv so I have to give them all to a kid and tell a kid to turn on Discovery or whatever it is I am interested in if I want to watch it. Technology passed me by I'm afraid.
julie88
Muscoda, WI
(Zone 4b)

December 17, 2005
6:57 PM

Post #1928204

Kelly, I'm not having trouble with my fingers and my typing...all my mistakes our being caused by the fact I *need* to cut these nails off! LOL

Lauren, I got the mail...I answered your D-mail...and I'm...uh...oooppps can't say *that* on DG. LOL I'll only say that if you paid for what I just saw, are you interested in a bridge? :-Z

I can tell from what I saw exactly what you were looking for in that application. I was really surprised to see how similar yours is to the one I built. The drag and drop feature for the pictures was one of the first things I put into my database. I just loved the idea of finding a picture on my hard drive or (don't tell anyone) borrowing one from the Plant Files until I could take my own and just dragging it to the DB. (A quick note here: Most the DG 'thefts' LOL have now been replaced by ones I've taken myself).

My DB is far from "complete"...I still want to add buttons I can push to get a listing of Winter Sown seeds (arranged by the dates they need to be started and well as alphbetical) or a hard copy of my suppliers names/addresses, etc.

As I've said before, I paid a LOT of money for commercial programs trying to get one I could use easily and that would hold the info I wanted to access. They ALL drove me crazy. But some of them did fill in the gaps for research UNTIL I found DG.

I've even thought of the possibility of selling my structure to some company who could market it. Obviously, that has been put on the back burner. LOL (I'm too busy to even *think* about dealing "people" at this point.)

~julie~
Equilibrium

December 17, 2005
9:55 PM

Post #1928438

I got it! The only thing that stands out for me is that it is a read only version. Anything I can do about that? Here's hoping what ever you suggest isn't too difficult or I'm in trouble.

The red background for whether a plant is in the collection or not is hard on the eyes but that was the only thing that I could find that seemed out of place. That is really an excellent application. You done good! Holy Moly great balls of fire. I have no idea how to use it though but I'm liking it.

sannajane
Eureka, CA

December 17, 2005
10:10 PM

Post #1928471

Extremely impressive!!! All I can say is WOW!! And thanks too for the link to Tom Clothier's site. Very good information.

Sanna
julie88
Muscoda, WI
(Zone 4b)

December 17, 2005
11:00 PM

Post #1928550

Lauren
Quoting: Here's hoping what ever you suggest isn't too difficult or I'm in trouble.

LOL
Ok...I suggest that you ask your husband to go into the properties of the file and uncheck the "read only" only. (And those colors were put in there because they were the only ones *I* noticed. hehehe

Thank you Sanna! I appreciate that. And I'm happy the TOm Clothier site is helpful to you.

~julie~
Equilibrium

December 18, 2005
2:16 AM

Post #1928798

Quoting:Ok...I suggest that you ask your husband to go into the properties of the file and uncheck the "read only" only.

My computer IQ is about 60 which is considerably lower than room temperature on a warm day ;) I'll have one of the kids go into the properties for me and fix me up. You know something Julie... one of these days I'm going to learn how to turn on my own tv and get it to the Discovery or HGTV all by myself! Don't be holding your breath or anything waiting for that day though.

GardenGeek_WI
Central, WI
(Zone 4a)

December 18, 2005
2:53 AM

Post #1928836

Eq,,,LOL know how you feel,,,I used to be able to take something out of the box and just use it,,,now, I have to read the directions,,,LOL I remember as a kid thinking Jeez,,,adults are so stupid,,,LOL,,,now I Know I am. I guess the above average results of the last IQ test I took didn't include gadgets of the technological kind,,,ROFLOL

Kelly
Equilibrium

December 18, 2005
3:05 AM

Post #1928848

So, you feel my pain? Ha ha ha, woe is me. I used to be embarrassed. Now I don't care. Almost everything seems to come with an owners manual these days. I have a brand new digital camera right now that I can't use that is supposed to be able to take micro and macro shots and I keep meaning to find the owners manual that I took out of the box to read so I could use the camera. What an idiot I am. I'm sure I'll find the manual sooner or later but until then... my brand new camera is sitting in the box. That's the pits.

You know what's funny, the only thing that doesn't come with an owners manual that really should come with one is a kid. They come with titles (birth certificates) just like a car does but no owner's manuals. You'd think they'd tuck a little "How To" manual in the diaper or something but noooooooo, they leave us to our own devices.
GardenGeek_WI
Central, WI
(Zone 4a)

December 18, 2005
3:13 AM

Post #1928864

Eq,

LOL,,,yes, I feel your pain,,,I have a pretty snappy Amateur Professional Digital Camera,,,I Still haven't figured out how to do all the things it's supposed to do,,,haven't taken time to sit and read through the book,,,LOL I just use the Auto setting,,,it must have at least12 more settings and a whole lot of other snappy *things*,,,oh well, one of these days

Kelly
Equilibrium

December 31, 2005
3:40 AM

Post #1947012

Well, the holidays are almost over and I still haven't located the owner's manual to my new camera- pathetic. Maybe that should be my New Year's resolution. Find manual and bond with it.

Say Julie, I was poking around and found these-
http://www.ideasgenie.co.uk/
http://www.primasoft.com/deluxeprg/goodx.htm
great search feature
http://www.auburnsoftware.com/default.asp?rcdid=81

Anything of interest at any of those sites for you?
julie88
Muscoda, WI
(Zone 4b)

December 31, 2005
9:19 PM

Post #1948047

Lib...all those links have some good ideas. I especially liked the "Ideas Genie". I'll probably go back to all of them when I have a little more time (...and when my mind is on the subject.. LOL)

Thanks!

~julie~
Equilibrium

January 1, 2006
12:56 PM

Post #1948807

Time? A little more time? Whaz that?
GardenGeek_WI
Central, WI
(Zone 4a)

January 1, 2006
4:49 PM

Post #1949139

No idea here
julie88
Muscoda, WI
(Zone 4b)

January 2, 2006
3:01 AM

Post #1950031

Time...don't we *grow* that in our herb garden? I have to wait until summer to begin harvesting it though. ;-)

~julie~
~~giggle~~
GardenGeek_WI
Central, WI
(Zone 4a)

January 2, 2006
5:55 PM

Post #1950926

Julie,

We Know what you grow in your Herb Garden,,,ROFLOL

Kelly
julie88
Muscoda, WI
(Zone 4b)

January 2, 2006
9:51 PM

Post #1951311

GOOD thing I didn't have coffee in mouth or hand when I read your post, Kelly. I most certainly would have spit it all over the desk. (Shhhh, you're not supposed to *talk* about *that* herb! LOL)

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

January 3, 2006
3:16 AM

Post #1951956

Now I have Diet Pepsi all over my monitor,,,LOL,,,
julie88
Muscoda, WI
(Zone 4b)

January 3, 2006
3:21 AM

Post #1951964

hehehehe

~guess who~
GardenGeek_WI
Central, WI
(Zone 4a)

January 3, 2006
3:23 AM

Post #1951968

Who?
julie88
Muscoda, WI
(Zone 4b)

January 3, 2006
3:41 AM

Post #1951992

Kelly you have Dmail...
~julie~
(that's who! hehehe)
GardenGeek_WI
Central, WI
(Zone 4a)

January 3, 2006
3:52 AM

Post #1952006

LOL,,,now, you have d-mail,,,LOL
julie88
Muscoda, WI
(Zone 4b)

January 3, 2006
4:10 AM

Post #1952026

Got it! :-D Thanks Kelly! ((((~hugs~))))

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

January 3, 2006
4:30 AM

Post #1952041

((((Julie))))))
julie88
Muscoda, WI
(Zone 4b)

January 3, 2006
5:42 AM

Post #1952090

Ahhhhhhh...that felt GOOD! (Thanks) :-)

~julie~
Anitabryk2
Long Island, NY
(Zone 6b)

January 3, 2006
2:11 PM

Post #1952384

I spent a good portion of this weekend working on my database. Here is one form that I have completed. I will post pictures of some of the other's that I have created as well. I still have to work on an information form. I was having problems getting the tab feature to work...

Thumbnail by Anitabryk2
Click the image for an enlarged view.

julie88
Muscoda, WI
(Zone 4b)

January 3, 2006
4:23 PM

Post #1952563

Anita, that tab feature in Access can be bit tricky to get used to. Lookin' GOOD!

~julie~
Anitabryk2
Long Island, NY
(Zone 6b)

January 3, 2006
4:27 PM

Post #1952566

tell me about - I really have to play - I would put it in, but I couldn't get anything to stay on it. It would load behind it? Frustrating, but I love a good challenge!

~Anita
julie88
Muscoda, WI
(Zone 4b)

January 3, 2006
5:26 PM

Post #1952671

Anita, you might have better luck if you 'built' the tab unit first then added your entry form to the tabs. One thing I remember giving me fits was that my forms and all the various fields had to be placed *inside* the outer boundaries of the tabs section. I finally got the place where I cramped everything on the tab body, then checked it forms view to see if they all fit. LOL

Trust me, unless you do this everyday (which I *don't* any more) it can be very intimidating. Hang in there...(Stacey can give you some help. hehehe Gotcha now, Stacey. You are the designated "Designer!")

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

January 3, 2006
6:46 PM

Post #1952767

Julie,

LOL,,,You stinker you.
Anitabryk2
Long Island, NY
(Zone 6b)

January 3, 2006
6:49 PM

Post #1952769

I'll remember that...Stacey...you want to be my access Angel??? hee hee. I'm usually good at figuring things out, but just in case, it's nice to know there's an halo hangin' around!

~Anita
julie88
Muscoda, WI
(Zone 4b)

January 3, 2006
8:25 PM

Post #1952902

(Stacey's not listening...) LOL And for some reason I'm not sure the "halo" thing fits her anyway. STACEY put that can of peas BACK in the cupboard...ooops, too late! She threw it anyway! :-D

~julie~
Anitabryk2
Long Island, NY
(Zone 6b)

January 3, 2006
8:41 PM

Post #1952941

LOL
Anitabryk2
Long Island, NY
(Zone 6b)

January 3, 2006
10:13 PM

Post #1953094

Here's the worksheet I created...

Thumbnail by Anitabryk2
Click the image for an enlarged view.

Anitabryk2
Long Island, NY
(Zone 6b)

January 3, 2006
10:13 PM

Post #1953095

Then I can go to my computer and start entering in this form...

Thumbnail by Anitabryk2
Click the image for an enlarged view.

Anitabryk2
Long Island, NY
(Zone 6b)

January 3, 2006
10:15 PM

Post #1953098

Finally, once my containers start germinating - I can use this form. I will probably create a worksheet for this as well and keep it downstairs by the back door for convenience.

Thumbnail by Anitabryk2
Click the image for an enlarged view.

julie88
Muscoda, WI
(Zone 4b)

January 4, 2006
4:20 AM

Post #1953832

Anita...those look really good. And I like the idea of the worksheet as well. I did the same kind of things with my work DB for equipment job logs and such. And boy did it make a difference in being able to keep track of the things going on a one time in our facility.

Keep up the good work!

~julie~
sstateham
Rockford, IL
(Zone 4b)

January 4, 2006
10:57 AM

Post #1954029

I somehow lost my watch on this thread...

Anita - I'd be happy to help! Which version of Access are you using?

There are a couple of things you might want to think about... You might want to have a separate table each for the mast plant database and the plants in your garden. Limit the field properties of the garden list to the name column in the master. Make sure to choose the "limit to list" property as "yes" and expand as "yes" or if you're like me, you'll put in a typo at some point, and end up with a messy plant list.

Go to the relationships set up, and set up a relationship between the two name fields, and select "enforce referential integrity".

Now you can use linked forms, child fields, and sub-forms.

Instead of trying to use the tabs in the forms, which as Julie said, can be a pain in the patooty, try using hot button to sub forms. Create the two forms separately, ie - one with your garden info, and one with the plant database information. Create a button on your garden form to find the plant information, and let the wizard walk you through. The action you want is open form, then "find a record", and link the forms by plant names. Save your form, and test it. Say you're on a delphinium...it should open up the plant database info and go to the record on the same plant name.

For worksheets, create a form with the fields you want, and in the form properies go to the format tab, and then down to views allowed...choose datasheet, and the form will pop up as a worksheet. You can hot link this via a button as well, or add it to your switchboard.


Anitabryk2
Long Island, NY
(Zone 6b)

January 4, 2006
1:15 PM

Post #1954162

cool - excellent ideas. I plan on playing with this alot more. I have an old version of access. I just purchased the upgrade to '03 and am waiting for the disc so I can load it. The program is so useful. I also use it to track my Christmas list as well [sent/rec'd, etc].

I can't seem to find 'switchboard' in the version that I have as I created what I have already from scratch. I will let you know if I still have a problem once I get the latest and greatest version.
julie88
Muscoda, WI
(Zone 4b)

January 4, 2006
2:32 PM

Post #1954269

Ooooo Stacey! You *are* good! (LOL)

You know what bothers me about your post? I understood every word of it. Where the heck were you when I needed someone to help me out years ago? (Nevermind...you probably weren't *born* yet! hehehe)
:-D
~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

January 4, 2006
2:40 PM

Post #1954281

Are we all talking about the same Access?????? LOL I Really have to start playing with it,,,Julie, why wouldn't you,,,you do that stuff all the time,,,LOL

Kelly
jasmerr
Merrimac, WI
(Zone 4b)

January 4, 2006
2:49 PM

Post #1954302

I was thinking the same thing - LOL! Have absolutely no idea what you are talking about until I get to look at Access!

Jody
GardenGeek_WI
Central, WI
(Zone 4a)

January 4, 2006
2:52 PM

Post #1954310

I've worked with Access plenty,,,but will have to refresh my memory,,,it was a few years ago,,,LOL
sstateham
Rockford, IL
(Zone 4b)

January 5, 2006
12:58 PM

Post #1956076

Anita - if you're in Access 97, go to Tools, Add Ins, and then to Switchboard. I use 97 and 2003, believe it or not. Our operating system at work doesn't like the newer versions, so I have databases in both, depending on what they're for.

I've been puttering around building one of my own, but I haven't been able to work on it very much. I had two that I had to build for work, and I've olny finished one so far. I'll be able to spend a little more time building the garden one in a few weeks.

Stacy
sanannie
White Lake, ON
(Zone 4b)

January 5, 2006
6:08 PM

Post #1956638

I've been reading this thread with interest as I've been wanting to get all my garden info in one program for a while. I knew a database program was the answer but I don't have Access with my MS Office and I'd never used a database before...so I've procrastinated.

I've been using a spreadsheet to keep a record of the plants in my garden. When they bloom, where I bought them, etc. Then I started one that I call my garden design assistant, where I list things like height, and foliage colour, time of bloom etc, then I used to sort it if I was looking for short plants, etc. But, as you say Julie, sometimes it would sort one column, not the line as a whole. I found this frustrating, plus the fact that there were so many columns across it was a bit cumbersome.

So, as I said I've been reading this thread and I was considering purchasing Access because of all your wonderful information and a ready-made template to copy, but the cost was holding me up ($300 CDN)! Then EQuil posted those links above. So, I've decided to get the IdeasGenie to keep all my gardening info in one place. It's in the mail!

Thank you EQ for the link! Thanks to all you other awesome computer savvies too for giving me the kick in the butt to learn something new. I like the idea of having a picture and all the info together.

Sandy
sstateham
Rockford, IL
(Zone 4b)

January 5, 2006
11:43 PM

Post #1957193

Sandy - before you give up on Excel, you can create a column for pictures, and put in hyperlinks to the photos in My Documents, or whatever. Creating a hyperlink is pretty easy. What I like about excel is the ability to filter. I have a spreadsheet, too, and I have colums for cole, height, bloom time, bed, etc. You can use the auto filter function to narrow things down pretty easily. Not as fancy-schancy as Access, but it gets the job done for free.
sanannie
White Lake, ON
(Zone 4b)

January 6, 2006
2:21 PM

Post #1958192

Stacy - I didn't know you could put links to the photos in Excel. I'll have to try that. No, I won't give up on Excel, I'll still use it to keep certain lists.

In your opinion, Stacy, what is the biggest advantage of Access over Excel? Am I right in saying the info can be sorted on more levels at once? (Eg show me all the blue flowers that bloom in June or July with a height of less than12") Anything else? What would you say is the biggest disadvantage of Access over Excel? I'm guessing the lengthy set up and learning curve?

Sandy
julie88
Muscoda, WI
(Zone 4b)

January 6, 2006
2:52 PM

Post #1958269

Quoting: What would you say is the biggest disadvantage of Access over Excel? I'm guessing the lengthy set up and learning curve?


(Sandy, I'm not Stacey...LOL...but I'm going to jump in on that one anyway.)

Disadvantage...The price! LOL Access isn't included in the Office bundle...and yes the learning curve is a little difficult if you're not used to working with a relational database.

And YES! Access *could* most certainly do the sort/filters you're talking about above. It's a very simple process to "Filter by Field". For your search you'd click inside a "color" field...which would filter all the records to leave only the 'Blue'...then you'd scroll through a few records until you found the month you wanted "June" select that field and once again, "Filter by Field" and VOILA' a list that only contains those two criteria.

Of course there are other ways to do it...and there *is* always the fact that the info/data has to be correctly entered for the filter/s to work properly. But that goes with the territory. You can only get "out" of the program, what you are willing to put "in". :-)

~julie~
sanannie
White Lake, ON
(Zone 4b)

January 6, 2006
3:01 PM

Post #1958287

Thanks, Julie, for your input (hey I made a pun!)

Sandy
julie88
Muscoda, WI
(Zone 4b)

January 6, 2006
3:27 PM

Post #1958344

Ooooo...you're GOOD! LOL
~j~
GardenGeek_WI
Central, WI
(Zone 4a)

January 6, 2006
5:19 PM

Post #1958553

LOL @ Sandy,,, funny
jasmerr
Merrimac, WI
(Zone 4b)

January 6, 2006
6:11 PM

Post #1958654

Okay...I'm trying to teach myself how to use Access, but I have run into a problem. What is and SQL Server Database? Everytime I try to start a project it asks which server I want to use, or tells me I need to connect to one.

HELP!!!

Jody
GardenGeek_WI
Central, WI
(Zone 4a)

January 6, 2006
6:40 PM

Post #1958681

UUUMMMMM,,,hhhhheeeeeelllllllppppppp,,same question here,,,LOL,,,never had that happen when using Access.

Kelly
sstateham
Rockford, IL
(Zone 4b)

January 6, 2006
10:28 PM

Post #1958983

I'll back up what Julie said. Think of Access as a lot more powerful version of excel. You can manage multiple spreadsheet ("tables" in Access) and it knows how they relate to each other. Access will let you easily make a form to manage your info, where in excel you're looking at the raw data. If you're keeping one big list with a lot of information, Excel is a decent but not "pretty" way to do it. Access lets you automate it and pretty it up.

Jody - What are you in when it's asking you to connect to an SQL? You should be able to open a blank database, give it a name, and import your tables just fine. Microsoft SQL server is a tool that can be used to create databases directly on the operating system as opposed to using a tool like Access. It would be something that a company might use to set up a client-server database or to be able to host a complex web application (ie internet shopping site, etc). If you still have problems d-mail me.
GardenGeek_WI
Central, WI
(Zone 4a)

January 7, 2006
5:01 AM

Post #1959610

Jody,
It happens to me when I click Project (New Data) when starting Access.

Julie or Stacy,,,Want to ask ,,,
Have any book recommendations for learning how to use Access better? Looked at both, The Complete Idiots Guide to Access and Microsoft Access 2002 for Dummies,,,neither got good reviews on Amazon.

Kelly
sstateham
Rockford, IL
(Zone 4b)

January 7, 2006
11:35 AM

Post #1959766

About the best one I've found for beginners is Access 2003 All-in-One Desk Reference for Dummies. The regular "for dummies" book doesn't go into enough detail. This one misses a couple of things, but it covers enough to get a decent database off the ground. I also like Peter Norton's guides. I still use my old Peter Norton guide to Access 97 Programming. Most if it still applies to the new version.

When you click Project and new data, it sounds like it's looking for a MS Project file, not that you want to start a new project. I'm on my home pc, so I can't check. Access 2003 is on my work laptop - this computer has 97. After I havea cup of coffee (I just woke up) I'll check.

sstateham
Rockford, IL
(Zone 4b)

January 7, 2006
12:11 PM

Post #1959805

I looked, and I see what's up. Don't select Project - that's to set up client server relationships to Acess. Just start with "blank database" and go from there.
GardenGeek_WI
Central, WI
(Zone 4a)

January 7, 2006
10:40 PM

Post #1960888

Stacy,
That's what I kinda got when looking through the reviews in Amazon,,,the 2003 Desk Reference had fairly good recommendations. Will have to look for Peter Norton guide to Access 97 Programming.

I thought that may be the thing,,,when I start a new database,,,I have never selected the project option,,,this is the first time I have done that,,,now I know not to.,,,I Learn something new everyday,,,LOL

Thanks so Much,
Kelly
jasmerr
Merrimac, WI
(Zone 4b)

January 7, 2006
11:23 PM

Post #1960988

Okay...I was clicking on "Project using new data." I thought I had tried "Blank Database" once, but I must not have. I was able to download the info from Tom's site; now I'm trying to figure out how to get all the fancy little tabs, etc.

Jody
sstateham
Rockford, IL
(Zone 4b)

January 8, 2006
12:06 AM

Post #1961096

Jody - get your tables put together, and make sure you have all the fields you're going to want. THEN start building your forms.
julie88
Muscoda, WI
(Zone 4b)

January 8, 2006
3:10 AM

Post #1961472

Quoting: Jody - get your tables put together, and make sure you have all the fields you're going to want. THEN start building your forms.

hehehe Yep! Get those things setup FIRST...don't do it like I did! LOL (You'll be fighting your mistakes forever, trust me!)

Sounds like you ladies are really getting into the idea of database design. I'm THRILLED to hear it! I just love the all the possibilities that can be had with a DB.

(And I'm very thankful for Stacey's help, too)

~julie~
jasmerr
Merrimac, WI
(Zone 4b)

January 8, 2006
4:07 AM

Post #1961563

Thanks for the advice! I think I have the tables set up right; now I'm trying to decide exactly what I need before going forward.

Jody
Anitabryk2
Long Island, NY
(Zone 6b)

January 8, 2006
1:08 PM

Post #1961840

Yeah - my tables are good too. I just need to figure out exactly how I want everything to work - form wise. I really am enjoying the challenge of figuring this out!
sstateham
Rockford, IL
(Zone 4b)

January 8, 2006
1:29 PM

Post #1961866

Ok - Here's what I have so far. I started the plant list with the download the julie linked to above, removed fields I don't need, and added some that I want. That's the Master Plants List. I added a number key so that I have something easy to link to for the other table. I'm on my old home pc, so this is Access 97, but there would be almost no difference at this point with the newer version

My Plants is the list of what I actually have. The relationship is set up to enforce referential integrity to the main list. If I try to enter something in my garden list that isn't a real plant, it will error out, and I will add a link back to the main list to search and add a plant if it really need to be.

The sources table is my catalogs, trade sources, local nursuries, etc.

I haven't started on forms yet.

Someone above mentioned wanting a drop down box... I'll put the how-to for thay in another post.

Skip thinks I'm insane for playing with a database at 8:30 on Sunday morning. It's good to keep him wondering what I'm up to.

Screen shots of table design and relationships are attached...

Thumbnail by sstateham
Click the image for an enlarged view.

sstateham
Rockford, IL
(Zone 4b)

January 8, 2006
1:41 PM

Post #1961889

Ok - To make a drop down box that ties directly to a specific field in a table is pretty easy. There are three different options for this, depending on what you want to accomplish.

Go to your table in design mode, an select your field. At the bottom you'll have some specific property options. Click on the lookup tab. Display control defaults to "text box". Change it to "combo box". If all you want it to be able to select all the items in that field (like click to pick a plant), you're done.

If you want to limit the selection to what's in the list (ie - make it harder to pick a plant that isn't in the list) change Limit To List to yes.

If you have a field, like I do for Acid, where you want to keep your entries to a few options (ie Acid, Normal, and Alkyline), do this...Below where you changed it to "combo box" is a field called Row Source Type. It defaults to Table/Query. Change it to Value List. In the field Row Source put in the entries you want to allow like this, with semi-colons as separators.

Acid;Normal;Alkyline

Set Limit to List to Yes.

Another option... if you want to limit the entries allowed for one field to a field in another table, you can also do this here via the combo box.. Like I want to limit the "source" field in My Plants to sources that are in my source table.

Change Display control to Combo box, leave row source type as table/query, and then
in Row Source click on the build (...) button next to the drop down. A window will pop up with your tables, and pick the one with the info you want. Double click on the field you want to tie to, and save. Change your limit to list to yes, and save your table.
Anitabryk2
Long Island, NY
(Zone 6b)

January 8, 2006
4:18 PM

Post #1962113

I've been working on a form based on a query - but am running into road blocks.

I created a query that asks for my seed Id [I want to use this when I am updating the database with container info.] My form so far works nicely. Upon opening it it asks for the seed id and will open with the plant from my list. The container field is linked with the container table - once I enter a number in that field it automatically opens my container form. I have the container form rigged to close window after entry.

My problem is getting the container form to automatically open as a new record entry! Right now it defaults to the 1st record. Any suggestions?
Anitabryk2
Long Island, NY
(Zone 6b)

January 8, 2006
4:28 PM

Post #1962125

Here's a shot of my form - Instead of an automatic jump to the WS container form - I added a command button instead. The Next Seed ID button triggers the query to run again.

Thumbnail by Anitabryk2
Click the image for an enlarged view.

sstateham
Rockford, IL
(Zone 4b)

January 8, 2006
6:03 PM

Post #1962296

Instead of linking open form, link to open form in add mode. That should do the trick
mornin_gayle
Bloomingdale, OH
(Zone 6a)

January 8, 2006
7:06 PM

Post #1962366

I'm very impressed with the programming skills and knowledge shown on this thread! When you have it all ready to go and for sale, let me know! Untill then, I guess I just have to stick with my wireless notebook...

mg

Thumbnail by mornin_gayle
Click the image for an enlarged view.

GardenGeek_WI
Central, WI
(Zone 4a)

January 8, 2006
9:10 PM

Post #1962579

*raising hand high into the air*

Teacher,,,I don't get it,,,could we start over?????

I thought this was in English,,,I don't know Techi,,,

I Must be in the wrong room,,,What room is Beginning Database 101 in?????

Kelly
sstateham
Rockford, IL
(Zone 4b)

January 8, 2006
9:13 PM

Post #1962585

Lol Kelly! Where are you stuck?
GardenGeek_WI
Central, WI
(Zone 4a)

January 8, 2006
9:28 PM

Post #1962612

O.K.,,,I start Access and click Blank Database and the window comes up and I name it Hostas, that's where I get lost,,,roflol
Anitabryk2
Long Island, NY
(Zone 6b)

January 8, 2006
9:30 PM

Post #1962616

That did the trick Stacy - Thanks!!! I am having so much fun!!!! I played half my day away today working on my database. I actually forgot to eat until 1pm
GardenGeek_WI
Central, WI
(Zone 4a)

January 8, 2006
9:32 PM

Post #1962620

Anita,

Oh Sure,,,rub it in,,,LOL,,,someone wanna come over and do mine????? hhhmmmmm????

This message was edited Jan 8, 2006 4:32 PM
sstateham
Rockford, IL
(Zone 4b)

January 8, 2006
10:39 PM

Post #1962825

Kelly - You need to start a new table first. Do you already have an excel spreadsheet, or are you starting from scratch?
julie88
Muscoda, WI
(Zone 4b)

January 9, 2006
1:17 AM

Post #1963160

ROTFLMBO!! I LOVE this! Stacey you are doing a wonderful job. I may even try that drop down option myself...now, could you help me with remembering how to digitize a scroll-y satin stitch for my embroidery? hehehe

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

January 9, 2006
1:40 AM

Post #1963211

Stacey,
I started a DB and what made me start over was the stupid ID,,,thingie,,,it's on auto number and so it won't go Alphabetically,,, when I add a new hosta,,if I put it alphabetically, it puts like # 145 inbetween # 37 and #38,,,
Anitabryk2
Long Island, NY
(Zone 6b)

January 9, 2006
3:26 AM

Post #1963438

Hey GG - I only worry about the ID when I need to pull the record up - otherwise I just look at the name. Unless, you plan on using the number in another way?

Notice my report - the number is only for when I need to pull up the plant - otherwise I sort by name...
~Anita

Thumbnail by Anitabryk2
Click the image for an enlarged view.

GardenGeek_WI
Central, WI
(Zone 4a)

January 9, 2006
3:50 AM

Post #1963479

Anita,
I guess I will just have to keep going that way then,,,got a bunch done a long time ago and stopped, 'cause I am one of those Anal people that the number has to coincide with the alphabetical order of the plant names,,,LOL Like I can't have another plant added in alphabetical order with numbers way out of whack,,,LOL

But, I guess I just have to get over it,,,when I get new ones, the numbers will be out of order,,,grrrrr, LOL

Kelly
julie88
Muscoda, WI
(Zone 4b)

January 9, 2006
4:18 AM

Post #1963526

Kelly, you don't have to worry at all about the numbers and the alphabetical order (You *could* just ignor the numbers or have them hidden from your view...hehehe).

Seriously, there's no way that you will ever get plants entered into your database with that kind of precision until you are no longer gardening and don't need to add a new variety.

(Sheesh! And I thought *I* was bad!) j/k

When I first set my DB up I wanted to try to keep things nice and neat too. But I kept getting gift Daylilies and my DH would bring me a new perennial plant while I was having eye surgery. Well, that's the cool thing about DB's...you can always filter and sort and add new things and still be able to find them later.

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

January 9, 2006
4:35 AM

Post #1963557

Julie,

*looking down with hands in pockets kicking a stone*
I Guess I'll forget about the numbers,,,
This just shows how Anal I really am,,,ROFLMBO

Stacey,
I ordered the All in one Desk Reference and have a question in on Peter Norton guide to Access 97 Programming from eBay. Thanks again for the info.

Kelly
sstateham
Rockford, IL
(Zone 4b)

January 9, 2006
11:48 AM

Post #1963761

Thanks Julie - I'm having fun! As I walk everyone through theirs, I've started on my own. The challenge will be today, when I'll be working from home most of the day. It will be tough to stay on the computer and out of the garden database.

Kelly - You can use the auto number, just make it the second field in your table (In design mode just drag the field down a slot). It should auto sort by name. I like having a number, especially when there are a lot of similar varieties. The books should help a lot.

Anita - Nice report!! That's pretty nice.

GardenGeek_WI
Central, WI
(Zone 4a)

January 9, 2006
4:39 PM

Post #1964177

OH, Stacey,,,I'm hopeless,,,LOL it won't drag,,,LOL I better start from scratch,,,grrrrrr

Kelly
sstateham
Rockford, IL
(Zone 4b)

January 9, 2006
11:04 PM

Post #1964864

Kelly - do this... save your table, and go into design mode. Selete the auto number field, and then insert a line UNDER the plant name field. Then set it as auto number format and primary key. That should take care of it.
Anitabryk2
Long Island, NY
(Zone 6b)

January 10, 2006
12:05 AM

Post #1965009

Thanks Stacey
GardenGeek_WI
Central, WI
(Zone 4a)

January 10, 2006
2:18 AM

Post #1965257

Stacey,

Wanna come over and play Access with me????? huh,,,do ya,,huh?????? Worked great, thanks,,,LOL If I would have patience to read the tutorial I'm sure I could get farther,,,I do better with books though,,,c'mon Amazon,,,LOL

Thanks, Kelly
sstateham
Rockford, IL
(Zone 4b)

January 10, 2006
11:03 AM

Post #1965738

Access road trip? LOL Once you get your tables built, you'll have the hard part done.
GardenGeek_WI
Central, WI
(Zone 4a)

January 10, 2006
9:36 PM

Post #1967488

Um,,,what's a table??????
jasmerr
Merrimac, WI
(Zone 4b)

January 10, 2006
11:40 PM

Post #1967773

Where you sit to eat breakfast, lunch, and dinner!
GardenGeek_WI
Central, WI
(Zone 4a)

January 11, 2006
1:52 AM

Post #1968120

Jody,

Thanks, that's what I thought they were meaning,,,but I already have tables,,,why would I have to build more???? Maybe I'll have to talk to Bill about this,,,he's the carpenter,,,hmmmmmmm.

Thanks again,
Kelly
jasmerr
Merrimac, WI
(Zone 4b)

January 11, 2006
3:30 PM

Post #1969183

You have to build more because we're coming for dinner!

GardenGeek_WI
Central, WI
(Zone 4a)

January 11, 2006
4:50 PM

Post #1969368

Oh, my,,,don't know if he can get them done that fast,,,when are you coming???? LOL
GardenGeek_WI
Central, WI
(Zone 4a)

January 11, 2006
8:25 PM

Post #1969824

Yippee,,,

ViolaAnn just e-mailed me 2 booklets? for lack of a better work about Access and how to use it. I'm printing them out now,,,can't wait to start reading them,,,pretty soon I'll be having one heck of a DB going,,,yeehaaa THANKS ANN

Kelly
Anitabryk2
Long Island, NY
(Zone 6b)

January 11, 2006
8:40 PM

Post #1969894

Like kids in a candy shop...
GardenGeek_WI
Central, WI
(Zone 4a)

January 11, 2006
8:45 PM

Post #1969916

You bet,,,kinda sad and pathetic huh????,,,LOL
Anitabryk2
Long Island, NY
(Zone 6b)

January 11, 2006
8:52 PM

Post #1969926

I don't think so - I'm one of the kids fighting to get to the jar or licorice!!!
GardenGeek_WI
Central, WI
(Zone 4a)

January 11, 2006
9:16 PM

Post #1969984

Anita,

LOL,,,makes me feel better.

Kelly
jasmerr
Merrimac, WI
(Zone 4b)

January 11, 2006
9:33 PM

Post #1970022

Kelly,

Now you can teach me!!!!

Jody
GardenGeek_WI
Central, WI
(Zone 4a)

January 11, 2006
10:14 PM

Post #1970115

Want the files? I can e-mail them to you. If you want them, d-mail me with your e-mail addy

Kelly
GardenGeek_WI
Central, WI
(Zone 4a)

January 12, 2006
10:02 PM

Post #1972470

I want you all to know,,,I am now anal about this stupid DB thing,,,yes, you have made it so,,,I am diligently working on inputing info,,,grrrr!!!!!

Kelly with buggy puter eyes
Anitabryk2
Long Island, NY
(Zone 6b)

January 13, 2006
12:24 AM

Post #1972717

hmmm...does that mean we can add 'computer' to your name..gardengeek??

Heaven knows I'm one!!!
GardenGeek_WI
Central, WI
(Zone 4a)

January 13, 2006
1:12 AM

Post #1972801

Anita,
Yes,,,my username could have also been ComputerGeek_WI,,at least it's got Geek in it,,,I figure that covers a lot of stuff,,,lol ,,I have been addicted to computers since I got my first one 10 years ago. The funny part is,,,I didn't want one,,,Bill talked me into it,,,now he threatens to throw it into the Mill Pond,,,says I spend Way too much time on it. I'm mostly self taught,,not that I know really that much,,,but enough to get the things done that I want to,,,. I have this obsessive nature and now that I'm working on a DB,,,I won't let it go til it's the way I want it,,,lol,,, would Love to get more *into* it. Eventually I will. Bill asked me the other night why I don't go to school for puter stuff since that's what I like to do. Asked him how he thought the bills were going to get paid,,,lol

Kelly
Anitabryk2
Long Island, NY
(Zone 6b)

January 13, 2006
1:27 AM

Post #1972840

I hear you Kelly - I love my PC too. I am also self taught - or paid close attention when I was at work. Sometimes it's more gratifying to have figured something out for myself rather than having someone show me..

~Anita
GardenGeek_WI
Central, WI
(Zone 4a)

January 13, 2006
1:35 AM

Post #1972858

Anita,
ohhhh, don't I know that,,,lol,,,I am *playing* All the time,,,love to get into a new program and figure it out. When I got my first puter,,,I bought the Complete Idiots Guide to Windows 95 and I sat with that book in front of the puter for weekends on end. Had only used a puter 2 times before that and both times it was me typing and the owner of the puter doing everythig else. I'm glad I pick up on stuff pretty quickly.

Kelly
Anitabryk2
Long Island, NY
(Zone 6b)

January 15, 2006
2:23 PM

Post #1978095

I have a question about switchboards. I created a second switchboard page for links to all my reports. I also created buttons that link the default and the new. As far as I can see - I did it properly, but the buttons don't seem to work? On the default switchboard all links work except for the link to the second page.
sstateham
Rockford, IL
(Zone 4b)

January 15, 2006
2:46 PM

Post #1978138

Hmmm - got me there. First I'd say to try deleting the switchboard with the links that aren't working, and then re-do. Make sure that you select the items from the drop list instead of typing them in. Sounds like there's a bad link, but without looking at it I can't say for sure.
Anitabryk2
Long Island, NY
(Zone 6b)

January 15, 2006
3:03 PM

Post #1978177

I tried that already and I am using the drop downs - is there supposed to be a second switchboard form? I've loaded some screen shots. Hopefully it will help - I'm baffled.

Thumbnail by Anitabryk2
Click the image for an enlarged view.

julie88
Muscoda, WI
(Zone 4b)

January 18, 2006
5:26 PM

Post #1985106

Stacey, I'm not participating in the DG as much right now. If you want to start another thread for this fantastic project, please feel free to do it.

I'm kinda lost in a no man's land here in my basement. :-) (Yep! I'm finally getting around to cleaning things up and tossing a mountain of stuff so I can use my new embroidery machine!)

Also, I have something to talk to you about...I'll be D-mailing in a couple of minutes.

~julie~
sstateham
Rockford, IL
(Zone 4b)

January 19, 2006
12:43 PM

Post #1986519

We can keep this thread - I have it watched.

Good luck in the basement. That's no-mans land around here.
GardenGeek_WI
Central, WI
(Zone 4a)

January 25, 2006
12:36 AM

Post #1998136

Stacy,
Got both books,,,I'm gonna be readin' for awhile,, I may not get to the actual DB until Fall by the looks of these books,,,LOL They're pretty thick. I'm glad I read well and fast,,

Kelly
Anitabryk2
Long Island, NY
(Zone 6b)

January 25, 2006
12:38 AM

Post #1998140

Go for it Kelly!!! It is making my life so much easier when it comes to keeping track of things. So glad I decided to take the leap and start one.

Anita
GardenGeek_WI
Central, WI
(Zone 4a)

January 25, 2006
12:42 AM

Post #1998147

Anita,

As soon as I finish these monster books that Stacy told me about,,,I'll *git r done* until then, I'm just entering information right now. That's what I'm supposed to do first right? Enter all the info on each hosta in that DB,,,then get into the fancy stuff?

Kelly
Anitabryk2
Long Island, NY
(Zone 6b)

January 25, 2006
12:45 AM

Post #1998158

yup - set your tables up. Figure out what info that table should have. I have a table for my plants, a table for the seed companies, a table for my containers, a table for the Tom C table and then a table for the wintersowing info that I got from another website. If you are interested in that one, here's a link to my webpage where you can find the download link for it. http://www.lakehousecreations.com/winter_sowing.htm

Anita
GardenGeek_WI
Central, WI
(Zone 4a)

January 25, 2006
12:51 AM

Post #1998170

Anita,
Thanks,,,so far I just have my Hosta Table,,,which is pretty inclusive,,,down to who introduced it and what year,,,I Know,,,ANAL,,,but I have lots of info to get in there still,,,will take a Loooooong time,,LOL Thanks for the link

Kelly
Anitabryk2
Long Island, NY
(Zone 6b)

January 25, 2006
12:54 AM

Post #1998178

hey - that's what databases are for...information!!! Enjoy!
GardenGeek_WI
Central, WI
(Zone 4a)

January 25, 2006
12:56 AM

Post #1998181

LOL,,,being the information junkie that I am,,,I'm prolly Never gona use half of the info I'm putting in there. I do love playing on the puter though.

Kelly
Anitabryk2
Long Island, NY
(Zone 6b)

January 25, 2006
12:57 AM

Post #1998184

ditto
GardenGeek_WI
Central, WI
(Zone 4a)

January 25, 2006
12:58 AM

Post #1998186

;o}~
sstateham
Rockford, IL
(Zone 4b)

January 25, 2006
10:50 AM

Post #1998794

I got stuck building a database for work, so I haven't been able to play much on my garden toy. I do have my tables built and relationships layed out, but no forms or nuthin' yet.
Anitabryk2
Long Island, NY
(Zone 6b)

January 25, 2006
10:55 AM

Post #1998804

That's sad - tell work that you have more pressing matters at home...
GardenGeek_WI
Central, WI
(Zone 4a)

January 25, 2006
2:24 PM

Post #1999179

LOL,,,Yeah, I agree,,,LOL
sstateham
Rockford, IL
(Zone 4b)

March 19, 2006
2:33 PM

Post #2122915

I've been working on this on and off through the winter. Now I have spring fever and have been feeling cooped up, so I've been working on it a lot over the last week. I'm on a new pc, and I'm having touble with the security levels not allowing me to post pics. I'll put on some screen shots when I have the problem sorted out
Anitabryk2
Long Island, NY
(Zone 6b)

March 19, 2006
2:50 PM

Post #2122940

cool - good luck
sstateham
Rockford, IL
(Zone 4b)

March 19, 2006
3:14 PM

Post #2122991

Ready to rip my hair out - I think PC-cillin is what's blocking me from uploading pics. anyone have experience with this?
Anitabryk2
Long Island, NY
(Zone 6b)

March 19, 2006
3:16 PM

Post #2122999

no sorry
Equilibrium

March 19, 2006
6:21 PM

Post #2123306

Load a freeware version of AVG or ZoneAlarm and shut down your PC-cillin. Now try your photos.
sstateham
Rockford, IL
(Zone 4b)

March 19, 2006
7:07 PM

Post #2123382

The main menu so far

Thumbnail by sstateham
Click the image for an enlarged view.

sstateham
Rockford, IL
(Zone 4b)

March 19, 2006
7:07 PM

Post #2123383

Apparently shutting PC cillin down temporarily does the trick - duh :)

This is the Master Plant Listing

Thumbnail by sstateham
Click the image for an enlarged view.

sstateham
Rockford, IL
(Zone 4b)

March 19, 2006
7:08 PM

Post #2123385

"my Beds" - plant listing and info by bed

Thumbnail by sstateham
Click the image for an enlarged view.

sstateham
Rockford, IL
(Zone 4b)

March 19, 2006
7:15 PM

Post #2123399

And the "add a task" screen. In the process of building the code and report to limit the listing that this produces to 30 day window...

Thumbnail by sstateham
Click the image for an enlarged view.

bigcityal
Menasha, WI
(Zone 5a)

March 19, 2006
7:53 PM

Post #2123460

Gotta ask what the 'bomb' feature is on the first pic. I need that for my neighbors ;)
sstateham
Rockford, IL
(Zone 4b)

March 19, 2006
7:57 PM

Post #2123476

lol al - that's "delete" for plants that won't grow here. I started the database with a list that someone else made. I've had to remove a lot of plants, and I have a ton to add. It started ut with not a single pulmonaria, hosta, tulip, daffodil, etc. I'm working on going through my old order reciepts and plant notebooks to get it built.
kandlmidd
Presque Isle, WI
(Zone 3b)

March 19, 2006
11:52 PM

Post #2123975

Wow, nice job Stacy. See, not only is this dog a little too long in the tooth to even get a inkling of what you're actually doing to set this great program up, but I'm beginning to forget what is what and where it's at in the actual location. Thankfully I can still turn a compost pile, and know the difference between a weed and what's supposed to be there, and most importantly bend down and remove the offender and add it to the aformentioned pile. These "new tricks" I guess I will leave to you pups. I do still recognize a job well done, and consider yourself patted on the head. Ken
Equilibrium

March 20, 2006
2:45 AM

Post #2124376

Stacy, I think Al wanted to know what the plant was that appeared in the photograph in the first photo. It looks to me to be Baptisia australis. That should do just fine by him in full sun. Nice deep roots too so once it is established, it should be drought resistant.

You have done a remarkable job with your program.
sstateham
Rockford, IL
(Zone 4b)

March 20, 2006
11:09 AM

Post #2124780

Thanks Lauren and Ken! I've been having a blast getting this put together!

I'm not necessarily a "pup" lol. I'm good on computers and disorganized with paper, so this is intended to keep my litter piles to a lower tonage.

Lauren - I thought he meant my bomb button on the Master. Yes, the plant photo on the main menu is Baptisia. It gets more shade here than it should like, but it does great. The other screens are a mix of foliage from jap. painted fern, pulmonaria and galium; rudbeckia; sweet violets; and peony. I went through my files last night and got 2004 and 2005 plant additions input. Unfortunately, I only got smart enough to save those things in mid '04, so the rest of the lists will have to come from walking around and hoping I remember correctly.
Anitabryk2
Long Island, NY
(Zone 6b)

March 20, 2006
11:10 AM

Post #2124781

excellent! I love it Stacy. Al - you like that little bomb..eh? It caught my attention too! More fun to click that than a button that says delete! LOL!!
sstateham
Rockford, IL
(Zone 4b)

March 20, 2006
11:16 AM

Post #2124793

maybe I need to build a tracker for mortaily and put in a skull and crossbones button? lol
Equilibrium

March 20, 2006
1:45 PM

Post #2125070

[quote]walking around and hoping I remember correctly[quote] The story of my life.

I like the skull and cross bones idea.
sstateham
Rockford, IL
(Zone 4b)

March 20, 2006
11:36 PM

Post #2126424

LOLOL! I can't tell you how many things I've bought/planted/seeded in that I didn't write down anywhere. After the reciepts, this is going to be interesting! If you and April come for an ID/Idea visit, I promise I'll write things down!
Equilibrium

March 21, 2006
2:26 AM

Post #2126790

Er uh, if you promise were you expecting us to promise back?
GardenGeek_WI
Central, WI
(Zone 4a)

March 21, 2006
5:13 AM

Post #2127115

Stacy,
Wow, great job. I'm still inputting data for hostas,,,lol,,,don't know if I'll Ever have a complete DB.
sstateham
Rockford, IL
(Zone 4b)

March 21, 2006
9:45 AM

Post #2127193

lol Lauren.. I'll do the writing - you and April can be off the hook :) Klehm's is pretty close to me, and so is Anderson Gardens. Both are pretty cool.

Kelly - the pretty pictures make it look a lot more done than it is. I have the front end stuff done, but I still have a lot of plants to put in and there's some functions that I need to code in still.
Anitabryk2
Long Island, NY
(Zone 6b)

March 21, 2006
11:36 AM

Post #2127288

It's so time consuming - isn't it? I love it though. I just get frustrated with myself, when I decide that something isn't organized right or I want to change the table around...and it's just not working. But..I love a good challenge.
GardenGeek_WI
Central, WI
(Zone 4a)

March 21, 2006
3:48 PM

Post #2127774

LOL,,,Like I said, I'll prolly never have a completed DB
julie88
Muscoda, WI
(Zone 4b)

March 22, 2006
11:45 AM

Post #2129728

Stacy!!! It looks WONDERFUL! You've got all the most important information tucked in so it's available when and where you need it.

To y'all who are having a hard time getting your data entered...I can only laugh. I remember last winter when I decided it would be a good idea to manually enter 10 years of Garden Gate Index pages (the FINE print kind they put in the year's collection) into my database. Not a bad goal for someone who had just had cataract surgery, eh? LOL I got just about HALF of it done and couldn't take another line of print I had to use a magnifying glass to read. :-D

It's hard to force yourself to keep stuff entered and up to date, but my-O-my, it's worth every second of the effort.

GREAT JOB STACY!!!

~julie~
sstateham
Rockford, IL
(Zone 4b)

March 23, 2006
9:08 AM

Post #2132494

Thanks Julie- good to see you come out of the basement :) I've been adding a few plants every morning, so it's not bad. It may take a while, but I won't get burn out.

Work this week has been all consuming, so I haven't had much time to play around with my own computer stuff. In the play time I got, I built reports to use as a task list and one that gives me a plant inventory by bed, but I haven't fancied them up yet. I'm hoping to get this as close to functional as I can before gardening takes over all my spare time. When the plants are up and going I can use the inventory list to double check that I have all my plants loaded. For now I'm going back through my plant pictures and using those as a double check against the database.


GardenGeek_WI
Central, WI
(Zone 4a)

March 25, 2006
3:06 AM

Post #2137517

Haven't had any time to work on entering info into the DB at all for a couple of months,,,have to get back at it now that my bookwork is finished.

Life is insane here right now. Will try and check in after the weekend. Am going to International Falls, MN for my nieces Ice Show. She started skating at 5 and is now 15. Her skating club puts on a show at the end of every season.
Have a good weekend all. See you on Mon.

Kelly
dodecatheon
Wauconda, IL

March 26, 2006
12:40 AM

Post #2139206

I feel so inadequate...
sstateham
Rockford, IL
(Zone 4b)

March 27, 2006
11:41 AM

Post #2141914

LOL April :)
alyrics
Beachwood, OH

March 27, 2006
12:45 PM

Post #2142084

I have a simple flat Excel spreadsheet I use to type in the bloom start and end dates for each plant in my garden. It then links to a color coded chart that shows the succession of bloom times. If anyone would like a copy I'd be glad to share. I was not the originator, someone from another website is. I think she is now on DG and she annually does an update to share around so I know she won't mind. Its a simple tool to keep track of where you put each plant, bloom times, color. I often make notes in an adjacent cell that doesn't show up on the chart about special treatments, etc.

Don't get me wrong - if I was capable of putting together a multifaceted database I'd be right on it!!!!
I know its possible in Access, or maybe even the pivot table feature in Excel but I've never been able to sit down to plan such a thing. Julie's darn right about the fact that you need to think about what you want before you start designing. I used a commercial database called Commence at work to create our customer service and all customer records storage a number of years ago and succeeded in making at least one person in each dept unhappy as their particular want or need wasn't on top of the list.
Andrea
sstateham
Rockford, IL
(Zone 4b)

March 27, 2006
8:47 PM

Post #2143065

Andrea - your spreadhseet sounds like something I used for years. I used an "if" formula and conditional formating to set the color of the cell to appromixate the plant color. It was handy to be able to use the filters to see what blooms when and in what color. i've been trying to figure out a good way to get color into my database reports, but I don't think I want to mess that much with code.

I got the reports I wanted built, and now I'm trying to build a "wish list" for plants that I don't have and tie them to specific beds. The problems now are that I want to be able to just check a box and have it add to the bed when I get the plant, instead of going through a three step process, and that a lot of the plants that I want to put on the wish list aren't in the master database yet. I need to make an easy - add to master. It was nice this weekend, so I didn't work on it much (and I got a new computer game that took up more time that I should have spent playing).

Anitabryk2
Long Island, NY
(Zone 6b)

March 27, 2006
8:50 PM

Post #2143073

what about importing the results to excel and then you can refresh the data...then you can use the formatting?
GardenGeek_WI
Central, WI
(Zone 4a)

March 28, 2006
2:57 AM

Post #2144229

All Greek to me,,,LOL haven't had time to sit and start reading my books yet. But will at some point. Prolly once I get outside and the plants are up, I'll get excited about doing the DB and will work on it in the evenings.

Kelly
zenpotter
Minneapolis, MN
(Zone 4b)

March 30, 2006
2:59 PM

Post #2150196

Julie, My husband a programmer/analyst is very impressed with your data base.
GardenGeek_WI
Central, WI
(Zone 4a)

March 31, 2006
1:13 AM

Post #2151608

zen,

oooo, you're gonna give her a big head now,,,LOL
julie88
Muscoda, WI
(Zone 4b)

April 7, 2006
7:43 PM

Post #2171865

HI everyone... It's ME!
:-O

Zen...thanks for that compliment from your DH. It means a lot to me since I am *extremely* self-taught. LOL I won't go into that part.

Geek! WATCH yourself! LOL (I know better than to get a "big head"...there's *always* someone waiting to pop that balloon. hehehe ...notice I just called myself an "air head".)

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

April 8, 2006
3:40 AM

Post #2173046

Julie,
LOL I know I'm a geek but do you have to start calling me one??? LOL Know the feeling of someone always wanting to pop your balloon,,,and you're Not an airhead!

I Gotta start reading those 2 books I got about Access,,,database won't do itself,,,unfortunately. Hey, maybe I could get Stacy to send me hers,,,Then it would do it all by itself. LOL

Kelly
julie88
Muscoda, WI
(Zone 4b)

April 8, 2006
3:46 AM

Post #2173055

Kelly...hehehe

I'm working on a database now to catalog my thousands of embroidery designs. I have a huge collection and it really tickcs me off when I can't find a single thing I want to use. SOoooo...I go buy some more. hehehe (Hubby is about to take away my plastic. :-D)

~julie~
GardenGeek_WI
Central, WI
(Zone 4a)

April 8, 2006
3:55 AM

Post #2173068

Julie,

Oh, sure,,,rub it right in,,,2 DB's done and I can't even get one done,,,LOL I haven't worked on it all winter. Gotta work on it to get r done,,,LOL,,,Hide that plastic,,,don't let him get it. LOL

Kelly
Anitabryk2
Long Island, NY
(Zone 6b)

September 6, 2006
4:17 PM

Post #2697209

I thought I would revive this to see what everyone else is doing about tracking their seeds
GardenGeek_WI
Central, WI
(Zone 4a)

September 6, 2006
5:44 PM

Post #2697466

Anita,

Nothing yet,,,hopefully this weekend I'll be able to get out and get some scrounged up. Haven't made Any progress on the Data Base though. Maybe I'll send all my info to Stacy and she can git r done,,,LOL
Anitabryk2
Long Island, NY
(Zone 6b)

September 6, 2006
6:28 PM

Post #2697601

lol - git r done...I love that guy!
GardenGeek_WI
Central, WI
(Zone 4a)

September 7, 2006
3:55 AM

Post #2699323

LOL,,,I do too, along with Jeff Foxworthy and that other guy,,,forget his name, but they are all touring together.

Love the you might be a redneck if stuff. Bill's family to a T,,,LOL
Melissa_Ohio
Southwestern, OH
(Zone 6b)

January 4, 2007
5:30 PM

Post #3052770

Is anyone still watching this?

I have access, but have never used it. I'd like to, but can't figure out how to start, my sample databases won't come up when I click. should I search the web and try to find a sample to start me out? Or is there something I'm missing?

Thanks for any help!
jasmerr
Merrimac, WI
(Zone 4b)

January 4, 2007
5:57 PM

Post #3052852

I am still watching, but haven't really had a chance to try to set mine up. I hope I can get to it this month.
marie_
West Central, WI
(Zone 4a)

January 4, 2007
6:09 PM

Post #3052887

I'm also still watching this, and haven't even begun to figure it out for myself yet. It's on my To Do List for this winter.
jasmerr
Merrimac, WI
(Zone 4b)

January 4, 2007
6:13 PM

Post #3052896

Kelly (GardenGeek_WI) sent me instructions for Access. I'll find them and see if I can forward them to you.
Melissa_Ohio
Southwestern, OH
(Zone 6b)

January 4, 2007
6:21 PM

Post #3052915

thanks Jasmerr
I got out seeds to see what I have and what I need, and I quickly figured out I NEED to organize them! LOL
jasmerr
Merrimac, WI
(Zone 4b)

March 11, 2007
8:23 PM

Post #3271228

Melissa, did I ever get that sent to you?

Think I'll start a new thread: http://davesgarden.com/forums/t/700635/
Melissa_Ohio
Southwestern, OH
(Zone 6b)

March 11, 2007
9:11 PM

Post #3271333

Nope you sure didn't! LOL I was just looking at this a couple of days ago again. :)

I'll dmail you my email addy

You cannot post until you register, login and subscribe.


Other Upper Midwest Gardening Threads you might be interested in:

SubjectThread StarterRepliesLast Post
Me Too! Great Forum idea! / Seed saving question caitlinsgarden 12 Jun 6, 2007 1:34 PM
Let's Plan a "TO-DO" Calendar! julie88 104 Jan 23, 2013 10:47 AM
Raggball ornaments raggedyann16142 8 Jun 6, 2007 1:39 PM
ROAD TRIP to DUBUQUE and beyond ! Wandasflowers 93 Apr 8, 2007 12:17 AM
My Northern Lights Azalea is seasonally confused! Advice? green_willow 10 Nov 11, 2007 3:29 AM


We recommend Firefox
Overwhelmed? There's a lot to see here. Try starting at our homepage.

[ Home | About | Advertise | Media Kit | Mission | Featured Companies | Submit an Article | Terms of Use | Tour | Rules | Privacy Policy | Contact Us ]

Back to the top

Copyright © 2000-2014 Dave's Garden, an Internet Brands company. All Rights Reserved.
 

Hope for America