Senin, 03 Desember 2012

Re: [belajar-access] menghitung umur dan membuat report umur

 


terimakasih banyak pak atas bantuannya. dan berjalan dengan baik di dabes saya
From: Sumiyanto Surabaya <sumiyanto@live.com>
To: belajar-access@yahoogroups.com
Sent: Wednesday, November 28, 2012 8:39 AM
Subject: RE: [belajar-access] menghitung umur dan membuat report umur [1 Attachment]

 
Dear mas HaDi SyaH,

Bisa dibuat dengan query sbb;
 
SELECT Master.ID, Master.Nama, Master.RT, Master.[Tempat Lahir], Master.[Tanggal Lahir], DateDiff("yyyy",[Tanggal lahir],Now()) AS UMUR, IIf([umur]<5,"1-4 tahun",IIf([umur]<11,"5-10 tahun",IIf([umur]<60,"11-60 tahun",""))) AS [Kategori Umur]
FROM Master;
Query1
ID
Nama
RT
Tempat Lahir
Tanggal Lahir
UMUR
Kategori Umur
1
A. SAHABUDDIN
1
gbsms
Wednesday, September 15, 1971
41
11-60 tahun
2
KASMIAWATI
1
snhsk
Thursday, October 19, 1972
40
11-60 tahun
3
A. ALMIRA KAYSA NUR FATIHA
1
bkgsak
Tuesday, September 16, 2008
4
1-4 tahun
4
PATRIANSYAH
5
hksagk
Monday, August 30, 1999
13
11-60 tahun
5
ASPIYATI
5
jhashsoil
Tuesday, October 20, 1987
25
11-60 tahun
6
ANISA
5
kjakghks
Sunday, July 01, 2001
11
11-60 tahun
7
RESA LINDA
5
klkas
Thursday, July 01, 2004
8
5-10 tahun
8
AHMAD SUWENDI
10
nanl
Friday, July 13, 1984
28
11-60 tahun
9
NURSEHAN LISSARI
10
njkhalk
Friday, July 24, 1981
31
11-60 tahun
 
·         DateDiff("yyyy",[Tanggal lahir],Now()) untuk menghitung umur dengan membandingkan tanggal lahir dengan tanggal database computer saat ini.
·         IIf([umur]<5,"1-4 tahun",IIf([umur]<11,"5-10 tahun",IIf([umur]<60,"11-60 tahun",""))) AS [Kategori Umur], mengelompokkan umur dengan memanfaatkan fungsi iif.
 
 
Design reportnya seperti terlampir.
Hasil reportnya akan tampak spt di bawah ini;
 
 
Salam,
 
Sumiyanto Surabaya
 
http://cakyanto.wordpress.com/
http://mugi.or.id/blogs/sumiyanto/
 
 
 
From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of HaDi SyaH
Sent: Tuesday, November 27, 2012 10:54 AM
To: belajar-access@yahoogroups.com
Subject: [belajar-access] menghitung umur dan membuat report umur [1 Attachment]
 
 
[Attachment(s) from HaDi SyaH included below]
dear para master access

saya menggunakan access 2010, yang ingin saya tanyakan :

1. bagaimana membuat field umur pada tabel secara otomatis mengikuti tanggal pada saat membuka dabes accer.

2. bagaimana membuat report umur berdasarkan kriteria misalnya
umur 1-4 tahun berjumlah ...., umur 5-10 tahun berjumlah .... dst.

untuk bahan pertimbangan para master saya lampirkan file dabesnya. terimakasih sebelumnya.


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Bls: [belajar-access] proses simpan data

 

Salam Access...


Pengalaman saya waktu membuat prosedur simpan seperti itu memang tetap tersimpan meskipun user pilih NO, terjadi jika :
"Menggunakan tabel yang sama antara waktu input dan editing"
Akhirnya saya akali menggunakan tabel sementara dengan struktur sama dengan tabel tempat menyimpan data, jadi jika pilihan user :
Yes = data di tabel sementara disimpan ke tabel penyimpan data (menggunakan append query)
No = data di tabel sementara dihapus saja (menggunakan query delete)
Setelah user klik tombol (baik Yes atau No), jangan lupa hapus juga isi tabel sementara (apapun yang terjadi, menggunakn query delete) sehingga untuk even selanjutnya, dipastikan tabel sementara selalu kosong kembali, cara ini menurut saya lebih praktis dan mudah.
 
Demikian semoga membantu...

Best Regards,


Sukiono
PT. Kumala Kencana Cipta
www.kumalahome.com

Dari: mac ba <macba2000id@yahoo.com>
Kepada: belajar-access@yahoogroups.com
Dikirim: Jumat, 30 November 2012 13:45
Judul: Re: [belajar-access] proses simpan data

 
Bismillah..
Semoga membantu ya pak..

coba ketik aja coding dibawah ini (yg biasa saya buat) di tombol "simpan" nya dgn event nya "on click" :

On Error Resume Next
dim y
y = msgbox("Apakah anda akan menyimpan data ini ??",vbyesno,"Konfirmasi")
if y=vbyes then
     docmd.save
    me.refresh
    me.caption="Data Sudah Tersimpan"
else
    me.refresh
end if

























--- On Thu, 11/29/12, urangbangka dakawa <urangbangka@yahoo.com> wrote:

From: urangbangka dakawa <urangbangka@yahoo.com>
Subject: [belajar-access] proses simpan data [1 Attachment]
To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Date: Thursday, November 29, 2012, 8:36 AM

 


