/* */

Wednesday, January 9, 2013

[belajar-access] Re: Print Kertas Roll

 

Ikutan ya Cak Sumi..

mungkin kurang tanda ":"
jd coba lagi spt ini:

net use lpt1: \\yanto\epsonlx

Smoga berhasil :-D

> ----- Original Message -----
> From: Sumiyanto Surabaya
> To: belajar-access@yahoogroups.com
> Sent: Sunday, January 06, 2013 9:13 PM
> Subject: Re: [belajar-access] Re: Print Kertas Roll

> net use lpt1 \\yanto\epsonlx /persistent:yes
>
> sudah betul bang. itu copy paste dari prompt command. tetapi hasilnya masih nihil. apakah ada solusi lain..
> sambil besok saya cek lagi di pcnya, jika ada port paralel lpt1, terpaksa harus beli cable lpt1.
>
>
> btw... Thank you | Terima Kasih | Matur Suksema
>
> Sumiyanto
> http://cakyanto.wordpress.com/
> http://mugi.or.id/blogs/sumiyanto/
>
>
>
> From: aksan kurdin
> To: belajar-access@yahoogroups.com
> Sent: Sunday, 6 January 2013 5:21 PM
> Subject: Re: [belajar-access] Re: Print Kertas Roll
>
>
> ganti file://yanto/epsonlx dengan \\yanto\epsonlx bagaimana cak ?
>
> aksan kurdin
> On 1/6/2013 7:23 AM, Sumiyanto Surabaya wrote:
>
> C:\Documents and Settings\Yanto>net view file://yanto/
> Shared resources at file://yanto/
> Yanto
> Share name Type Used as Comment
> ----------------------------------------------------------
> AutoGest Print Auto Gestetner MPC2500/DSc525 RPCS on COM-3
> EpsonLX Print Epson LX-300+
> My Documents Disk
> Printer Print Microsoft XPS Document Writer
> Printer2 Print Microsoft Office Document Image Writer
> SALWA (D) Disk
> SharedDocs Disk
> The command completed successfully.
> C:\Documents and Settings\Yanto>net use lpt1 file://yanto/epsonlx /persistent:yesSystem error 85 has occurred.
> The local device name is already in use.
>
> bang sudah saya tembakkan ke share printer file://yanto/epsonlx di local pc tetapi tetap print lpt1 to usb tidak bisa berjalan. mengingat program kasir menggunakan printer type epson lx-300+ dan mobo nya hanya ada soket usb. mohon pencerahannya...
>
> Thank you | Terima Kasih | Matur Suksema
>
> Sumiyanto
> http://cakyanto.wordpress.com/
> http://mugi.or.id/blogs/sumiyanto/
>
>
> From: Aksan Kurdin mailto:aksan.kurdin@...
> To: belajar-access@yahoogroups.com
> Sent: Monday, 11 October 2010 3:46 PM
> Subject: Re: [belajar-access] Re: Print Kertas Roll
>
>
> kali ini anda harus perdalam rdbms-nya, kang cecep.desain database dan desain tampilan.sepertinya yang anda ingin cetak adalah transaksi customer, jadi yang bermain di query cukup header dan detail dari tabel transaksi, dengan customer sebagai lookup pelengkap data saja. pasang kriteria query ke text box form yang sedang di tunjuk sekarang.aksan kurdinOn 10/11/2010 11:50 AM, Cecep W wrote:
>
> Alhamdulillah sudah berhasil mas.....masalahnya sekarang adalah semua yg ada di QTransaksiDetail ke print semua.Bagaimana supaya nge-print hanya transaksi yg terbaru saja?Bagaimana memberikan Nomor pada Nama Item-nya?Berikut saya lampirkan kembali file-nya.RegarsCW
> Pada 8 Oktober 2010 15.58, Aksan Kurdin menulis:
> untuk print lpt1 ke jaringan, maka lpt1-nya ditembakkan ke printer
> share tersebut:
>
> net use lpt1 \\ \
>
> dan untuk menghapus routing lpt1 kembali ke port local:
>
> net use lpt1 /delete
>
>
> jalankannya bisa lewat command prompt, atau perintah shell :
> cmd/c net use .....
>
>
> aksan kurdin
truncated------------------------------------

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

__,_._,___
Posted by NINO at Wednesday, January 09, 2013 0 comments

Re: [belajar-access] Database Nyantol

 

Kalau saya s.d saat ini menggunakan unlocker v 1.8.7, cukup klik kanan file
yg mau di unlock, lalu klik Unlocker. OS menggunakan Win XP.

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
----- Original Message -----
From: "Si Nung" caksinung@gmail.com>
To: belajar-access@yahoogroups.com>
Sent: Tuesday, January 08, 2013 4:22 PM
Subject: Re: [belajar-access] Database Nyantol

