Recent content by lulo

uaahoo Thanks Zarkon4, this really works, you saved me from big headeaches.

Thanks Artiechoke your suggestion works.

I have created Pointzero.dll but I don't want to distribute it with the setup program instead I want to put on the network application path to make it easy to maitain. But it doesn't seem to work. I tried this but still won't work regsvr32 I:\GlobalApps\ICA\PointZero.dll I get error '430' after...

Does any one knows of a good book on ADO? I'm new to this and need to jump to ADO Recordsets. I don't need ADO.net at this time. Thanks a lot.

I need to upgrade some reports from crystal 6 to version 8 but I don't see the crystl32.ocx on my components object after I installed crystal 8. Can someone tell me what I am doing wrong? Is this data report feature availabe on version 8? This is all I'm doing. CRptGO.ReportFileName =...

Yes as a matter of fact that was my first attempt. Since I copy and paste the SqlStatement from MSAcccess. It just don't work on any. It works only when I try this gRDB_RS.Filter = "RetrainedDate Like " & "8/4/02" but this one doesn't gRDB_RS.Filter = "RetrainedDate...

I tried MSDN but it seems to me that I just found another glitch on it. I am not using any execute or any of the examples that caused the error on their examples. My program sees to work fine overall situations except date ranges. What a crap I made the jump to ADO and now I'm trap, because I...

This is a VB Error Run-Time error '3001' "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another". I also tried this, but no luck. Dim dtStart As Date, dtEnd As Date, numDay As Double dtStart = DateSerial(Year(Now), Month(Now), 1)...

Thank you John. But still won't work

I'm looking for date that fall between two dates but no luck. I get a run time error. Dim dtStart As Date, dtEnd As Date, numDay As Double dtStart = DateSerial(Year(Now), Month(Now), 1) dtEnd = DateSerial(Year(Now), Month(Now) + 1, 1) numDay = dtEnd - dtStart dtEnd =...

Thank you I've tried your suggestion, but still keep getting the same error. What do you think?

Filter not working. (Run time error '3001' 'Argument are of the wrong type, are out of acceptable range, or are in conflict with one another.') This is my code (access2000 db) Field in table is of type "Date/time" rs.Filter ="TrainingDate BETWEEN #" & txtTrainFrom &...

Yes I do have field name on recordset.

yes Peter I have primary keys on all my related tables. Do you know what's the best way connecting to a Access database Jet 4.0? Or if you might suggest any websites? Thank you

yes Peter, on a acces query it does all the work. Also using DAO does it which is what I have always used.