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 "\"

But in my case I have more than a hundred registrations, which means lots of different links, which means I would need hundreds of Command Buttons... But anyway, since I have the links on the database I could just as soon I selected a row, atribute its link to a textbox and follow it...but then...

OKay. Looks like we don't use percentage (%) on VBA on the LIKE Statment, but asterisks (*) So, the right statment would be: SQL = "SELECT * FROM Ricoh WHERE ([Ricoh.Model] Like '*" & Forms!Ricoh.txtNP & "*');"

Problem resolved. Thank you though ,people.

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 " &...