Search results

What is the code behind strSql?

Dear Guus2005, I've given some thought to what you said about the Environ$("LOGONSERVER") statement, and came to solution that alowed me to discard it totally. Once I removed it from the query it all started working!!! So, first of all thanks for the tip, it proved to be very helpful. And...

Well, there are absolutly no errors in full version what so ever. And the Run-Time version surprisingly does not crash entirely, but pops up the error message and after "OK" button click just returns to the programm. The error message is : "There was a problem to access a property or method of...

Well, thanks for trying I realy appreciate that.

Yep, I've isolated it to the following line : rs.Open ssql1, CurrentProject.Connection, 1, 3 My guess is that the problem lies in the SQL statement, but I havent been able to figure it out. I'm trying to open a recordset to "Query1" which is quite complicated (for myself at least), but i'm...

Dear Guus2005, Thanks for taking a time to reply my thread. You are absolutly right, the correct code that I use is : Dim rs As Object Dim x, i As Integer Set rs = CreateObject("ADODB.Recordset") I only dimention rs as recordset for the time being, and the reason is that it is easier to write...

Hello all, I've written an application that takes care of our employees working hours. It was developed using MSACCESS 2003 and running under both the full version of access and run time version. Everything works fine under the full version, but there is a piece of code that causes an error...