Search results for query: *

Thats fantastic - did the trick nicely. Here's the final code I used: Option Compare Database Dim FirstPass As Integer Private Sub grpHeaderCommitteeID_Format(Cancel As Integer, FormatCount As Integer) FirstPass = False Dim rs As DAO.Recordset Dim strSQL As String Dim strCHAIRS As String...

I've got the following so far, just to see if I can even open the recordset: Option Compare Database Private Sub grpHeaderCommitteeID_Format(Cancel As Integer, FormatCount As Integer) Dim rstChairmen As DAO.Recordset Dim strSQL As String strSQL = "SELECT Participants.FirstName...

That's pretty much the approach I'm trying to take - the SQL is from the query builder, and I know it works. The problem is getting access to display those two names (or one name if the committee only has one chairperson) in the header. I was trying to: Set a recordset with that sql as the...

The problem with Dlookup is that it only returns one value - Each committee will have at leats 2 chairpeople.

Hi, I'm putting together an access DB for a confernece I'll be involved in running. I've got a main table containing a list of people, their groups, and their roles. I'm using access XP / 2002 and its an MDB file. I have a query which selects people who have role ID 1, formats their names...

Hey, here's an alternative approach :-D: int iNumber = 10; CString szString; szString.Format("%d", iNumber); MaxHeadroom