Senin, 02 Maret 2015

Re: [belajar-access] Re: Auto refresh report

 

kalau itu yang di mau ...
jangan gunakan report,
tapi gunakan Form, dan di beri event timer....

saya pernah gunakan sebagai papan informasi, di hubungkan dengan Screen 32"
menampilkan berbagai informasi yg kita perlukan ...
tinggal di setting urutan form yang akan di refresh.

dalam satu form bisa looping beberapa record,
setelah habis .. bukan form yang lain ...
looping lagi dstt...
kreatifitas sangat di perlukan untuk menciptakan yang tidak mungkin jadi  mungkinnnnn :)
 
Darsono
esia       : 021-9344-0898
Simpati  : 0812-8670-1010
M3         : 0856-878-1010
FB         : Darsono Kroya
Twitter    : @darsono72


On Monday, March 2, 2015 5:50 PM, "endro.ssl@gmail.com [belajar-access]" <belajar-access@yahoogroups.com> wrote:


 
Terima kasih mas MBA,

Kalo tutup trus buka lagi gitu nggak praktis mas, karena komputer yang ini langsung berhadapan dengan client jadi jauh dari back office.
Atau mungkin ada VBA yang bisa memerintahkan report close dan kemudian open lagi setelah interval waktu tertentu?

Regrads,
Endro


__._,_.___
Posted by: Darsono <darsono72@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
SPAM IS PROHIBITED

.

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

RE: [MS_AccessPros] Question About Genie backup

 

UPDATE:

 

Genie adds the accdb and lccdb to its pending list when I open the accdb but when I close the accdb Genie does not remove them from the pending list.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, March 2, 2015 8:09 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Question About Genie backup

 

 

Apologies to the person who mentioned Genie in a post a few weeks back but I have a question and can't recall who it was so I can address this post more personally.

I seem to have run into a small Genie glitch when it comes to the Access Project I am currently working on. I am unable to compact and repair the file because Access reports that it is already in use. When I go to the Genie dashboard, it show 7 pending files, The list includes my .accdb and it's .lccdb even though Access has deleted the .lccdb

If I copy the .accdb to a folder outside of Genie control, I am able to do the compact and repair.

My question is, have you encountered similar issues and if so how do you work around it.

Glenn

 

__._,_.___
Posted by: "Glenn Lloyd" <argeedblu@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2)

.

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

[MS_AccessPros] Question About Genie backup

 

Apologies to the person who mentioned Genie in a post a few weeks back but I have a question and can't recall who it was so I can address this post more personally.

I seem to have run into a small Genie glitch when it comes to the Access Project I am currently working on. I am unable to compact and repair the file because Access reports that it is already in use. When I go to the Genie dashboard, it show 7 pending files, The list includes my .accdb and it's .lccdb even though Access has deleted the .lccdb

If I copy the .accdb to a folder outside of Genie control, I am able to do the compact and repair.

My question is, have you encountered similar issues and if so how do you work around it.

Glenn


__._,_.___
Posted by: argeedblu@gmail.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)

.

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

Minggu, 01 Maret 2015

[belajar-access] OOT: Training MS Access - VBA Programming [1 Attachment]

 
[Attachment(s) from RumahAccess Indonesia training@rumahaccess.com [belajar-access] included below]

Dear bpk/ibu moderator dan anggota milis yth.

Mohon izin mengingatkan training "MS Access - VBA Programming" (14-15 Mar 2015)
yang dipandu bpk Aksan Kurdin, moderator belajar-access dan belajar-excel
pendaftaran dan konfirmasi paling lambat hari Jumat, 6 Maret 2015.

Bagi bpk/ibu yang berminat silahkan mendaftarkan diri dengan mengirim email ke:
training@rumahaccess.com dan mencantumkan data:

    Nama lengkap
    Alamat lengkap
    Pekerjaan / Jabatan
    Perusahaan/Instansi
    Nomor kontak (HP)
    Alamat Email

Informasi lebih lengkap bisa dilihat di www.RumahAccess.com

Demikian informasinya, semoga berkenan. Terima kasih.


Best regards,

Runiz
Training Administrator

__._,_.___

Attachment(s) from RumahAccess Indonesia training@rumahaccess.com [belajar-access] | View attachments on the web

1 of 1 Photo(s)

Posted by: RumahAccess Indonesia <training@rumahaccess.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Check out the automatic photo album with 1 photo(s) from this topic.
Banner Training 2 Hari (5) - VBA.jpg
SPAM IS PROHIBITED

.

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

[belajar-access] File - Tata Tertib dan Aturan.txt

 


Tata tertib dan peraturan
Mailing List: belajar-access@yahoogroups.com

1. Mailing list ini membahas mengenai pemrograman Microsoft Access.
2. Tidak diperkenankan mem-posting topik yang tidak ada kaitannya sama sekali dengan pemrograman MS Access, peluang kerja atau tawaran kerja sama dengan keahlian di bidang MS Access, atau pengajaran/kursus MS Acces. Pelanggaran terhadap aturan ini akan di-ban dari keanggotaan milis ini.
3. Mohon berdiskusi dengan baik, dengan semangat membangun, demi kemajuan kita bersama. Hindarilah perbantahan (flame) yang bisa menjadi pertengkaran yang tidak perlu.
4 Hindari reply permintaan one-liner seperti 'saya minta juga dong', 'saya setuju', dan lain-lain yang tidak perlu.
5. Sedapat mungkin memberikan data-data yang lengkap dalam mengajukan suatu masalah untuk memudahkan rekan-rekan sesama member mengidentifikasi dan mencarikan solusi, termasuk memberikan subject yang sesuai dengan isi email, tidak dengan kata-kata seperti "tologing dong", "pusing...", "ada yang bisa bantu..", dll.

Moderator

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

.

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

[MS_AccessPros] ListView Control in Ms.Access Form

 

Dear Experts,

Hi to All,

Recently I've been working with my friend on a Access project require some upgrade. In one of forms I've used ListView Active X control, the reason was that it looks good, add a professional look and most of all we have good control over it to fill data or to set column headers etc.

All went very well, until I've sent the Ms.Access file to my friend for testing, then comes the worse part, at the start of file got error something like Active X control not properly registered. I've sent a link to VB controls file which could be downloaded from MS site, and do the un-register then again register the control mscomctl.ocx. After that atleast 2 out of 3 forms work fine, but one form still shows error regarding MouseMove event:

"The expression MouseMove you entered as the event property setting produced the following error: There was an error loading an ActiveX control on one of your forms or reports"

And funny thing is there is not MouseMove event use in all forms with ListView control.

So long story short I have to replace ListView with traditional listbox of Ms.Access. The reason for posting this to the group is to know is there any workaround available so that if we distribute our application using ListView to clients, they don't have to go through all file downloading and do the regsvr32 mscomctl.ocx type stuff? Can we some how distribute ActiveX controls alongwith Ms.Access application, and all settings can be done via VBA coding so that at startup Ms.Access should check whether there is any problem with ActiveX control, and fix it?

I am already working on another application, this is an Accounting Software and I am already use many ListViews, so you can understand my concern :|

Looking forward for expert suggestions/solutions as always.

regards

Ahmed

__._,_.___
Posted by: Ahmed Hashim <ahmedhashim1@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)

.

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

[AccessDevelopers] File - Monthly_Notices.txt

 


Monthly notices:

Hi Kids!:

Don't forget to check out our "Links" section at the website for helpful sites. Also take a peek at books that others have found worthwhile in our books database under the 'Database' link of the main AccessDevelopers page. Feel free to add any books or links that you have found useful.

__._,_.___
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (128)

Please zip all files prior to uploading to Files section.

.

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