Recent content by Elladan

Well done Bob! That does indeed appear to be the issue. Now, if only there was some way around that....in the meantime, I guess I could add a button - not as pretty, but at least functional. Thanks! :)

For the record, I tried UNcommenting the code I commented previously and using vbNullString instead of NULL. No difference. I'm beginning to think this is a Windows 7 issue. Further, I've discovered it isn't just the combobox that doesn't work, it's also the lstbox on the previous form. In...

Hi Draco, Thanks for the ideas. I did try to comment out what you suggested. The SetRecordSource code now looks like this: Private Sub SetRecordSource() On Error GoTo ErrMessage If strMeetingArgs = "" Then 'no openargs - new record 'MB 10/3/12 ' Set rsMeetings = New ADODB.Recordset '...

Yes, the Front-end is on each individual machine. It's located on the Desktop. User's open it and login to the front-end, connecting via the SQL server. All the front-ends use the same SQL username/password built into the system (they don't know this), but each user has their own...

SQL Server 2005. Windows 7 ODBC driver was setup as a file DSN using an SQL server driver. As far as sending you the data system, it would be pretty complicated and I'd have to explain how to use it. There's much more to it than just this one function...it handles member information, meeting...

BTW, I also tried converting the database from 2003 (the one I told you I corrected) to native 2007 and that didn't clear the oddity either.

Ok, Bob....:) I spent the whole day doing this.... I imported everything into an Access 2003 type database in Access 2007 and set the references over again, recompiled (also tried the decompile - that didn't work), converted some of my DAO recordsets over to ADODB (apparently I missed more...

Hey Bob, Thanks for the reminder to keep an open mind - sometimes that's needed as we go so sure that we're right, we forget we can be wrong. Unfortunately, in this case, I wasn't wrong...:( I went through and closed every single recordset in the form, before setting it to nothing, and still...

Bob, I'll try to address all the issues you raised - some are really good points, but keep in mind that this code functions perfectly under Access 2003 - it's only under Access 2007 that I'm seeing the issue, so I'm thinking it a compatibility issue of some sort. 1) strMeetingArgs can be...

Here is the MouseDown Code: Private Sub lstMeetingAttendees_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single) On Error GoTo ErrMessage Dim answer As VbMsgBoxResult 'Dim rsDelete As DAO.Recordset Dim rsDelete As ADODB.Recordset Dim i As Integer If Button = 2 Then If...

Greetings: I think I win the cake for weirdest error and I hope someone out there has a solution or at least knows what's causing it. I've been programming in Access for about 10 years now and I've developed a front-end back-end system that in Access 2003 that works just great. It uses...