ACCESS FEED: Re: [belajar-access] (unknown)

Selasa, 09 September 2014

Re: [belajar-access] (unknown)

Pencarian pada field tanggal bisa memakai sql seperti ini:

Me.RecordSource = "select * from libur" _
& " where dino=#" _
& Format("01/01/2014", for_date) & "#"

Sedangkan for_date sendiri:

Function for_date()
Dim xx As Variant

xx = CInt(Left(CStr(DateSerial(2012, 1, 2)), 2))
xx = Replace(xx, "/", "")
If CInt(xx) <= 2 Then
for_date = "yyyy/mm/dd"
Else
for_date = "mm/dd/yyyy"
End If
End Function

Semoga bisa membantu dan memberi semangat.

Hariyanto (Surabaya)

--------------------------------------------
On Sat, 6/9/14, MAULANA - maulana_pup@yahoo.co.id [belajar-access] <belajar-access@yahoogroups.com> wrote:

Subject: [belajar-access] (unknown)
To: belajar-access@yahoogroups.com
Date: Saturday, 6 September, 2014, 2:55 PM

Dear
Milistabel1
yang isinya a.l
Tanggal :
01/09/14
HT : 015
Nopol :
12345
Crew : udin

Tanggal : 03/09/14
HT : 015
Nopol : 12345
Crew : Udin

Tanggal ; 04/09/14
HT :015
Nopol:12345
Crew:Udin

untuk menupdate jika salah input saya buatkan
form tersendiri
dengan cara mengacu pada
tanggal..
jika tanggal di input akan
menampilkan data yang dibutuhkan...
adakah
yg dapat membantu..
saya sudah buat dengan
cara acuan Ht tetapi tampil data yang tanggal awal
salam
Maulana

#yiv4879217876 #yiv4879217876 --

#yiv4879217876ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv4879217876 #yiv4879217876ygrp-mkp hr {

border:1px solid #d8d8d8;}

#yiv4879217876 #yiv4879217876ygrp-mkp #yiv4879217876hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv4879217876 #yiv4879217876ygrp-mkp #yiv4879217876ads {
margin-bottom:10px;}

#yiv4879217876 #yiv4879217876ygrp-mkp .yiv4879217876ad {
padding:0 0;}

#yiv4879217876 #yiv4879217876ygrp-mkp .yiv4879217876ad p {
margin:0;}

#yiv4879217876 #yiv4879217876ygrp-mkp .yiv4879217876ad a {
color:#0000ff;text-decoration:none;}
#yiv4879217876 #yiv4879217876ygrp-sponsor
#yiv4879217876ygrp-lc {
font-family:Arial;}

#yiv4879217876 #yiv4879217876ygrp-sponsor
#yiv4879217876ygrp-lc #yiv4879217876hd {

margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv4879217876 #yiv4879217876ygrp-sponsor
#yiv4879217876ygrp-lc .yiv4879217876ad {
margin-bottom:10px;padding:0 0;}

#yiv4879217876 #yiv4879217876actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv4879217876 #yiv4879217876activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv4879217876 #yiv4879217876activity span {
font-weight:700;}

#yiv4879217876 #yiv4879217876activity span:first-child {
text-transform:uppercase;}

#yiv4879217876 #yiv4879217876activity span a {
color:#5085b6;text-decoration:none;}

#yiv4879217876 #yiv4879217876activity span span {
color:#ff7900;}

#yiv4879217876 #yiv4879217876activity span
.yiv4879217876underline {
text-decoration:underline;}

#yiv4879217876 .yiv4879217876attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv4879217876 .yiv4879217876attach div a {
text-decoration:none;}

#yiv4879217876 .yiv4879217876attach img {
border:none;padding-right:5px;}

#yiv4879217876 .yiv4879217876attach label {
display:block;margin-bottom:5px;}

#yiv4879217876 .yiv4879217876attach label a {
text-decoration:none;}

#yiv4879217876 blockquote {
margin:0 0 0 4px;}

#yiv4879217876 .yiv4879217876bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv4879217876 .yiv4879217876bold a {
text-decoration:none;}

#yiv4879217876 dd.yiv4879217876last p a {
font-family:Verdana;font-weight:700;}

#yiv4879217876 dd.yiv4879217876last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv4879217876 dd.yiv4879217876last p
span.yiv4879217876yshortcuts {
margin-right:0;}

#yiv4879217876 div.yiv4879217876attach-table div div a {
text-decoration:none;}

#yiv4879217876 div.yiv4879217876attach-table {
width:400px;}

#yiv4879217876 div.yiv4879217876file-title a, #yiv4879217876
div.yiv4879217876file-title a:active, #yiv4879217876
div.yiv4879217876file-title a:hover, #yiv4879217876
div.yiv4879217876file-title a:visited {
text-decoration:none;}

#yiv4879217876 div.yiv4879217876photo-title a,
#yiv4879217876 div.yiv4879217876photo-title a:active,
#yiv4879217876 div.yiv4879217876photo-title a:hover,
#yiv4879217876 div.yiv4879217876photo-title a:visited {
text-decoration:none;}

#yiv4879217876 div#yiv4879217876ygrp-mlmsg
#yiv4879217876ygrp-msg p a span.yiv4879217876yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv4879217876 .yiv4879217876green {
color:#628c2a;}

#yiv4879217876 .yiv4879217876MsoNormal {
margin:0 0 0 0;}

#yiv4879217876 o {
font-size:0;}

#yiv4879217876 #yiv4879217876photos div {
float:left;width:72px;}

#yiv4879217876 #yiv4879217876photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv4879217876 #yiv4879217876photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv4879217876 #yiv4879217876reco-category {
font-size:77%;}

#yiv4879217876 #yiv4879217876reco-desc {
font-size:77%;}

#yiv4879217876 .yiv4879217876replbq {
margin:4px;}

#yiv4879217876 #yiv4879217876ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv4879217876 #yiv4879217876ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv4879217876 #yiv4879217876ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv4879217876 #yiv4879217876ygrp-mlmsg select,
#yiv4879217876 input, #yiv4879217876 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv4879217876 #yiv4879217876ygrp-mlmsg pre, #yiv4879217876
code {
font:115% monospace;}

#yiv4879217876 #yiv4879217876ygrp-mlmsg * {
line-height:1.22em;}

#yiv4879217876 #yiv4879217876ygrp-mlmsg #yiv4879217876logo {
padding-bottom:10px;}

#yiv4879217876 #yiv4879217876ygrp-msg p a {
font-family:Verdana;}

#yiv4879217876 #yiv4879217876ygrp-msg
p#yiv4879217876attach-count span {

color:#1E66AE;font-weight:700;}

#yiv4879217876 #yiv4879217876ygrp-reco

#yiv4879217876reco-head {
color:#ff7900;font-weight:700;}

#yiv4879217876 #yiv4879217876ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv4879217876 #yiv4879217876ygrp-sponsor #yiv4879217876ov
li a {
font-size:130%;text-decoration:none;}

#yiv4879217876 #yiv4879217876ygrp-sponsor #yiv4879217876ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv4879217876 #yiv4879217876ygrp-sponsor #yiv4879217876ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv4879217876 #yiv4879217876ygrp-text {
font-family:Georgia;}

#yiv4879217876 #yiv4879217876ygrp-text p {
margin:0 0 1em 0;}

#yiv4879217876 #yiv4879217876ygrp-text tt {
font-size:120%;}

#yiv4879217876 #yiv4879217876ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv4879217876