Recent content by basstard80

  1. B

    Access 2010 Error 3021 while porting code from Access 2007 :: Help Request

    Service Pack 1 fixed all the problems. It looks like the first issue was not very stable... Thanks to you all for the support, in particular to Gina.
  2. B

    Access 2010 Error 3021 while porting code from Access 2007 :: Help Request

    At the end I gave up and I decided to rewrite from scratch. Nevertheless, I'm starting having a lot of "senseless" behaviours such as declaration like this Dim dbs as Database giving me strange compile errors like "Expected user-define type, not project", or "File not found" while opening...
  3. B

    Access 2007 with Access 2010

    Gina, is the same problem you already tried to solve.
  4. B

    Access 2010 Error 3021 while porting code from Access 2007 :: Help Request

    The only difference between this and the test I did is that the subForm recordset is assigned dinamically whilst the test I did was filled by a table content... May be this the problem?
  5. B

    Access 2010 Error 3021 while porting code from Access 2007 :: Help Request

    Here you are the whole module: Option Compare Database Option Explicit Private formHnd As Form_frmAccountList Private AccountId As String Private Sub cboDateFilter_Change() Call updateLedgerRecordset End Sub Private Sub cboDateFilter_MouseDown(Button As Integer, Shift As Integer, X As...
  6. B

    Access 2010 Error 3021 while porting code from Access 2007 :: Help Request

    I've just done 1, 2 and 3... and same error... I don't understand... I'm little bit disconsolate.
  7. B

    Access 2010 Error 3021 while porting code from Access 2007 :: Help Request

    @ Bob: yes, that's the name of the subForm which host the data form and has default view as datasheet @ Gina: I left minimum references which still compiles the project (VB for Application, MS Access 14.0 Object Library, MS Office 14.0 Access database engine Object Library) but... still "no...
  8. B

    Access 2007 with Access 2010

    I though that latest version should support older one, but I'm still having some problems with piece of code written with Access 2007 and trying to run it on Access 2010... so if I spoke by personal experience I'd say "no it won't work" or at least "be careful".
  9. B

    Access 2010 Error 3021 while porting code from Access 2007 :: Help Request

    Gina, as you suggested I disabled "compact on close" and "auto name" option but I'm still stuck. The references I see listed are in the piture attached, I cannot recognize any anomaly... pls take a look and tell me. I'm feeling like I found another of such kind of misteryous problem impossible...
  10. B

    Access 2010 Error 3021 while porting code from Access 2007 :: Help Request

    Hello, thanks for your posts. However 1. I always declare every variable (I tend to keep my code clean and DRY) 2. I don't want to uncheck "compact on close" because I do want to compact the DB on closure 3. I didn't found where uncheck Track AutName Correct (I've never used this option, could...
  11. B

    Access 2010 Error 3021 while porting code from Access 2007 :: Help Request

    Hello to everyone, I've googled my problem but it seems anyone had it before. I have a form containing a sub form. The main form is only a mask to contain some controls, while the subform shows a recordset given by a dinamically built query in datagrid mode. When I click on some row of the...
  12. B

    ADODB recordset dosn't work in function or class module?!?

    Hi guys, I'm new to this forum. I need the help of some expert! I'm trying to build a report interface of an Access 2007 DB using excel and ADODB. All the stubs and tests I did using code found on the web worked fine. So I started a clean coding. 1. What I did before (testing time): A sub...
Top Bottom