I have an Access database that was designed with Office1995 version. It has
a Sub which has array in it and it doesn't seem working with MS Office 2002
XP version. The program is a bit long but basically it is like this:
(the following Sub is called by another Private Sub)
Sub Oletest(cnn as ADODB.Connection, ....)
Dim SqlQuery As String
Dim RcdSet As DAO.RecordSet
Dim ppArray() As Varian
ReDim ppArray(1 to 10, 1 to 2)
...
SqlQuery = "SELECT * FROM ..."
Set RcdSet = CurrentDb.OpenRecordSet(SqlQuery)
If statement ....
...
Do Until statement ...
...
ppArray(arrayVal,1) = RcdSet![tax_info_1]
...
Loop
End if
...
The database works with Office 1995 but not with Office 2002. And I don't
see anything wrong with the array statement (I suspect the problem may be in
those array statements). Anybody knows about it? Thanks. Appreciate it.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1