Type mismatch problem.

[BobRodes]

When I execute the following SQL string

SELECT max([Loaded]) as MaxDate FROM Application_Actives;

in the Access IDE, it works fine. However, when I run it in this VBA context

Set MyRs = MyDb.OpenRecordset("SELECT max([Loaded]) as MaxDate FROM Application_Actives;")

I get a Type Mismatch error. The [Loaded] field is a date type, and I'm wondering if there's some sort of trick required to convert Access date types to VBA date types. Can someone enlighten me?

TIA

Bob

 

[AlexCuse]

Bob-

I'm not positive, but I think you might need to put # symbols around your date field?

Just a guess.

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[BobRodes]

Well, as it turns out, the problem was something completely different. OpenRecordset expects a DAO Recordset, and "Dim MyRs as Recordset" was declaring an ADODB Recordset. Changing it to "Dim MyRs as DAO.Recordset" solved the problem.

Thanks,

Bob

 

[SkipVought]

Hi,

A date is a date.

Try converting the DATE to LONG

Set MyRs = MyDb.OpenRecordset("SELECT max(CLng([Loaded])) as MaxDate FROM Application_Actives;")

Skip,

_[red][/red]