Bismillahirrohmanirrohim..., Ikut nimbrung. Bisa dicoba menggukan event: Dim var As Variant Dim rs As Recordset If tgl <> "" And pint <> "" Then Set rs = CurrentDb.OpenRecordset("select ID from namaTabel where DateValue(Tgl_Masuk)=#" _ & Format(textboxtgldiForm, "mm/dd/yyyy") & "# and Nama='" & textboxNamadiForm.Value & "'") If Not rs.EOF Then var = textboxNamadiForm & " Sudah terekam tanggal " & textboxtgldiForm & " dg id " & rs.Fields(0) Else var = "Tidak ada data" End If rs.Close Set rs = Nothing MsgBox var End If Semoga bisa membantu dan memberi semangat. Hariyanto (Surabaya) --- On Wed, 10/4/13, hasimnurhsm@yahoo.com <hasimnurhsm@yahoo.com> wrote:
|
__._,_.___
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar