Rabu, 30 April 2014

RE: [MS_AccessPros] Dlookup in (sub)Report

 

Sarah,
 
Have you considered adding the [insurance] table to the subreport record source so you can bind the [iname] field to the text box?
 
Otherwise, you could try (if insrcd is numeric):
=DLookUp("iname","insurance","insrcd = " & [insrcd])

If insrcd is text:
=DLookUp("iname","insurance","insrcd = """ & [insrcd] & """")
 
Duane Hookom MVP
MS Access

 

To: MS_Access_Professionals@yahoogroups.com
From: sarahk@schemesoftware.com
Date: Wed, 30 Apr 2014 17:28:52 -0700
Subject: [MS_AccessPros] Dlookup in (sub)Report



 
I have a subreport that is sorting and totaling by a field called 'insrcd'. This fields  description is 'iname' in table 'insurance'. In the 'insrcd' footer on the report, I print the 'insrcd' and the total for this category. This works fine. Now I am trying to add the description of 'insrcd' and I can not get it to work. The best I have gotten is the description of the first entry in the 'insurance' table. I added a Text Box and set the control source to '=DLookUp("iname","insurance","insurance.insrcd = " & '[insrcd]')'.  This prints the first entry in the insurance table.
The record source for this report is a query 'pr7demog'. I am not printing anything else on this report, the detail section is empty, because all I am interested in is the totals by insrcd category. What am I doing wrong?.
I am using Access 2003 and Win Vista.
 
All help is appreciated.
 
Sarah

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

Now you can search Photos & Files in your Group !
You can now search not only your archive of conversations, but also photos and files stored in your Yahoo Group. Give it a try!

.

__,_._,___

[MS_AccessPros] Dlookup in (sub)Report

 

 

I have a subreport that is sorting and totaling by a field called 'insrcd'. This fields  description is 'iname' in table 'insurance'. In the 'insrcd' footer on the report, I print the 'insrcd' and the total for this category. This works fine. Now I am trying to add the description of 'insrcd' and I can not get it to work. The best I have gotten is the description of the first entry in the 'insurance' table. I added a Text Box and set the control source to '=DLookUp("iname","insurance","insurance.insrcd = " & '[insrcd]')'.  This prints the first entry in the insurance table.

The record source for this report is a query 'pr7demog'. I am not printing anything else on this report, the detail section is empty, because all I am interested in is the totals by insrcd category. What am I doing wrong?.

I am using Access 2003 and Win Vista.

 

All help is appreciated.

 

Sarah

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

Now you can search Photos & Files in your Group !
You can now search not only your archive of conversations, but also photos and files stored in your Yahoo Group. Give it a try!

.

__,_._,___

RE: [MS_AccessPros] renaming front end tables and Access 2010

 

It can really mess up things for professional developers. I always make copies of objects that I make design changes to just in case I need to back out of the changes. So I have a table called tblCustomerData and make a copy called tblCustomerData_orig (as in original). Suddenly all hell breaks loose with the Name tracker turned on.


But I guess it's good for newbees.

-Bill


---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Duh – I guess so.  Well, then.  So that's what that sucker does. 

 

Thanks!

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Tuesday, April 29, 2014 4:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] renaming front end tables and Access 2010

 




Liz

Did you forget to turn off the File>Options>Current Database>Name AutoCorrect?

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My Nothing-to-do-with Access blog

http://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Tuesday, April 29, 2014 3:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] renaming front end tables and Access 2010

 

 

Pros,

 

Did something change in 2010 regarding keeping objects bound regardless of renaming them?

 

I used to be able to test development copies by renaming tables to test with, but it is changing the names of my bound forms.

 

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

 






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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

Now you can search Photos & Files in your Group !
You can now search not only your archive of conversations, but also photos and files stored in your Yahoo Group. Give it a try!

.

__,_._,___

RE: [MS_AccessPros] renaming front end tables and Access 2010

 

Duh – I guess so.  Well, then.  So that’s what that sucker does. 

 

Thanks!

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Tuesday, April 29, 2014 4:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] renaming front end tables and Access 2010

 




Liz

Did you forget to turn off the File>Options>Current Database>Name AutoCorrect?

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My Nothing-to-do-with Access blog

http://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Tuesday, April 29, 2014 3:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] renaming front end tables and Access 2010

 

 

Pros,

 

Did something change in 2010 regarding keeping objects bound regardless of renaming them?

 

I used to be able to test development copies by renaming tables to test with, but it is changing the names of my bound forms.

 

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

 






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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

Now you can search Photos & Files in your Group !
You can now search not only your archive of conversations, but also photos and files stored in your Yahoo Group. Give it a try!

.

__,_._,___

Selasa, 29 April 2014

RE: [MS_AccessPros] renaming front end tables and Access 2010

 

Liz

Did you forget to turn off the File>Options>Current Database>Name AutoCorrect?

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My Nothing-to-do-with Access blog

http://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Tuesday, April 29, 2014 3:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] renaming front end tables and Access 2010

 

 

Pros,

 

Did something change in 2010 regarding keeping objects bound regardless of renaming them?

 

I used to be able to test development copies by renaming tables to test with, but it is changing the names of my bound forms.

 

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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

Now you can search Photos & Files in your Group !
You can now search not only your archive of conversations, but also photos and files stored in your Yahoo Group. Give it a try!

.

__,_._,___

[MS_AccessPros] renaming front end tables and Access 2010

 

Pros,

 

Did something change in 2010 regarding keeping objects bound regardless of renaming them?

 

I used to be able to test development copies by renaming tables to test with, but it is changing the names of my bound forms.

 

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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

Now you can search Photos & Files in your Group !
You can now search not only your archive of conversations, but also photos and files stored in your Yahoo Group. Give it a try!

.

__,_._,___

Re: [belajar-access] calendar di access 2010

 

ha...ha..ha..., iya bro,
apa khabarnya bro, kapan janjian lagi di cilandak hi...hi...hi....
tadi pagi udah kepikiran begitu juga, yg penting cepat selesai :-)
oh ya di 2010 jet oledb.4.0 masih bisa dipakai nggak ya, soalnya saya pakai itu di access project utk open connection ke file mdb, kalau di 2010 pakai apa ya utk konek ke database mdb.

salam,

Andria



2014-04-29 12:01 GMT+07:00 Aksan Kurdin <aksan.kurdin@gmail.com>:
Sist Andra yang terkasih ....
(hahahaa.....)

Di access 2007  ke atas, text box aja udah cukup bro.
Date picker internal nya aja manfaatin.
Otomatis muncul di form

aksan kurdin









On 4/28/2014 4:40 PM, andria rismawandi wrote:
 
Assalamu'alaikum,
apa khabar rekan-rekan semua, maaf baru muncul lagi lagi soalnya udah lama nggak "ngoding" :-)
semoga semua warga milis ada dalam keadaan sehat waalfiat. aminn.

udah lama nggak ngoding, akhirnya karena tuntutan "jaman", sekarang di kantor saya ada kebijakan baru utk mengupgrade ms officenya ke versi 2010 64 bit.

saya baru ujicoba program saya yg under ver 2003 di 2010, dan langsung muncul error. ternyata objek mscalendar sdh tidk dipakai di versi 2010.
kacian deh ketinggalan banget :-)
saya sudah googling tapi belum dapat cara yg terbaik. 
mohon masukannya dari rekan-rekan sekalian solusi terbaik dr masalah ini.

sebelumnya saya ucapkan terimakasih

salam,

Andria



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

__,_._,___

Re: [belajar-access] cetak data ada jedah 1 halaman

 

Assalamu'alaikum warahmatullahi wabarakatuh

Terima Kasih atas koreksiannya kang Aksan..

Terima kasih juga untuk pencerahanny..

On Tuesday, April 29, 2014 12:03 PM, Aksan Kurdin <aksan.kurdin@gmail.com> wrote:
 
Obyek report selalu menggulung kertas, karena cetaknya per halaman, bukan per baris.
Agar supaya bisa ngeprint seperti printer kasir yang langsung berhenti di baris akhir, jangan gunakan obyek report.
Tapi anda bisa langsung print out ke device printer port (lpt1).

coba cari di arsip mengenai cara ngeprint ke lpt1, atau google dengan kata kunci: "belajar access print to lpt1"


aksan kurdin

On 4/29/2014 10:02 AM, Asep Permana wrote:
 
ass.
Mohon bantuan+pencerahannya untuk rekan2 semua...
Saya membuat aplikasi sederhana ttg penjualan, pada saat mencetak data yang jumlahnya lebih dari 1 halaman maka printer akan melompat 1 page sehingga ada jedah 1 halaman yg mengakibatkan pemborosan kertas....pada saat di preview pun sudah ada jedah 1 halaman.
nb;  sy menggunkan printer kasir (matrix point manual cut), seting page (left:0, right:0, top:0, bottom:0)

tks



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

__,_._,___

Senin, 28 April 2014

Re: Bls: [belajar-access] Filter hasil Is null dan Is not Null [1 Attachment]

nyambung yang terpotong.....sekedar saran, juga untuk member yang lain, jika melampirkan contoh database diusahakan jangan melampirkan data live seperti alamat lengkap dan no. telepon, dikhawatirkan ada pihak-pihak tidak bertanggung jawab yang memanfaatkan data tersebut.
 
Salam,

Edi Rosadi
Application Developer & Consultant
Owner of Saung CyberTechno




On Tuesday, 29 April 2014, 12:28, hera wati <hera_skeptis@yahoo.co.id> wrote:
Alhamdulillah...horeee.. Terimakasiiih Bang Aksan Kurdin ^_^
Pada , hera wati <hera_skeptis@yahoo.co.id> menulis:
cara compact gimana bang Aksan :D?

Pada Selasa, 29 April 2014 12:03, Aksan Kurdin <aksan.kurdin@gmail.com> menulis:
di compact aja, backup dulu ya ....





regards,
Aksan Kurdin

On 4/29/2014 9:15 AM, hera wati wrote:
 
Mohon pencerahannya :(, tabel data karyawan yang terlampir bermasalah biasanya ga Master :(. Saya klik filter by from --> Kode perusahaan --> yang muncul pilihan "Is Null dan Is Not Null :((, biasanya yang muncul pilihan kode perusahaan seperti; ABA, IPI, MES, MGG,RWS, TSI ... mohon pencerahannya :(( Terimakasih *semoga para master paham maksud saya :D