Search results for query: *

Thank you for the advice, MajP. Sounds like I might be able to juryrig this after all. :)

I have a form with nine tabs. I'd like to be able to bolden or highlight the tab that the user is currently working in. I can't find any info on how this might be accomplished. Does anyone have a suggestion? I'm not a code person but if pushed would be willing to give it a whirl. Thanks! Kathy

Hi, I discovered a little snag after some data entry and so am continuing with last Friday's thread, hopefully that is the best approach. Problem in a nutshell is. . . I need to calculate the number of days that transpire between occurrences of communication (email, phone calls, etc.) between...

PHV, Your code worked so good as a starting point it may turn into my happy ending point. It works great! Thanks so much! Harley, shame on you for taking a 5-minute lunch break. ;) Thanks to you also for helping me think through it a little better. Have a good weekend, all. Kathy

Harley, I think so, if I understand correctly... Say for the first three records: Project ID PropStageID ComDate 1 12 1/29/2009 1 11 1/27/2009 1 2 1/20/2009 I'm trying to get at how many days transpire between each occurrence of...

Does this help at all? Thanks. Date Diff 1_qry ProjectID PropStageID ComDate PrevDate 1 12 1/29/2009 1 11 1/27/2009 1 2 1/20/2009 1 1 1/15/2009 2 14 1/20/2009 2 13 1/14/2009 2 3 1/7/2009 3 17 1/26/2009 3 16 1/19/2009 3 15 1/8/2009 3 4 1/5/2009 4 20 1/21/2009 4 19 1/19/2009 4 18...

Harley, ProjectID is primary key in the Project table and foreign key in Proposal Stage table. Is this perhaps creating an issue or conflict? ComDate is a date picker field in the Proposal Stage table only. Thx. Kathy

Hi, novice Access 2007-er, green SQL-er here … I’ve tried very hard to figure this out by working with advice from similar posts but I am stuck, yet I think I’m almost there… Table: Proposal Stage_tbl Fields: ProjectID, PropStageID, ComDate(as well as Topic and a couple other flds not needed...