Recent content by asya

  1. A

    Dynamic Crosstab Report works in 2003 not in 2007

    Hello everyone I have an issue with my database. The database works fine in 2003. However when I try run it in 2007, one of the reports based on a cross-tab query (that works fine in 2007) would not open and comes up with a 3070 error ("Microsoft Access Database engine does not recognize " as...
  2. A

    run time error 13 data mismatch to do with dates

    Hello, it prints 06/11/11, so i tried FieldName = Format(Me.Combo3 + (7 * (i - 1)), "dd-mm-yy"), but still no success, tried without formating- no luck either. Interestingy, if i do not run the two codes together, the fieldname doesn't get an error...they must clash somehow Asya
  3. A

    run time error 13 data mismatch to do with dates

    Hi Kiwiman, I've tried to amend the code as suggested, but nothing appears in the immediate window..maybe i'm doing it wrong... Would the combo3.value being boolean and fieldname being integer have something to do with the mismatch? Thank you for your help Asya
  4. A

    run time error 13 data mismatch to do with dates

    Hi Kiwiman, I added it to the code and nothing appears in the immediate window...maybe I'm doing something wrong Would combo3.value is boolean in the watch and fieldname is integer have something to do with the mismatch?... Thanks heaps for your help, Asya
  5. A

    run time error 13 data mismatch to do with dates

    Hi Kiwiman, I've tried the suggested solution , still the same error unfortunately...
  6. A

    run time error 13 data mismatch to do with dates

    Hello, I'm trying to run the following code and get type mismatch 13 error Basically, i'm getting the 3rd field name along in table "ImportedTable", put that value on Combo3 and try run a transpose on the table. The field names (dates) in the transposed table get generated based on the...
See more
Top Bottom