Search results for query: *

Thanks you, it works perfectly!

Great, Thank you, i think is working. Do you know if it is possible to turn off the message (you about to update...)?

You could do something like this: Private Sub ChkRec() 'open recordset first With rst .MoveFirst Do Until .EOF If recX > recY Then updateTbl (recX) .Delete End If .MoveNext Loop End With End Sub...

Could anyone tell me what's wrong with the following code and does anyone know how to use the single and double quotes in sql and how many i.e. to for a text box, variable etc. Dim strSql As String strSql = "UPDATE Clients SET" strSql = strSql & " Clients!Name =...

Thanks foolio12 it works perfectly.

forgot to add that i will supply a file path and it should open the folder in which this file is contained. Thanks.

Hi, does anyone know if it is possible to access a folder (e.g. myDocuments) from access. All it should do is to open the folder and allow the user to view or open files within it. Does not need to store anything in the database. Thanx!

Thanks for the reply, now i have another problem though. i tried everything possible to solve it: NO CHANCE. On the same form i have a cmd button that allows the user to find a client. By clicking ok all the clients details are displayed on the main form. There are different ways that i tried...

Hi,does anyone know if it is possible to close the connection (cnn.close) and still be able to retrieve or navigate the recordset? I have class that when initialized it open the connection and the recordset. However, until that recordset is open i cannot manipulate it from other forms...