Mantap pak hariyanto makasih banyak
... Pak Darsono muantap juga.. Bisa kah kasih saya contoh Filenya. Rasanya klo punya duit bnyak mau ikut training jg ..
... Pak Darsono muantap juga.. Bisa kah kasih saya contoh Filenya. Rasanya klo punya duit bnyak mau ikut training jg ..
Dari: Darsono darsono72@yahoo.com [belajar-access]
Terkirim: 06/06/2015 21:52
Kepada: belajar-access@yahoogroups.com
Subjek: Re: [belajar-access] Papan informasi digital seperti di Bandara [3 Attachments]
Nambah dikit dari yang disampaikan bang hari yanto,
dulu saya pernah pakai,
saya memanfaatkan timer dan docmd.gotonext record.
dan lumayan bagus.
sekedar untuk inspirasi silahkan intip di sini:
kalau ga sempet ada di attachment
Darsono
esia : 021-9344-0898
Simpati : 0812-8670-1010
M3 : 0856-878-1010
FB : Darsono Kroya
Twitter : @darsono72
esia : 021-9344-0898
Simpati : 0812-8670-1010
M3 : 0856-878-1010
FB : Darsono Kroya
Twitter : @darsono72
BB : 5570F542
On Sunday, May 31, 2015 12:48 PM, "hari yanto har_i20002000@yahoo.com [belajar-access]" <belajar-access@yahoogroups.com> wrote:
[Attachment(s) from hari yanto har_i20002000@yahoo.com [belajar-access] included below]
Untuk membuat papan nama seperti yang terjadi Bandara, setidaknya kita harus memiliki Tabel berupa informasi yang akan disampaikan ke user.
Seperti papan di bandara, kita harus memutuskan:
1. Jumlah record yang akan ditampillkan ke user
2. Jedah waktu up date tampilan
Misal, kita punya tabel bernama t, jumlah record yang akan ditampilkan 4, dan jedah waktu update 1 detik (6000), maka pada form, kita dapat memanfaatkan form timer dan intervaltimer.
Pada saat awal, kita langsung putuskan yang ditampilkan awal adalah yang pertama, selanjutnya ke-2 sampai paling akhir.
itu kerangka berpikirnya. Eksekusi dalam bentuk mdb, bisa dilihat di lampiran.
Semoga bisa membantu dan memberi semangar.
Hariyanto (Surabaya)
--------------------------------------------
On Sat, 30/5/15, Mukti Alie muktifarhan02@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> wrote:
Subject: [belajar-access] Papan informasi digital seperti di Bandara
To: belajar-access@yahoogroups.com
Date: Saturday, 30 May, 2015, 7:48 AM
Bapak 2 apakah Ms Access dapat
dibuat Formnya seperti di Papan informasi keberangkatan
pesawat. Jadi datanya dapat berubah2.. Dapat ter update
beberapa detik.. Mohon bantuannya dan contoh
Filenya..
#yiv4235794540 #yiv4235794540 --
#yiv4235794540ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv4235794540 #yiv4235794540ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv4235794540 #yiv4235794540ygrp-mkp #yiv4235794540hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv4235794540 #yiv4235794540ygrp-mkp #yiv4235794540ads {
margin-bottom:10px;}
#yiv4235794540 #yiv4235794540ygrp-mkp .yiv4235794540ad {
padding:0 0;}
#yiv4235794540 #yiv4235794540ygrp-mkp .yiv4235794540ad p {
margin:0;}
#yiv4235794540 #yiv4235794540ygrp-mkp .yiv4235794540ad a {
color:#0000ff;text-decoration:none;}
#yiv4235794540 #yiv4235794540ygrp-sponsor
#yiv4235794540ygrp-lc {
font-family:Arial;}
#yiv4235794540 #yiv4235794540ygrp-sponsor
#yiv4235794540ygrp-lc #yiv4235794540hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv4235794540 #yiv4235794540ygrp-sponsor
#yiv4235794540ygrp-lc .yiv4235794540ad {
margin-bottom:10px;padding:0 0;}
#yiv4235794540 #yiv4235794540actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv4235794540 #yiv4235794540activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv4235794540 #yiv4235794540activity span {
font-weight:700;}
#yiv4235794540 #yiv4235794540activity span:first-child {
text-transform:uppercase;}
#yiv4235794540 #yiv4235794540activity span a {
color:#5085b6;text-decoration:none;}
#yiv4235794540 #yiv4235794540activity span span {
color:#ff7900;}
#yiv4235794540 #yiv4235794540activity span
.yiv4235794540underline {
text-decoration:underline;}
#yiv4235794540 .yiv4235794540attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv4235794540 .yiv4235794540attach div a {
text-decoration:none;}
#yiv4235794540 .yiv4235794540attach img {
border:none;padding-right:5px;}
#yiv4235794540 .yiv4235794540attach label {
display:block;margin-bottom:5px;}
#yiv4235794540 .yiv4235794540attach label a {
text-decoration:none;}
#yiv4235794540 blockquote {
margin:0 0 0 4px;}
#yiv4235794540 .yiv4235794540bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv4235794540 .yiv4235794540bold a {
text-decoration:none;}
#yiv4235794540 dd.yiv4235794540last p a {
font-family:Verdana;font-weight:700;}
#yiv4235794540 dd.yiv4235794540last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv4235794540 dd.yiv4235794540last p
span.yiv4235794540yshortcuts {
margin-right:0;}
#yiv4235794540 div.yiv4235794540attach-table div div a {
text-decoration:none;}
#yiv4235794540 div.yiv4235794540attach-table {
width:400px;}
#yiv4235794540 div.yiv4235794540file-title a, #yiv4235794540
div.yiv4235794540file-title a:active, #yiv4235794540
div.yiv4235794540file-title a:hover, #yiv4235794540
div.yiv4235794540file-title a:visited {
text-decoration:none;}
#yiv4235794540 div.yiv4235794540photo-title a,
#yiv4235794540 div.yiv4235794540photo-title a:active,
#yiv4235794540 div.yiv4235794540photo-title a:hover,
#yiv4235794540 div.yiv4235794540photo-title a:visited {
text-decoration:none;}
#yiv4235794540 div#yiv4235794540ygrp-mlmsg
#yiv4235794540ygrp-msg p a span.yiv4235794540yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv4235794540 .yiv4235794540green {
color:#628c2a;}
#yiv4235794540 .yiv4235794540MsoNormal {
margin:0 0 0 0;}
#yiv4235794540 o {
font-size:0;}
#yiv4235794540 #yiv4235794540photos div {
float:left;width:72px;}
#yiv4235794540 #yiv4235794540photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv4235794540 #yiv4235794540photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv4235794540 #yiv4235794540reco-category {
font-size:77%;}
#yiv4235794540 #yiv4235794540reco-desc {
font-size:77%;}
#yiv4235794540 .yiv4235794540replbq {
margin:4px;}
#yiv4235794540 #yiv4235794540ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg select,
#yiv4235794540 input, #yiv4235794540 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg pre, #yiv4235794540
code {
font:115% monospace;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg * {
line-height:1.22em;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg #yiv4235794540logo {
padding-bottom:10px;}
#yiv4235794540 #yiv4235794540ygrp-msg p a {
font-family:Verdana;}
#yiv4235794540 #yiv4235794540ygrp-msg
p#yiv4235794540attach-count span {
color:#1E66AE;font-weight:700;}
#yiv4235794540 #yiv4235794540ygrp-reco
#yiv4235794540reco-head {
color:#ff7900;font-weight:700;}
#yiv4235794540 #yiv4235794540ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv4235794540 #yiv4235794540ygrp-sponsor #yiv4235794540ov
li a {
font-size:130%;text-decoration:none;}
#yiv4235794540 #yiv4235794540ygrp-sponsor #yiv4235794540ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv4235794540 #yiv4235794540ygrp-sponsor #yiv4235794540ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv4235794540 #yiv4235794540ygrp-text {
font-family:Georgia;}
#yiv4235794540 #yiv4235794540ygrp-text p {
margin:0 0 1em 0;}
#yiv4235794540 #yiv4235794540ygrp-text tt {
font-size:120%;}
#yiv4235794540 #yiv4235794540ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv4235794540
Seperti papan di bandara, kita harus memutuskan:
1. Jumlah record yang akan ditampillkan ke user
2. Jedah waktu up date tampilan
Misal, kita punya tabel bernama t, jumlah record yang akan ditampilkan 4, dan jedah waktu update 1 detik (6000), maka pada form, kita dapat memanfaatkan form timer dan intervaltimer.
Pada saat awal, kita langsung putuskan yang ditampilkan awal adalah yang pertama, selanjutnya ke-2 sampai paling akhir.
itu kerangka berpikirnya. Eksekusi dalam bentuk mdb, bisa dilihat di lampiran.
Semoga bisa membantu dan memberi semangar.
Hariyanto (Surabaya)
--------------------------------------------
On Sat, 30/5/15, Mukti Alie muktifarhan02@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> wrote:
Subject: [belajar-access] Papan informasi digital seperti di Bandara
To: belajar-access@yahoogroups.com
Date: Saturday, 30 May, 2015, 7:48 AM
Bapak 2 apakah Ms Access dapat
dibuat Formnya seperti di Papan informasi keberangkatan
pesawat. Jadi datanya dapat berubah2.. Dapat ter update
beberapa detik.. Mohon bantuannya dan contoh
Filenya..
#yiv4235794540 #yiv4235794540 --
#yiv4235794540ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv4235794540 #yiv4235794540ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv4235794540 #yiv4235794540ygrp-mkp #yiv4235794540hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv4235794540 #yiv4235794540ygrp-mkp #yiv4235794540ads {
margin-bottom:10px;}
#yiv4235794540 #yiv4235794540ygrp-mkp .yiv4235794540ad {
padding:0 0;}
#yiv4235794540 #yiv4235794540ygrp-mkp .yiv4235794540ad p {
margin:0;}
#yiv4235794540 #yiv4235794540ygrp-mkp .yiv4235794540ad a {
color:#0000ff;text-decoration:none;}
#yiv4235794540 #yiv4235794540ygrp-sponsor
#yiv4235794540ygrp-lc {
font-family:Arial;}
#yiv4235794540 #yiv4235794540ygrp-sponsor
#yiv4235794540ygrp-lc #yiv4235794540hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv4235794540 #yiv4235794540ygrp-sponsor
#yiv4235794540ygrp-lc .yiv4235794540ad {
margin-bottom:10px;padding:0 0;}
#yiv4235794540 #yiv4235794540actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv4235794540 #yiv4235794540activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv4235794540 #yiv4235794540activity span {
font-weight:700;}
#yiv4235794540 #yiv4235794540activity span:first-child {
text-transform:uppercase;}
#yiv4235794540 #yiv4235794540activity span a {
color:#5085b6;text-decoration:none;}
#yiv4235794540 #yiv4235794540activity span span {
color:#ff7900;}
#yiv4235794540 #yiv4235794540activity span
.yiv4235794540underline {
text-decoration:underline;}
#yiv4235794540 .yiv4235794540attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv4235794540 .yiv4235794540attach div a {
text-decoration:none;}
#yiv4235794540 .yiv4235794540attach img {
border:none;padding-right:5px;}
#yiv4235794540 .yiv4235794540attach label {
display:block;margin-bottom:5px;}
#yiv4235794540 .yiv4235794540attach label a {
text-decoration:none;}
#yiv4235794540 blockquote {
margin:0 0 0 4px;}
#yiv4235794540 .yiv4235794540bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv4235794540 .yiv4235794540bold a {
text-decoration:none;}
#yiv4235794540 dd.yiv4235794540last p a {
font-family:Verdana;font-weight:700;}
#yiv4235794540 dd.yiv4235794540last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv4235794540 dd.yiv4235794540last p
span.yiv4235794540yshortcuts {
margin-right:0;}
#yiv4235794540 div.yiv4235794540attach-table div div a {
text-decoration:none;}
#yiv4235794540 div.yiv4235794540attach-table {
width:400px;}
#yiv4235794540 div.yiv4235794540file-title a, #yiv4235794540
div.yiv4235794540file-title a:active, #yiv4235794540
div.yiv4235794540file-title a:hover, #yiv4235794540
div.yiv4235794540file-title a:visited {
text-decoration:none;}
#yiv4235794540 div.yiv4235794540photo-title a,
#yiv4235794540 div.yiv4235794540photo-title a:active,
#yiv4235794540 div.yiv4235794540photo-title a:hover,
#yiv4235794540 div.yiv4235794540photo-title a:visited {
text-decoration:none;}
#yiv4235794540 div#yiv4235794540ygrp-mlmsg
#yiv4235794540ygrp-msg p a span.yiv4235794540yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv4235794540 .yiv4235794540green {
color:#628c2a;}
#yiv4235794540 .yiv4235794540MsoNormal {
margin:0 0 0 0;}
#yiv4235794540 o {
font-size:0;}
#yiv4235794540 #yiv4235794540photos div {
float:left;width:72px;}
#yiv4235794540 #yiv4235794540photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv4235794540 #yiv4235794540photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv4235794540 #yiv4235794540reco-category {
font-size:77%;}
#yiv4235794540 #yiv4235794540reco-desc {
font-size:77%;}
#yiv4235794540 .yiv4235794540replbq {
margin:4px;}
#yiv4235794540 #yiv4235794540ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg select,
#yiv4235794540 input, #yiv4235794540 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg pre, #yiv4235794540
code {
font:115% monospace;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg * {
line-height:1.22em;}
#yiv4235794540 #yiv4235794540ygrp-mlmsg #yiv4235794540logo {
padding-bottom:10px;}
#yiv4235794540 #yiv4235794540ygrp-msg p a {
font-family:Verdana;}
#yiv4235794540 #yiv4235794540ygrp-msg
p#yiv4235794540attach-count span {
color:#1E66AE;font-weight:700;}
#yiv4235794540 #yiv4235794540ygrp-reco
#yiv4235794540reco-head {
color:#ff7900;font-weight:700;}
#yiv4235794540 #yiv4235794540ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv4235794540 #yiv4235794540ygrp-sponsor #yiv4235794540ov
li a {
font-size:130%;text-decoration:none;}
#yiv4235794540 #yiv4235794540ygrp-sponsor #yiv4235794540ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv4235794540 #yiv4235794540ygrp-sponsor #yiv4235794540ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv4235794540 #yiv4235794540ygrp-text {
font-family:Georgia;}
#yiv4235794540 #yiv4235794540ygrp-text p {
margin:0 0 1em 0;}
#yiv4235794540 #yiv4235794540ygrp-text tt {
font-size:120%;}
#yiv4235794540 #yiv4235794540ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv4235794540
__._,_.___
Posted by: Mukti Alie <muktifarhan02@yahoo.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar