Using A Query In Vba

[Milan]

Hi People!

I have an Access Query which I have go into design view/ SQl View : SELECT TblComplianceLine.ComplianceNo, TblComplianceLine.Description, TblComplianceLine.Comments, TblComplianceLine.AuditDate, TblComplianceLine.PointsLost
FROM TblComplianceLine
WHERE (((TblComplianceLine.AuditDate)=selectdate()) AND ((TblComplianceLine.Process)="SD"));

I need to use this in VB!! i have tried pasting it into a sub routine but it does not work. How can I get this to work in a sub procedure rather then a query?.

Many Thanks

Milan

 

[jfgambit]

Are you running this from a Command button?

 

[RichMorrison]

Like this

"SELECT TblComplianceLine.ComplianceNo, TblComplianceLine.Description, TblComplianceLine.Comments, TblComplianceLine.AuditDate, TblComplianceLine.PointsLost
FROM TblComplianceLine
WHERE (((TblComplianceLine.AuditDate)="
& "#" &
selectdate()
& "#" &
") AND ((TblComplianceLine.Process)='SD'))"


RichM

 

[Milan]

Work's Great!!!!


Thanks!!!!

Milan