Search results

RESOLVED Private Sub ListBox_Click() Link = Replace(Replace(Me.ListBox.Column(2), "file://///", "\\"), "/", "\") Application.FollowHyperlink Link, , True End Sub Since I didn't have IIS running on the central server, I have to replace the "file://///" to "\\" and all the "/" to "\"...

RESOLVED Hi, I'm having a problem with a SQL Statment. I have a ListBox which has 5 columns filled with text from the table "Test" Private Sub cmdNP_Click() If IsNull(Me.txtNP) Then MsgBox "Missing Text" Else SQL = "SELECT * FROM Ricoh WHERE ([Ricoh.model] LIKE " &...