Search results

Yes, I'm still playing around with what I want to track-because the possibilities are endless! For my purposes, at this point, bloom start and end will do. But, you're right, it may be useful down the road to have that wax and wane tracked, too. I've found that most of the data I've found about...

Hi There, I actually was able to solve this problem with the help of others on a different thread. The person who helped me (who I still can't thank enough) wrote a module for my DB which took the bloom start and end dates, and attributed a # to each month it bloomed; i.e. June-Aug bloom=6 7 8...

Thanks, again!

Hi Brian, Thanks so much for putting your time into this! In your Word doc, you said: The only reason I'd selected to use combo boxes is that I wanted a drop-down list for the user to select dates from, since I had the pseudo date formatted to month name; this way they wouldn't have to type...

Wow, I can't thank you enough! Looks like it works perfectly! Thanks, again!

Hi Brian, Thanks so much. Looks like this is the start of where I need to be. I copied your edited query bjwqryBloomTimeExtended, called it qryBloomTimeByMonth, and setup a parameter query from [bloommonths] to call any flowers that bloom in the month # entered, however, no matter what data I...

No problem at all! Hope everything is okay. Thanks.

Hi, Thanks, here's a copy of it in Access 02-03. I know my setup poor, I just have no idea how to better assign bloom periods. Originally, I had it setup on a numeric assignment (Jan=1, Feb=2, Mar=3, etc), but I changed it because I couldn't figure out how to arrange data in reports according...

Hi, I've gone back and forth with this DB trying to figure out the best way to track when a plant blooms, I really only need to know/show start month and end month. So, I settled on arbitrary dates, choosing the first day of each month of the year 2001 (i.e. January=1/1/01, Feb=2/1/01). These...

Hi, Yes, that is exactly what I want! I've had such a hard time finding any info on the web with this exact layout. I used your code as my base, but I'm a novice SQL, so I think this is what I want in the new module I created... Option Compare Database Public Function...

Hi, I've got a DB in which records have a start date and an end date. I'd like to be able to run a parameter query that will prompt which month I'd like to look at, and return all records which fall into that month. I haven't been able to figure out the right way to set this up, as I only get...

Ahhhh!!! Eureka! That was it, Thanks a million!

Hi, Thanks for the suggestions. Not sure if I'm doing this right, I'm having some problems getting this to execute properly. I put the code into a standard module, called 'GetColors', edited it with my colors and saved it. Now, I've tried to create a query called 'BloomColorExtended' that...

Hi, The select query in the combo box works like this: if a user is entering staff hours to figure out how much to bill for time, they select what position the hours are for (director, manager, technician, etc.), then fill in the hours in the [NumberOfHours] box. I set up the [Pay Rate] combo...

Hi, I've got an accounting DB in which I have a form with 3 possible different currency values the user can enter; [Materials Cost], [Rate Cost], and [Contractor Cost]. I have a query which pulls any value from these (there will only ever be one of them filled out per record) and puts it into...

Hello, I'd like to design a calendar-style plant bloom time report which will show months as the headers of columns and list the plant name across each month it's in bloom, like this: .......May.......June........July........August........Sept...... -------------Plant...

Re: How to design a plant database- reports & calendars Thanks for the suggestions. I'll check them out to see how it goes...But first... I'm now trying to create a report which will show me a cross-section/bar graph type calendar displaying all species. I need the plant's bar to start in the...

Hi, I have DB based on flower information; i.e. flower name, growth patterns and needs, bloom time, and bloom color. On my Flower Details form, I have a subform featuring bloom colors in check boxes. Since a flower can have multiple bloom colors, I decided to use check boxes rather than have...

Hello, Thanks for the advice. That is kind of what I'd started developing, I just was not sure whether that was the best way to go about this or whether it was round-about. Your point about plants in bloom from fall through the calendar year is a good one; we do plant items that are grown for...

Hello, I'm currently creating a database in which I can enter information about plants and track not only species information but also planting requirements & growing conditions, bloom colors, pollinator information, and bloom time of year. My question is this: the most important type of...