Search results

No, I had five that opened three forms. The types Coaching Session and Side by Side Coaching Session open the subfrmEmployeeSessionsCalls. The types Personal Development Session and Other Documentation Session open the subfrmOtherSessions. The type Monthly Review opens the...

Thank you for the help. I learned something new in VBA and it was very easy to understand and add the other cases that I needed. This was my first post and I didn't see any points to assign so I hope I didn't miss something...again, thanks!!

I have a field called txtSessionType. There are five possible types and of these five they open three different subforms. The types Coaching Session and Side by Side Coaching Session open the subfrmEmployeeSessionsCalls. The types Personal Development Session and Other Documentation...

That did exactly what I needed. Thank you so much for the help.

Oh, OK. Let me try it again. Thanks.

I don't know what happened to it. This is the first time I have used this site. Do they delete them if they sit there too long? I did upload it again, maybe you can look again?

I still do need to know how to do this if anyone can help me. I did upload a copy of the database to this site if that will help.

Sorry it took so long but I got involved in an upgrade I am working on and didn't have time. I hope you can still help but if you can't I understand.

OK. I will change the name to something else. I also have to clean up the data and add false data so it will take me a bit of time. Thank you for your help.

I have the following in my query: Late: IIf([dtmLogTime]>[dtmStartTime],DateDiff("n",[dtmStartTime],[dtmLogTime])\60 & Format(DateDiff("n",[dtmStartTime],[dtmLogTime]) Mod 60,"\:00"),"") This creates a new field in my query called [Late]. My query also wants me to enter a year (2011) when it...

No. The report doesn't even open. I open the report, the query prompts for the year, the message comes up without the report behind it. I click OK on the message and it goes away and I am still at the database window form object. If I were to remove this textbox the report would open and...

That is exactly what I am talking about and it was the very first thing I tried. I placed it in the name footer so each persons total would appear at the end of their time. Listed below is what I received and it went on from there. I tried many different ways from what I found online but none...

I have the following in my query: Late: IIf([dtmLogTime]>[dtmStartTime],DateDiff("n",[dtmStartTime],[dtmLogTime])\60 & Format(DateDiff("n",[dtmStartTime],[dtmLogTime]) Mod 60,"\:00"),"") I then list the Late field on my report. Now I have to Sum this field on my report and can not figure...

Thank you for the help, using the columns gave me both parameters for my query for as many rows that I chose from the listbox.

I have a date field, it's called dtmStartDate. The first row of the listbox shows Course One (column one) 04/22/2009 (column two). The second row of the listbox shows Course Two (column one) 05/01/2009. The third row of the listbox shows Course Three (column one) 01/02/2010 (column two) and...

I've been searching everywhere on how to do this. I'm beginning to think it can only be done for one column list boxes and not two or more. I'm not a programmer so I'm really at a loss. Any help that can be offered would be greatly appreciated. I have a form with a listbox, lstCourses, that...