QUOTE(ahmad_511 @ 14 Nov, 2007 - 02:57 AM)
Can you post the code here?, So we can better assist you to find the problem.
Waiting for reply.
Regards
hi! sorry for the very late reply.. anyway here's my code that I use to save new data..
CODE
Data1.Recordset.AddNew
Data1.Recordset.Fields("SUBJECT") = Text2.Text
Data1.Recordset.Fields("TOPIC") = Combo4
Data1.Recordset.Fields("UPDATE ON") = Text5.Text
Data1.Recordset.Fields("REF NO") = Text7.Text
Data1.Recordset.Fields("FOLDER") = Combo5.Text
Data1.Recordset.Fields("ISSUE DATE") = Text6.Text
Data1.Recordset.Fields("SIGNATORY") = Combo6.Text
Data1.Recordset.Fields("HYPERLINK") = Text9.Text
Data1.Recordset.Update
Label9.Refresh
MsgBox "Data has been saved", vbInformation + vbOKOnly, "Success"
Data1.Recordset.MoveLast
and here's the code that I use to open a pdf file using Label object
CODE
If Label9.Caption <> "" And Label9.Caption <> "-" Then
Label9.Refresh
hype = Label9.Caption
retval = ShellExecute(MEMOENTRY.hwnd, "Open", hype, 0&, 0&, 1)
Else
MsgBox "Invalid directory", vbCritical + vbOKOnly, "ERROR"
End If
Exit Sub
well, both are working great.. it's just that I will have to exit that particular screen before the newly added data especially the hyperlink will take effect.. usually, the hyperlink is in blue forecolor but if it is not active it is in black forecolor.. so everytime i save a new data, all hyperlinks are not active.. the thing is, i also have a delete button.. after deleting a certain record, it refreshes the hyperlinks without exiting the form.. im wondering how will i refresh the whole form without exiting the data.. help pls??
| 