--------------------------------------------
Pada Sen, 22/9/14, hari yanto har_i20002000@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> menulis:
Judul: Re: [belajar-access] Bagaimana cara mereset autonumber jika tahun berganti
Kepada: belajar-access@yahoogroups.com
Tanggal: Senin, 22 September, 2014, 12:41 PM
kalo gitu engga usah pake autonumber aja ya mas
kalo nampilin nomor yg sebelumnya gimana ya mas?supaya kita engga ngulang nomor yg udah ada
yogapersib33...,
Type data autonumber, tidak bisa direset. Dia akan terus
bertambah sesuai data yang dientrykan. kalau salah satu data
terhapus, autonumber akan meloncat.
Menurut saya untuk nomor yang dikaitkan dengan tahun (tahun
berganti, nomor balik lagi 1), harus dibuat field
tersendiri. Namun harus tetap ada filed id yang berfungsi
sebagai identitas unik. Sehingga waktu pengambilan/editing
data tidak salah sasaran.
Misal
id no_su th_berjalan
1 1 2013
2 2 2013
3 3 2013
4 4 2013
5 5 2013
6 6 2013
7 7 2013
8 8 2013
9 1 2014
10 2 2014
11 3 2014
12 4 2014
13 5 2014
14 6 2014
Nah, untuk melihat nilai surat dan id tertinggi, bisa
menggunakan script ini (misal nama tabelnya t1):
Dim t, x As Integer
t = Nz(DLookup("[no_su]", "t1",
"[th_berjalan]=" & Year(Date)), 0) + 1
x = Nz(DMax("[id]", "t1",
""), 0) + 1
Nilai t dan x inilah yang lantas kita insertkan ke tabel
t1.
Semoga bisa membantu dan memberi semangat.
Hariyanto (Surabaya)
--------------------------------------------
On Mon, 22/9/14, yogapersib33@yahoo.com [belajar-access]
<belajar-access@yahoogroups.com> wrote:
Subject: [belajar-access] Bagaimana cara mereset autonumber
jika tahun berganti
To: belajar-access@yahoogroups.com
Date: Monday, 22 September, 2014, 8:21 AM
maap semuanya saya mau nanya kalo
membuat autonumber dari angka 235 lalu dia mereset menjadi
0
lagi saat tahun berganti bagaimana caranya
ya?mohon penjelasannyaterima kasih
#yiv6687449048 #yiv6687449048 --
#yiv6687449048ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv6687449048 #yiv6687449048ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv6687449048 #yiv6687449048ygrp-mkp #yiv6687449048hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv6687449048 #yiv6687449048ygrp-mkp #yiv6687449048ads {
margin-bottom:10px;}
#yiv6687449048 #yiv6687449048ygrp-mkp .yiv6687449048ad {
padding:0 0;}
#yiv6687449048 #yiv6687449048ygrp-mkp .yiv6687449048ad p {
margin:0;}
#yiv6687449048 #yiv6687449048ygrp-mkp .yiv6687449048ad a {
color:#0000ff;text-decoration:none;}
#yiv6687449048 #yiv6687449048ygrp-sponsor
#yiv6687449048ygrp-lc {
font-family:Arial;}
#yiv6687449048 #yiv6687449048ygrp-sponsor
#yiv6687449048ygrp-lc #yiv6687449048hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv6687449048 #yiv6687449048ygrp-sponsor
#yiv6687449048ygrp-lc .yiv6687449048ad {
margin-bottom:10px;padding:0 0;}
#yiv6687449048 #yiv6687449048actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv6687449048 #yiv6687449048activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv6687449048 #yiv6687449048activity span {
font-weight:700;}
#yiv6687449048 #yiv6687449048activity span:first-child {
text-transform:uppercase;}
#yiv6687449048 #yiv6687449048activity span a {
color:#5085b6;text-decoration:none;}
#yiv6687449048 #yiv6687449048activity span span {
color:#ff7900;}
#yiv6687449048 #yiv6687449048activity span
.yiv6687449048underline {
text-decoration:underline;}
#yiv6687449048 .yiv6687449048attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv6687449048 .yiv6687449048attach div a {
text-decoration:none;}
#yiv6687449048 .yiv6687449048attach img {
border:none;padding-right:5px;}
#yiv6687449048 .yiv6687449048attach label {
display:block;margin-bottom:5px;}
#yiv6687449048 .yiv6687449048attach label a {
text-decoration:none;}
#yiv6687449048 blockquote {
margin:0 0 0 4px;}
#yiv6687449048 .yiv6687449048bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv6687449048 .yiv6687449048bold a {
text-decoration:none;}
#yiv6687449048 dd.yiv6687449048last p a {
font-family:Verdana;font-weight:700;}
#yiv6687449048 dd.yiv6687449048last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv6687449048 dd.yiv6687449048last p
span.yiv6687449048yshortcuts {
margin-right:0;}
#yiv6687449048 div.yiv6687449048attach-table div div a {
text-decoration:none;}
#yiv6687449048 div.yiv6687449048attach-table {
width:400px;}
#yiv6687449048 div.yiv6687449048file-title a, #yiv6687449048
div.yiv6687449048file-title a:active, #yiv6687449048
div.yiv6687449048file-title a:hover, #yiv6687449048
div.yiv6687449048file-title a:visited {
text-decoration:none;}
#yiv6687449048 div.yiv6687449048photo-title a,
#yiv6687449048 div.yiv6687449048photo-title a:active,
#yiv6687449048 div.yiv6687449048photo-title a:hover,
#yiv6687449048 div.yiv6687449048photo-title a:visited {
text-decoration:none;}
#yiv6687449048 div#yiv6687449048ygrp-mlmsg
#yiv6687449048ygrp-msg p a span.yiv6687449048yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv6687449048 .yiv6687449048green {
color:#628c2a;}
#yiv6687449048 .yiv6687449048MsoNormal {
margin:0 0 0 0;}
#yiv6687449048 o {
font-size:0;}
#yiv6687449048 #yiv6687449048photos div {
float:left;width:72px;}
#yiv6687449048 #yiv6687449048photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv6687449048 #yiv6687449048photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv6687449048 #yiv6687449048reco-category {
font-size:77%;}
#yiv6687449048 #yiv6687449048reco-desc {
font-size:77%;}
#yiv6687449048 .yiv6687449048replbq {
margin:4px;}
#yiv6687449048 #yiv6687449048ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv6687449048 #yiv6687449048ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv6687449048 #yiv6687449048ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv6687449048 #yiv6687449048ygrp-mlmsg select,
#yiv6687449048 input, #yiv6687449048 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv6687449048 #yiv6687449048ygrp-mlmsg pre, #yiv6687449048
code {
font:115% monospace;}
#yiv6687449048 #yiv6687449048ygrp-mlmsg * {
line-height:1.22em;}
#yiv6687449048 #yiv6687449048ygrp-mlmsg #yiv6687449048logo {
padding-bottom:10px;}
#yiv6687449048 #yiv6687449048ygrp-msg p a {
font-family:Verdana;}
#yiv6687449048 #yiv6687449048ygrp-msg
p#yiv6687449048attach-count span {
color:#1E66AE;font-weight:700;}
#yiv6687449048 #yiv6687449048ygrp-reco
#yiv6687449048reco-head {
color:#ff7900;font-weight:700;}
#yiv6687449048 #yiv6687449048ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv6687449048 #yiv6687449048ygrp-sponsor #yiv6687449048ov
li a {
font-size:130%;text-decoration:none;}
#yiv6687449048 #yiv6687449048ygrp-sponsor #yiv6687449048ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv6687449048 #yiv6687449048ygrp-sponsor #yiv6687449048ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv6687449048 #yiv6687449048ygrp-text {
font-family:Georgia;}
#yiv6687449048 #yiv6687449048ygrp-text p {
margin:0 0 1em 0;}
#yiv6687449048 #yiv6687449048ygrp-text tt {
font-size:120%;}
#yiv6687449048 #yiv6687449048ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv6687449048
Posted by: Yoga Persib <yogapersib33@yahoo.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar