Recent content by spacether

Maybe this is the problem: from http://www.ureader.com/message/1376557.aspx

WayneRyan, I'm only using one database; my db1.mdb, and my query and module with the public function ConCat are in it. Doesn't that put ConCat in the correct domain? I've changed my connection string to Jet: Dim con, sql, ADOCommand, rs Set ADOCommand = Server.CreateObject("ADODB.Command") Set...

It looks like they're using: Windows 2000 Server - .NET The details are here: http://ase.tufts.edu/its/webdeptorgappdevpol.htm And my connection string from the asp page is: Set con = Server.CreateObject("ADODB.Connection")'Create an ADO connection object con.Open "DRIVER={Microsoft Access...

The pstrSQL comes in fine. When I use a msgbox to display the sql I get: SELECT Position FROM BoardMembers WHERE Name='Samantha Michaels' If I then enter that sql into a query, it returns the correct result. So the error isn't in the sql string being passed.

WayneRyan, I used your query, but I am still getting the same errors. In the Visual Basic Editor under Tools -> References I have checked off: Visual Basic For Applications Microsoft Access 10.0 Object Libraries OLE Automation Microsoft ActiveX Data Objects 2.1 Library Should I be getting...

I found a function to concatenate the results of a sql query. I want to use it as an aggregate string function in a sql statement. The function is: module: 'modConcat' code: ------------------------------------------------ Option Compare Database Option Explicit Public Function Concat(pstrSQL...