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...
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?
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...
@ 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...
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".
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...
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...
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...
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...