Recent content by hughg

Jack, sorry for delay in getting back to your question, but I was unable to look at the forum. to answer your questions; during debugging RTE is raised on attemping to execute the connections open method, and yes absolutely closed. thanks again, hugh

Thanks for that Jack, But I am now getting the following runtime err: "Couldn't find installable ISAM" Any suggestions?

I am trying to connect to an Access DB using a standard ADO connection object. This runs perfectly when I do not set a password for the database; Dim cn As Connection Set cn = New Connection With cn .Provider = "Microsoft.jet.OLEDB.3.51" .ConnectionString=...

Strongm, as far as I can see the thread you listed doesn't actually offer an alternative, could you expand? Thanks.

Is this true even for late bound objects....if so does can anybody give me an explanation as to why? thanks.

Does anybody know a way to call this?

Do you mean Declare Function XXX (value as ###) AS Boolean If value = test then XXX = True Else XXX = False End If End Function Sub ToCallXXXFunction() Dim YYY as Boolean ... YYY = XXX(PassValueIntoXXX) ... End Sub

Indeed!, Those (') things can be extremely annoying (and time consuming to eliminate, especially in situations where you also have to use a lot of these (") things too). Generally to avoid blindness, etc., I use a simple string variable like so: Dim strApostrophe as string strApostrophe =...