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...
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)...
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 =...
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 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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.