Search results

  1. O

    open form's recordset in a query or Excel

    Gorgeous! That did it. Many, many thanks for your patience, Bob. Cheers!
  2. O

    open form's recordset in a query or Excel

    Debugger stopped on Set rst = frm.RecordsetClone. I needed to update form name. Sorry about that. Tested again. Excel opened with properly named sheet, but blank cells. Back to Access to find "run-time error '13': type mismatch" and debugger stopped on "For Each fld In rst.Fields"
  3. O

    open form's recordset in a query or Excel

    Darn. That didn't do the trick either. Not sure if it matters, but when I first tested the code I "borrowed" from you, I got the error I mentioned ("User-defined type not defined") and the debugger opened with this highlighted in yellow: rst As DAO.Recordset. Now I simply get an error box...
  4. O

    open form's recordset in a query or Excel

    I could have been clearer for you. I did try each of those DAO libraries individually. I settled on, DAO 3.6, as you suggested. That leaves me with the following references checked: - Visual Basic for Applications - Microsoft Access 11.0 Object Library - OLE Automation - Microsoft ActiveX...
  5. O

    open form's recordset in a query or Excel

    Thanks for hanging in there with me, Bob. I’m using Access 2003 sp3, by the way. Under Tools - References I found and tried setting a reference for each of the following but I’m getting “object required” or “424” errors now: - Microsoft DAO 2.5/3.51 Compatibility Library - Microsoft...
  6. O

    open form's recordset in a query or Excel

    Thank you so much, Bob. But my ignorance is showing... I get the following error on Dim rst As DAO.Recordset: "User-defined type not defined" In vb help for that error I noted, "Display the References dialog box, and then select the appropriate object library or type library. For example...
  7. O

    open form's recordset in a query or Excel

    Hello, First post here - apologies in advance if I break any protocols. I have a query-based form showing 7 columns of data: ID, Benefit_Year, Agency_Name, Benefit_Amount, ProgramName, Benefit_Description, Benefit_Rollup_Description. I have 5 combo boxes that one can use to filter that form...
  8. O

    I arrive, hat in hand...

    Hello all, I've learned a lot by searching this forum. It's high time I register and say hello. I'm a wannabee programmer working in the nonprofit sector. When I'm not shaking my fist at a bunch of non-working code on my monitor, I'm usually breaking a tennis racket or golf club over my...
Top Bottom