Recent content by Bluezman

Thanks Cosmo! Any help you could offer would be great! Feel free to make any alterations you think necessary. Thanks again! Bluez

Still needing some assistance if anyone is needing a challenge. Sorry to be such a bother, but I'm truely stuck on this one :( Thanks in advance!! Bluez

Anyone have any ideas yet? This must have everyone stumped. Please post anything you might feel is helpful. Thanks!! Bluez

Any luck figuring out this calculation with the supplied DB? I've been beating my brains out and still have no luck. Any progress reports would be appreciated :-) Bluez

Here is the Access 2000 version of my db. If you have any questions please email me and I will try to explain any issues. Bluez

Over the weekend, I've tried to implement into my actual database, what Cosmo and EMP suggested, but without luck. Cosmo & EMP, what I'd like to do is send you a stripped down version of this database (reduced to about 5 records) so you can see what I'm trying to do and what has been done so...

I agreee, both solutions are worthy of being looked at. Speed is not an issue with the users of this database. Compared to what they had (old dbase III system) anything is better. One aspect of EMP's solution that I'll have to work with is that, while this example database theoretically has the...

Hi Rich.. here is the 97 version of that database. It's not exactly the same as the database I'm working on, but the subform total will work exactly the same way, so any help you might be able to give would be great. Thanks!! Bluez

Thanks Cosmo, I looked over what you did and it looks great. It will take some ingenuity to get it transferred to the database I'm working on, but I'll let you know how it goes. Just wondering, but what were your thoughts concerning how it found the DaysDifference before and why it is so hard...

No, it's a function found on the MS Knowledge Base that is used to get a value from a previous record on a form for use on the current record. In my case, I'm using it to calculate the differences in days between events. While in the details section of the subform, this calculation works great...

May I contact you about a question I have regarding the PrevRecVal function? You may contact me via email or instant message. Thanks! Bluez

Hi Pat, Why would the exact syntax work when the =IIf(... is placed in the details section, but not when it's encapsulated by the Sum()? As for the control having the same name as a field in the record source, I've triple checked and there is not a field with the same name. Lastly, I've...

On the attached database (a functional similar database to the one I'm trying to code correctly) I'm trying to get a subform to total and am having a hard time getting it to do so. I have an original thread in the VBA & Modules area...

I believe (and here is where I will probably show my ignorance) the name of the control that holds the Sum() is DaysSum (located in the form footer) and it is a unique name. If this is not what you're asking me for, please enlighten me on what I should do to get that information. Now...

Thinking that something must be getting lost in translation, here is a complete rundown on my subform: The Subform [tblActivity Subform] has the following record source: SELECT [tblActivity].[ActivityPK], [tblActivity].[ActivityID], [tblActivity].[ActivityDate], [tblActivity].[ActivityTypeID]...