Slm kenal mas, sy br belajar ms access,mhn bantuannya dmn dlm program yg sy buat msh terdapat error yaitu pd proses simpan data,ketika tombol simpan diklik akan muncul pesan apakah data akan disimpan,saat memilih 'No' seharusnya data TIDAK tersimpan,tetapi data tetap juga tersimpan,mhn bantuannya,terima kasih..




__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[belajar-access] tanya (cara menjalankan query uppend scr otomatis)

 

slamat siang semuanya....mhon bantuannya..bagai mana cara menjalankan  query uppend scr otomatis??
thnks.....
 








__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] Format Date Field in a report to another language

 

Hi Jonathan

The function you want is FormatDateTimeIntl - about halfway down.

You need to know the locale code (LCID) for the country/language you want to
use.

--Graham

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jrv2110
Sent: Tuesday, 4 December 2012 13:32
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Format Date Field in a report to another
language

Hi Graham,

I looked it over and can't say I was able to spot the code for formating a
date to a specific language... But thanks for the reference. It contains a
lot of codes.

Jonathan

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Graham Mandeno"
<graham@...> wrote:
>
> Hi Jonathan
>
>
>
> Michael Kaplan (MichKa - ex MVP and now MS employee) has done a lot of
work
> on international coding. This might be enough to get you started:
>
> http://www.trigeminal.com/lang/1033/codes.asp?ItemID=7
>
>
>
> Good luck! :)
>
> Graham
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of jrv2110
> Sent: Tuesday, 4 December 2012 11:24
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Format Date Field in a report to another language
>
>
>
>
>
> Hi guys,
>
> I was wondering it there was a way to format a date field in a report to a
> specific language format without having to change the language format of
my
> operating system.
>
> Example:
>
> The current field in the report is called [date]
>
> When in the report it displays as
> (Monday, December 3, 2012)
>
> I want to change that particular form to show it in spanish as
> (Lunes, 3 de diciembre de 2012)
>
> In order to do this, what would the text box have to say in regards to
> adding to:
> =[date]
>
> Thanks in advance!
>
> Jonathan
> Running:
> Microsoft Access 2010
> Windows 7 Ultimate
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [belajar-access] kombinasi 5 huruf menjadi 4 digit

 

5! = 1 x 2  x 3 x 4 x 5 = 120 kombinasi.

Salam,

Edi Rosadi

Application Developer & Consultant


Website/Blog :
Algoritma dan Pemrograman

Peta Industri dan Wisata Cilegon
Blog Bahasa Cilegon

Facebook-Perancangan Sistem 

 

  

komersilkan blog atau website anda dengan bergabung di sini atau di sini

 





--- On Fri, 30/11/12, Hobys Mengamati <hobysmengamati@yahoo.com> wrote:

From: Hobys Mengamati <hobysmengamati@yahoo.com>
Subject: [belajar-access] kombinasi 5 huruf menjadi 4 digit
To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Date: Friday, 30 November, 2012, 7:14 PM

 

mas, kalo mau kombinasi 5 huruf ABCDE menjadi 4 digit, ada brapa kemungkinan, mis: ABCD ABCE ABDE dst? trims

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

Re: [MS_AccessPros] Format Date Field in a report to another language

 

Hi Graham,

I looked it over and can't say I was able to spot the code for formating a date to a specific language... But thanks for the reference. It contains a lot of codes.

Jonathan

--- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@...> wrote:
>
> Hi Jonathan
>
>
>
> Michael Kaplan (MichKa - ex MVP and now MS employee) has done a lot of work
> on international coding. This might be enough to get you started:
>
> http://www.trigeminal.com/lang/1033/codes.asp?ItemID=7
>
>
>
> Good luck! :)
>
> Graham
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jrv2110
> Sent: Tuesday, 4 December 2012 11:24
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Format Date Field in a report to another language
>
>
>
>
>
> Hi guys,
>
> I was wondering it there was a way to format a date field in a report to a
> specific language format without having to change the language format of my
> operating system.
>
> Example:
>
> The current field in the report is called [date]
>
> When in the report it displays as
> (Monday, December 3, 2012)
>
> I want to change that particular form to show it in spanish as
> (Lunes, 3 de diciembre de 2012)
>
> In order to do this, what would the text box have to say in regards to
> adding to:
> =[date]
>
> Thanks in advance!
>
> Jonathan
> Running:
> Microsoft Access 2010
> Windows 7 Ultimate
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] Format Date Field in a report to another language

 

Hi Jonathan

Michael Kaplan (MichKa - ex MVP and now MS employee) has done a lot of work
on international coding. This might be enough to get you started:

http://www.trigeminal.com/lang/1033/codes.asp?ItemID=7

Good luck! :)

Graham

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jrv2110
Sent: Tuesday, 4 December 2012 11:24
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Format Date Field in a report to another language

Hi guys,

I was wondering it there was a way to format a date field in a report to a
specific language format without having to change the language format of my
operating system.

Example:

The current field in the report is called [date]

When in the report it displays as
(Monday, December 3, 2012)

I want to change that particular form to show it in spanish as
(Lunes, 3 de diciembre de 2012)

In order to do this, what would the text box have to say in regards to
adding to:
=[date]

Thanks in advance!

Jonathan
Running:
Microsoft Access 2010
Windows 7 Ultimate

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)