Member baru? Bingung? Perlu bantuan? Silakan baca panduan singkat untuk ikut berdiskusi.

Welcome to Forum Sains Indonesia. Please login or sign up.

Maret 28, 2024, 04:56:21 PM

Login with username, password and session length

Topik Baru

Artikel Sains

Anggota
Stats
  • Total Tulisan: 139,653
  • Total Topik: 10,405
  • Online today: 87
  • Online ever: 1,582
  • (Desember 22, 2022, 06:39:12 AM)
Pengguna Online
Users: 0
Guests: 64
Total: 64

Aku Cinta ForSa

ForSa on FB ForSa on Twitter

membuat nomor otomatis pada visual basic 6.0

Dimulai oleh saipul, Desember 03, 2011, 09:11:54 PM

« sebelumnya - berikutnya »

0 Anggota dan 1 Pengunjung sedang melihat topik ini.

saipul

selamat malam...
saya maw nanya ni, gmn cara buat nomer otomatis berdasarkan jenis paket....
contoh :
Jika TKA=A-001 dan jika TKB=B-001... saya sudah buat nomer otomatis nya namun untuk 3digit nomor dibelakang (A-) terus berlanjut padahal berbeda jenis paket nya...

contoh kasus yang saya buat saat ini,
jika TKA=A-001 lalu saya pilih TKB=B-002, nomor urutnya terus berlanjut padahal beda jenis paket nya....

yang saya inginkan adalah sebagai berikut :
jika TKA=A-001 dan dipilih TKB maka akan mengulang kembali menjadi TKB=B-001 dan bukan lanjut ke nomor 002.

masukan dari kawan2 semua sangat saya harapkan....
terimakasih

mhyworld

Buat saja nomor urutnya dalam 2 variabel terpisah.
Kalau masih belum bisa, tampilkan saja listing programnya di sini supaya lebih jelas masalahnya sehingga yang lain bisa membantu.
once we have eternity, everything else can wait

saipul

terimakasih atas masukan tapi terus terang saya belum mengerti... berikut ini saya kirimkan source kode program dan print screen contoh nya...

mohon bantuannya, sebelum dan sesudah saya ucapkan terimakasih...

mhyworld

Coba ganti SQL textnya

rs.Open ("select * from t_siswa_tk Where nis_siswa In(Select Max(nis_siswa)From t_siswa_tk)Order By nis_siswa Desc"), db

menjadi

