Search results for query: *

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.

Ok let me explain myself. I adopted to use this method because it works fine for me. First, I load the entire database. sNewConnectionString Conn.ConnectionString = sNewConnectionString Conn.CursorLocation = adUseServer Conn.Mode = adModeReadWrite Conn.Open Second, I...

Yes after I use rs.Update it adds a new record but related info from other tables won't show, example I enter EmployeeID and other info on current table as soon as I update EmployeeID I should get EmployeeName, EmployeeSS, EmployeeTitle, Etc. from my related table. This is the way it works on...

This is first app using ADO, previously using DAO. I have 3 linked tables in an open connection, when I add a new record information from link tables don't show. What am I doing wrong? ON DAO whe you add a new record it immediately updates the related field for to the link table. This a very...

Thank you for your quick response foada. What I did instead is change the CursorLocation to =adUseServer Now delete works fine without improving the results. instead of deleting the current record found it deletes the record on my related table not the record currently found. Any clues?

Why do I keep getting this error when trying to delete a record. "Insufficient Key column information for updating or refreshing." This is my code: strCriter = "[Ref ID]=" & stgrsID gRDB_RS.Find strCriter, , , 1 If gRDB_RS.EOF Then MsgBox...