>
> Coba
>
> unlocker.emptyloop.com
>
>
>
>
>
> ------------------------------------
>
> SPAM IS PROHIBITEDYahoo! Groups Links
>
>
>

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

__,_._,___
Posted by NINO at Wednesday, January 09, 2013 0 comments

Re: [belajar-access] Database Nyantol

 
__,_._,___
Posted by NINO at Wednesday, January 09, 2013 0 comments

[belajar-access] Database Nyantol

 

Assalamu'alaikum..wr wb

Dear Para Ahli,

Mohon informasi ilmunya.  Jika database perlu direpair, sementara database tsb masih nyantol (seperti sedang dibuka, ada file 1Kb) padahal sudah dipastikan semua user sudah tdk mengakses database tsb. File 1 Kb tsb juga tidak bisa didelete, seakan2 masih dibuka user lain.  Gimana solusinya untuk mendelete paksa file 1 Kb tsb, supaya database bisa dicompact dan di repair.  Mohon solusinya.  Terimakasih.

Wassalamu'alaikum..wr..wb

Salam,
Mimin

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

__,_._,___
Posted by NINO at Wednesday, January 09, 2013 0 comments

[belajar-access] Re: query

 


it's done in the hard way...

--- In belajar-access@yahoogroups.com, Sofyan Efendi wrote:
>
> Saya agak kesulitan ceknya, mungkin sahabat yg lain bisa membantu,
> dipersilahkan...
>
> Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
> Sofyan Efendi
> ----- Original Message -----
> From: "oh bangsaku"
> To:
> Sent: Tuesday, January 08, 2013 9:34 AM
> Subject: [belajar-access] Re: query
>
>
> >
> > lebih rincinya saya coba gambarkan disini....
> >
> > ada dua file yaitu:
> >
> > Form dan Query
> >
> > Form
> > name: FR_nipTotTunj
> > record source:absen
> > 1. Textbox
> > name:txtBulan
> > Event After Update [Event Procedure]
> >
> > Private Sub txtBulan_AfterUpdate()
> > 'Find the record that matches the control.
> > Dim rs As Object
> >
> > Set rs = Me.Recordset.Clone
> > rs.FindFirst "[bulan]=" & Me![txtBulan] & ""
> > Me.Bookmark = rs.Bookmark
> >
> > End Sub
> > 2. TextBox
> > name:txtNip
> > Event After Update [Event Procedure]
> >
> > Private Sub txtNip_AfterUpdate()
> > 'Find the record that matches the control.
> > Dim rs As Object
> >
> > Set rs = Me.Recordset.Clone
> > rs.FindFirst "[nip]='" & Me![txtNip] & "'"
> > Me.Bookmark = rs.Bookmark
> >
> > End Sub
> > Query
> >
> > SELECT A.bulan, P.nip, J.tj_jabatan AS tunj_jabatan, IIf(p.status='tidak
> > menikah',0,G.tj_istrisuami) AS tunj_istri_suami, (P.jm_anak*G.tj_anak) AS
> > tunj_anak, (A.jh_masuk*G.u_makan) AS uang_makan,
> > (L.jam_lembur*G.ix_lembur) AS uang_lembur,
> > ([tunj_jabatan]+[tunj_istri_suami]+[tunj_anak]+[uang_makan]+[uang_lembur])
> > AS Tot_Tunjangan
> > FROM Pegawai AS P, Golongan AS G, Jabatan AS J, Lembur AS L, Absen AS A
> > WHERE (((A.bulan)=[Forms]![FR_nipTotTunj]![txtBulan]) AND
> > ((P.nip)=[L].[nip] And (P.nip)=[A].[nip] And
> > (P.nip)=[Forms]![FR_nipTotTunj]![txtnip]) AND ((P.gol)=[G].[gol]) AND
> > ((P.kd_jabatan)=[j].[kd_jabatan]))
> > ORDER BY P.nip;
> >
> >
> >
> > sebelumnya terima kasih dan mohon maaf bila telah merepotkan....
> >
> > --- In belajar-access@yahoogroups.com, Sofyan Efendi wrote:
> >>
> >> Oh, kalau gitu agak susah juga ya
> >> Sebenarnya, intinya pesan parameter value itu terjadi karena ia belum
> >> didefinisikan, atau karena form yang dirujuk oleh criteria tidak dalam
> >> keadaan terbuka. Begini aja, dicoba dulu set parameternya dng cara klik
> >> Parameters di menu Design, lalu isi dengan:
> >> [Forms]![FR_nipTotTunj]![txtBulan] -> data type Number
> >> [Forms]![FR_nipTotTunj]![txtnip] -> data type Number (atau mungkin text,
> >> sesuai dng di table)
> >> lalu run kembali
> >> Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
> >> Sofyan Efendi
> >> ----- Original Message -----
> >> From: "oh bangsaku"
> >> To:
> >> Sent: Monday, January 07, 2013 3:58 PM
> >> Subject: [belajar-access] Re: query
> >>
> >>
> >> >
> >> > cara ambil filenya gimana yah...soalnya file satu dengan file
> >> > lainnya...
> >> >
> >> > --- In belajar-access@yahoogroups.com, Sofyan Efendi wrote:
> >> >>
> >> >> Sepertinya pembuatan rumus Tot_Tunjangan tidak bisa dibuat dalam satu
> >> >> query,
> >> >> tapi harus di query baru.
> >> >> Apakah filenya bisa disertakan? Agar bisa lebih cepat mencari
> >> >> errornya.
> >> >>
> >> >> Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
> >> >> Sofyan Efendi
> >> >> ----- Original Message -----
> >> >> From: "oh bangsaku"
> >> >> To:
> >> >> Sent: Monday, January 07, 2013 1:54 PM
> >> >> Subject: [belajar-access] Re: query
> >> >>
> >> >>
> >> >> > saya dah coba.....ternyata masih belum bisa....
> >> >> >
> >> >> > --- In belajar-access@yahoogroups.com, Sofyan Efendi wrote:
> >> >> >>
> >> >> >> (tunj_jabatan+tunj_istrisuami+tunj_anak+uang_makan+uang_lembur)
> >> >> >> mungkin
> >> >> >> seharusnya:
> >> >> >> ([tunj_jabatan]+[tunj_istrisuami]+[tunj_anak]+[uang_makan]+[uang_lembur])
> >> >> >>
> >> >> >> Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
> >> >> >> Sofyan Efendi
> >> >> >> ----- Original Message -----
> >> >> >> From: "oh bangsaku"
> >> >> >> To:
> >> >> >> Sent: Monday, January 07, 2013 10:46 AM
> >> >> >> Subject: [belajar-access] query
> >> >> >>
> >> >> >>
> >> >> >> > apa yang salah dari query dibawah ini...kok selalu minta enter
> >> >> >> > parameter
> >> >> >> > value????
> >> >> >> >
> >> >> >> > SELECT A.bulan, p.nip, j.tj_jabatan AS tunj_jabatan,
> >> >> >> > IIF(p.status='tidak
> >> >> >> > menikah',0,G.tj_istrisuami) AS tunj_istri_suami,
> >> >> >> > (P.jm_anak*G.tj_anak)
> >> >> >> > AS
> >> >> >> > tunj_anak, (A.jh_masuk*G.u_makan) AS uang_makan,
> >> >> >> > (L.jam_lembur*G.ix_lembur) AS uang_lembur,
> >> >> >> > (tunj_jabatan+tunj_istrisuami+tunj_anak+uang_makan+uang_lembur)
> >> >> >> > AS
> >> >> >> > Tot_Tunjangan FROM Pegawai AS P, Golongan AS G, Jabatan AS J,
> >> >> >> > Lembur
> >> >> >> > AS
> >> >> >> > L,
> >> >> >> > Absen AS A WHERE P.nip=L.nip and P.nip=A.nip and P.gol=G.gol and
> >> >> >> > p.kd_jabatan=j.kd_jabatan and
> >> >> >> > A.bulan=[Forms]![FR_nipTotTunj]![txtBulan]
> >> >> >> > and P.nip=[Forms]![FR_nipTotTunj]![txtnip] ORDER BY p.nip;
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > ------------------------------------
> >> >> >> >
> >> >> >> > SPAM IS PROHIBITEDYahoo! Groups Links
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > ------------------------------------
> >> >> >
> >> >> > SPAM IS PROHIBITEDYahoo! Groups Links
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >
> >> >
> >> >
> >> >
> >> > ------------------------------------
> >> >
> >> > SPAM IS PROHIBITEDYahoo! Groups Links
> >> >
> >> >
> >> >
> >> >
> >>
> >
> >
> >
> >
> > ------------------------------------
> >
> > SPAM IS PROHIBITEDYahoo! Groups Links
> >
> >
> >
>

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

__,_._,___
Posted by NINO at Wednesday, January 09, 2013 0 comments
Subscribe to: Posts (Atom)