Recent content by g-richardson

I love the simplicity of it. Thanks so much, I'll give it a go on Monday

I have a table with that has a value and % AMT PCNT 0 0.00% 36000 0.50% 46000 0.80% 52000 1.00% 58000 1.30% 64000 1.50% 72000 2.00% And another table with crew and an "VALUE" earned. CREW EARNED Bill 32000 Todd 57508 Mark 67204 Donna 76118 If a value is >= an "AMT" I want to display the...

Hey Cronk, though your suggestions did not do what I am looking to do, it did give me an idea for something else that I was working on and I was able to make your suggestion about the timeinterval work to my advantage. Thanks for suggisting it. I will keep plugging along with my original issue...

Thanks Cronk, I'll give that a try. After I posted this, I tried using the textbox with transparent cmd over the top. I was able to get the txt box to do exactly what I wanted it to do, but I needed to "select" the corresponding record in the subform for the txtbox to change. Should I expect a...

So I'm trying to get the look, caption and the result of a click on a command button based on the refreshed data contained in a subform. This needs to be dynamic in that as a new date on the form's calendar is selected, the results listed in the subform will change based on that date and I need...

Hey Billmeye...It looks like I've got some work to do with this. I keep getting fatal errors that I haven't been able to resolve yet. I'm going to keep working on this because I really like the concept laid out. Now I just need to get it to fire. Thanks for your efforts

Thanks Billmeye...I see what you are doing here, but so far I'm not able to create the "If determine space is booked" part. Brief form layout (could need better design), so as stated earlier, form based on data in the Reservations table. So on the form, I have a subform of a calendar (found...

Hi, I'm building a workCube reservation system and I've been tasked to have it work kind of like an airplane seat reservation system. I've laid out my form with option buttons representing the location of each available space. (space1, space2, space3...space16) My desired outcome is to be...

In the Access 2003 I could sort my list of objects by clicking on the "COMMENTS" Column Header. I can't figure out how to do that with 2010? We have several processes used by different players and various queries and grouped by comment phrases in the Comments. Is there a way to sort the...

Thanks vbaInet. So simple and so perfect. Just what I was looking for. Thanks too for the quick response. George

I have a report which is comprised of several sub-reports which all format according to a set of variable. There are times when the resulting query produces and empty set. I need the sub-report to display a black box when the underlying query produces no results. I then need the black box to...

Thanks Ted, yes, I had found that instruction. I think my lack of familiarity with the financial world calculation as well as my limited abilities in VBA have restricted me. I can't figure out how to use the value from the PremDropYrs field to pass the change in formula to the IRR calculation...

Very new to the IRR function and don't know if I can do what I think I need to do. Have data something like this: Prem____TermPrem____TermDropYrs____PremDropYrs____TtlYrs 1000______158__________7______________20__________30 1437______281_________15______________12__________35...

Beetle...Perfect. Thank you so much, this is exactly what I needed. Thank you for the quick response.

I'm trying to build a rank based on a premium value where the smallest premium is ranked 1 and so on. All is working fine except when the premium value =0. example a. (this is good) Premium Rank 765 2 800 3 535 1 example b. (not accemptable) Premium...