rs.Open ("select * from t_siswa_tk Where (nis_siswa In(Select Max(nis_siswa)From t_siswa_tk)) and (left(nis_siswa,1)=""" & right(cmbprogram.text,1) & """) Order By nis_siswa Desc"), db

pertanyaan : kalau sudah ganti bulan/tahun, nomor urutnya direset nggak?
once we have eternity, everything else can wait

saipul

mksh atas jawaban nya... saya akan coba...
untuk awal bulan nomor nya akan direset lagi dari awal...

terimakasih

mhyworld

Kutip dari: saipul pada Desember 06, 2011, 08:50:46 PM
mksh atas jawaban nya... saya akan coba...
untuk awal bulan nomor nya akan direset lagi dari awal...

terimakasih
berarti criteria untuk "where" nya harus ditambah agar mengabaikan bulan&tahun yang lain.
once we have eternity, everything else can wait

saipul

selamat malam...
program yang sudah saya jadikan exe dan seluruh file pendukung nya sudah saya copy kan di windows/system32 namun saat kriteria laporan dimasukin dan kita klik tombol tampilkan data selalu keluar pesan error sebagai berikut :

tolong donk dibantu...
thanks


mhyworld

Coba baca di sini [pranala luar disembunyikan, sila masuk atau daftar.]
Just google it, pakai kata kunci "vb6 error 713".

BTW, masalah yg sebelumnya sudah beres?
once we have eternity, everything else can wait

saipul

mksh mas... mslh sebelumnya sudah beres.... saya tetap masukin di topik ini krn saya masih bingung untuk membuat judul baru di forum ini...

maklum saya baru bergabung di website ini jadi untuk mencari tombol membuat topik baru gak dapat2 jadi saya masukin aja di sini lagi...

mohon tunjuk ajar nya yah....  :) :) :)
mksh

saipul

alamat ini yg mas kasih gak bisa dibuka.... knp ya

mhyworld

Kutip dari: saipul pada Desember 16, 2011, 12:42:32 PM
alamat ini yg mas kasih gak bisa dibuka.... knp ya


Kalau gitu saya copas aja langsung teksnya. Mungkin settingan browsernya yang bikin masalah.

KutipArticle ID: 248055 - Last Review: October 15, 2002 - Revision: 1.0
PRB: Run-Time Error 713 Opening Data Report in Distributed Application
View products that this article applies to.
This article was previously published under Q248055
Expand all | Collapse all
SYMPTOMS
You are distributing a Visual Basic application that includes a data report. After installation, you receive the following error when you attempt to open the data report from your application:
Run-time error '713': Application-defined or object defined error
Back to the top
CAUSE
The Data Report run-time file (Msdbrptr.dll) was not included in your setup package.
Back to the top
RESOLUTION
To resolve this problem, use one of the following methods:

    Open your project, and include a reference to the Msdbrptr.dll file. This file is listed as Microsoft Data Report Designer v6.0 in the References dialog box. You may see Microsoft Data Report Designer v6.0 listed more than once. Make certain that the file associated with the reference is Msdbrptr.dll. Once the reference has been verified, rebuild your setup package.

    -or-
    Manually include the Msdbrptr.dll file in the Package and Deployment Wizard (PDW). You can add the file manually in the Included Files dialog box window when you run the PDW and then rebuild your setup package.

After the installation, the following files should be present on the target system in the indicated folders:
<windows system>\Msdbrptr.dll
<program files>\Common Files\Designers\Msderun.dll
<windows system>\Msstdfmt.dll
The inclusion of Msdbrptr.dll (and its dependent files) typically corrects this problem. If you are still experiencing problems, make sure that the following files are included in your package:
Msdatrep.ocx
Msbind.dll
Data Reports do not directly depend on these files. However, if the files are missing, this can affect the Data Environment that is used by your report.

NOTE: If your application must have the Msdatsrc.tlb file, do not explicitly include this file because Msdatsrc.tlb is installed as part of the Microsoft Data Access Components (MDAC) upgrade.
Back to the top
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
Back to the top
MORE INFORMATION
Visual Basic installs two files, Msdbrpt.dll and MSdbrptr.dll, that are very similar. Both files are listed in the References dialog box as Microsoft Data Report Designer v6.0. The Msdbrpt.dll file is the Data Report designer, and the Msdbrptr.dll file is the Data Report designer runtime. You must distribute the run-time version of this file with your application. There is no dependency file for Msdbrpt.dll. If Msdbrpt.dll is installed with your application, a data report does not function correctly.

There are several ways in which to add a data report to a Visual Basic project. With two known exceptions, Visual Basic adds the correct reference. If you add this reference manually, the similarity between these two files makes it easy to reference the wrong file. The other way to get an incorrect reference is to add the data report component through the Add Components dialog box. This adds a reference to the data report instead of the data report runtime file. Under these circumstances, the data report works only in the development environment or when the data report is installed to a computer that has Visual Basic installed.
Back to the top
APPLIES TO
Back to the top
Keywords:
   kbbug kbdatabinding kbdatabase kbappsetup kbreportwriter kbprb kbwizard kbpending kbdeployment KB248055
Back to the top
once we have eternity, everything else can wait

saipul

mksh mas atas copas nya....
saya coba dulu.
thanks

saipul

selamat malam...

gmn caranya membuat cctv yang aktif tersimpan otomatis kedalam database yang kita buat, file yang tersimpan antara lain adalah data sebagai berikut: tgl, no cctv, status(aktif/non aktif)

mohon pencerahan nya