ACCESS FEED: Agustus 2012

Jumat, 31 Agustus 2012

RE: [belajar-access] Download Quran Database SE

Wah thx pak sofyan, bagus bgt….canggih…

From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of Sofyan Efendi
Sent: Friday, August 31, 2012 10:35 PM
To: belajar-access@yahoogroups.com
Subject: [belajar-access] Download Quran Database SE

Dear all,

Assalaamu'alaikum Warahmatullahi Wabarakatuh,

Alhamdulillah, specially for the muslims, I would like to inform you, the newest version of Quran Database, called Quran Database SE. Before you downloading this software, please see some screenshot of this software by visit one of this link:

- http://imopi.wordpress.com/2012/08/31/screenshot-of-quran-database-se-v-6-0/
- http://trendmuslim.com/screenshot-of-quran-database-se-v-6-0/

This is Quran Database Special Edition v.6.0. All features in this program can be described below:

• Can use with MP3 Quran verse by verse
• Multi keyword for searching Quran and Translation
• Beauty reporting for Quran and Translation
• Can mark your reading and memorize of Quran
• Multi translation with multi language
• Multi reciter
• Have three mode view: Text Box, Database and Web Browser. Each mode view has a different model box.

Please download this software by clicking one of link below:

• http://www.datafilehost.com/download-eae6117d.html
• http://www.mediafire.com/?56p5i655fc89bb8
• http://www.sendspace.com/file/78d628
• https://rapidshare.com/files/299470762/QuranDatabaseSE_Setup.exe
• http://www.filefactory.com/file/2forzbuha4f1/n/QuranDatabaseSE_Setup_exe

File Name: QuranDatabaseSE_Setup.exe
Size: 98 MB
Format File : Microsoft Access Database (ACCDB)

System Requirements:
• Microsoft Windows XP, Windows 7, Windows 8, or later version.
• Microsoft Access 2007/2010/2013, or later version.
• Mozilla Firefox version 9 or later.
• Winamp version 5 or later.
• Memory with least 1 GB or more.
• Harddsik with free space least 3 GB or more. If you want store all MP3 Quran file to your harddsik, then the remaining free space on the harddisk minimal 50 GB.
• Minimal screen resolution of monitor is 1024 x 768 px.

Thank you by downloading this software, may be useful to you.

Please visit my web and blog for more information of this software.

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
http://trendmuslim.com/
http://imopi.wordpress.com/

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5229 - Release Date: 08/27/12

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

New Members 9

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: [belajar-access] Download Quran Database SE

Semoga jadi berkah bang. Ijin download.

Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!

From: "Sofyan Efendi" <sofyanefendi@gmail.com>

Sender: belajar-access@yahoogroups.com

Date: Fri, 31 Aug 2012 15:35:19 -0000

To: <belajar-access@yahoogroups.com>

ReplyTo: belajar-access@yahoogroups.com

Subject: [belajar-access] Download Quran Database SE

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

New Members 9

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] Problem with checkboxes randomly disappearing

John

I realize that. I didn't feel it necessary to rewrite the whole thing.

Maybe I should have added an ellipsis [smile]

Bill

--- In MS_Access_Professionals@yahoogroups.com, "John Marshall " <lancucki@...> wrote:
>
> A lot easier to read, but you are missing one step. The original code sets
> the value for chkPassEyeMRR as well.
>
>
>
> John. Visio MVP
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Friday, August 31, 2012 12:44 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Problem with checkboxes randomly disappearing
>
>
>
>
>
> John
>
> You can do it with less typing this way:
> [chkFailEyeMRR].Visible = ([chkPassEyeMRR] = False)
>
> If the the expression on theright side is True the chkbox will be visible.
>
> Capeesh?
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
> 1E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "jfakes.rm"
> <jfakes@> wrote:
> >
> > Ok, I tweaked my statements and it is now working.
> >
> > Here is what I used:
> >
> > 'Hides checkboxes if one of the other check boxes are checked.
> > If [chkPassEyeMRR] = True Then
> > [chkFailEyeMRR].Visible = False
> > Else
> > [chkFailEyeMRR].Visible = True
> > End If
> >
> > If [chkFailEyeMRR] = True Then
> > [chkPassEyeMRR].Visible = False
> > Else
> > [chkPassEyeMRR].Visible = True
> > End If
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "jfakes.rm" <jfakes@>
> wrote:
> > >
> > > Crystal,
> > > I tried using the Load event, however, when the form opens, it is
> filtered so the checkboxes aren't always shown so I get and error "you
> entered an expression that has no value."
> > >
> > > John F
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , Crystal
> <strive4peace2008@> wrote:
> > > >
> > > > Hi John,
> > > >
> > > > perhaps you want to use the form LOAD event -- this fires one time,
> when the data is loaded. The Current event is triggered upon landing on
> another record, or a new record
> > > >
> > > > ... but rather than doing this, why don't you use option buttons
> instead of checkboxes? That way they become mutually exclusive
> automatically :)
> > > >
> > > > anyway, there is often a better way than using checkboxes ... for
> instance, store a date/time, and a result like Pass or Fail
> > > >
> > > >
> > > > Warm Regards,
> > > > Crystal
> > > >
> > > > Learn Access on YouTube
> > > > http://www.YouTube.com/LearnAccessByCrystal
> > > > ________________________________
> > > > From: jfakes.rm <jfakes@>
> > > > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > Sent: Friday, August 31, 2012 8:32 AM
> > > > Subject: [MS_AccessPros] Problem with checkboxes randomly disappearing
> > > >
> > > > I had an issue with two checkboxes randomly disappearing on a form in
> MS Access 2003. What I am trying to do is if a person passes an eye exam,
> the chkPassEyeMRR is checked so I don't want to see the chkFailEyeMRR
> checkbox.
> > > >
> > > > Below is the code I am using in the "On Current" event.
> > > >
> > > > 'Hides checkboxes if one of the other check boxes are checked.
> > > > If [chkPassEyeMRR] = True Then
> > > > [chkFailEyeMRR].Visible = False
> > > > ElseIf [chkFailEyeMRR] = True Then
> > > > [chkPassEyeMRR].Visible = False
> > > > Else
> > > > [chkPassEyeMRR].Visible = True
> > > > [chkFailEyeMRR].Visible = True
> > > > End If
> > > >
> > > > When I open the form, the pass or fail checkbox displays properly.
> However, as I move from record to record, the checkboxes randomly disappear
> and reappear.
> > > >
> > > > I have similar code for different controls on a separate tab on the
> same form and that code works and the textboxes display properly.
> > > >
> > > > Any idea what is going on and how I can fix the issue?
> > > >
> > > > John F
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

New Members 6
New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

RE: [MS_AccessPros] Problem with checkboxes randomly disappearing

A lot easier to read, but you are missing one step. The original code sets
the value for chkPassEyeMRR as well.

John. Visio MVP

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Friday, August 31, 2012 12:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Problem with checkboxes randomly disappearing

John

You can do it with less typing this way:
[chkFailEyeMRR].Visible = ([chkPassEyeMRR] = False)

If the the expression on theright side is True the chkbox will be visible.

Capeesh?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
1E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "jfakes.rm"
<jfakes@...> wrote:
>
> Ok, I tweaked my statements and it is now working.
>
> Here is what I used:
>
> 'Hides checkboxes if one of the other check boxes are checked.
> If [chkPassEyeMRR] = True Then
> [chkFailEyeMRR].Visible = False
> Else
> [chkFailEyeMRR].Visible = True
> End If
>
> If [chkFailEyeMRR] = True Then
> [chkPassEyeMRR].Visible = False
> Else
> [chkPassEyeMRR].Visible = True
> End If
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "jfakes.rm" <jfakes@>
wrote:
> >
> > Crystal,
> > I tried using the Load event, however, when the form opens, it is
filtered so the checkboxes aren't always shown so I get and error "you
entered an expression that has no value."
> >
> > John F
> >
> > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , Crystal
<strive4peace2008@> wrote:
> > >
> > > Hi John,
> > >
> > > perhaps you want to use the form LOAD event -- this fires one time,
when the data is loaded. The Current event is triggered upon landing on
another record, or a new record
> > >
> > > ... but rather than doing this, why don't you use option buttons
instead of checkboxes? That way they become mutually exclusive
automatically :)
> > >
> > > anyway, there is often a better way than using checkboxes ... for
instance, store a date/time, and a result like Pass or Fail
> > >
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > Learn Access on YouTube
> > > http://www.YouTube.com/LearnAccessByCrystal
> > > ________________________________
> > > From: jfakes.rm <jfakes@>
> > > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > > Sent: Friday, August 31, 2012 8:32 AM
> > > Subject: [MS_AccessPros] Problem with checkboxes randomly disappearing
> > >
> > > I had an issue with two checkboxes randomly disappearing on a form in
MS Access 2003. What I am trying to do is if a person passes an eye exam,
the chkPassEyeMRR is checked so I don't want to see the chkFailEyeMRR
checkbox.
> > >
> > > Below is the code I am using in the "On Current" event.
> > >
> > > 'Hides checkboxes if one of the other check boxes are checked.
> > > If [chkPassEyeMRR] = True Then
> > > [chkFailEyeMRR].Visible = False
> > > ElseIf [chkFailEyeMRR] = True Then
> > > [chkPassEyeMRR].Visible = False
> > > Else
> > > [chkPassEyeMRR].Visible = True
> > > [chkFailEyeMRR].Visible = True
> > > End If
> > >
> > > When I open the form, the pass or fail checkbox displays properly.
However, as I move from record to record, the checkboxes randomly disappear
and reappear.
> > >
> > > I have similar code for different controls on a separate tab on the
same form and that code works and the textboxes display properly.
> > >
> > > Any idea what is going on and how I can fix the issue?
> > >
> > > John F
> >
>

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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (6)

Recent Activity:

New Members 6
New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] Problem with checkboxes randomly disappearing

John

You can do it with less typing this way:
[chkFailEyeMRR].Visible = ([chkPassEyeMRR] = False)

If the the expression on theright side is True the chkbox will be visible.

Capeesh?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

--- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@...> wrote:
>
> Ok, I tweaked my statements and it is now working.
>
> Here is what I used:
>
> 'Hides checkboxes if one of the other check boxes are checked.
> If [chkPassEyeMRR] = True Then
> [chkFailEyeMRR].Visible = False
> Else
> [chkFailEyeMRR].Visible = True
> End If
>
> If [chkFailEyeMRR] = True Then
> [chkPassEyeMRR].Visible = False
> Else
> [chkPassEyeMRR].Visible = True
> End If
>
> --- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@> wrote:
> >
> > Crystal,
> > I tried using the Load event, however, when the form opens, it is filtered so the checkboxes aren't always shown so I get and error "you entered an expression that has no value."
> >
> > John F
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@> wrote:
> > >
> > > Hi John,
> > >
> > > perhaps you want to use the form LOAD event -- this fires one time, when the data is loaded. The Current event is triggered upon landing on another record, or a new record
> > >
> > > ... but rather than doing this, why don't you use option buttons instead of checkboxes? That way they become mutually exclusive automatically :)
> > >
> > > anyway, there is often a better way than using checkboxes ... for instance, store a date/time, and a result like Pass or Fail
> > >
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > Learn Access on YouTube
> > > http://www.YouTube.com/LearnAccessByCrystal
> > > ________________________________
> > > From: jfakes.rm <jfakes@>
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Sent: Friday, August 31, 2012 8:32 AM
> > > Subject: [MS_AccessPros] Problem with checkboxes randomly disappearing
> > >
> > > I had an issue with two checkboxes randomly disappearing on a form in MS Access 2003. What I am trying to do is if a person passes an eye exam, the chkPassEyeMRR is checked so I don't want to see the chkFailEyeMRR checkbox.
> > >
> > > Below is the code I am using in the "On Current" event.
> > >
> > > 'Hides checkboxes if one of the other check boxes are checked.
> > > If [chkPassEyeMRR] = True Then
> > > [chkFailEyeMRR].Visible = False
> > > ElseIf [chkFailEyeMRR] = True Then
> > > [chkPassEyeMRR].Visible = False
> > > Else
> > > [chkPassEyeMRR].Visible = True
> > > [chkFailEyeMRR].Visible = True
> > > End If
> > >
> > > When I open the form, the pass or fail checkbox displays properly. However, as I move from record to record, the checkboxes randomly disappear and reappear.
> > >
> > > I have similar code for different controls on a separate tab on the same form and that code works and the textboxes display properly.
> > >
> > > Any idea what is going on and how I can fix the issue?
> > >
> > > John F
> >
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

New Members 6
New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] Problem with checkboxes randomly disappearing

Ok, I tweaked my statements and it is now working.

Here is what I used:

'Hides checkboxes if one of the other check boxes are checked.
If [chkPassEyeMRR] = True Then
[chkFailEyeMRR].Visible = False
Else
[chkFailEyeMRR].Visible = True
End If

If [chkFailEyeMRR] = True Then
[chkPassEyeMRR].Visible = False
Else
[chkPassEyeMRR].Visible = True
End If

--- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@...> wrote:
>
> Crystal,
> I tried using the Load event, however, when the form opens, it is filtered so the checkboxes aren't always shown so I get and error "you entered an expression that has no value."
>
> John F
>
> --- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@> wrote:
> >
> > Hi John,
> >
> > perhaps you want to use the form LOAD event -- this fires one time, when the data is loaded. The Current event is triggered upon landing on another record, or a new record
> >
> > ... but rather than doing this, why don't you use option buttons instead of checkboxes? That way they become mutually exclusive automatically :)
> >
> > anyway, there is often a better way than using checkboxes ... for instance, store a date/time, and a result like Pass or Fail
> >
> >
> > Warm Regards,
> > Crystal
> >
> > Learn Access on YouTube
> > http://www.YouTube.com/LearnAccessByCrystal
> > ________________________________
> > From: jfakes.rm <jfakes@>
> > To: MS_Access_Professionals@yahoogroups.com
> > Sent: Friday, August 31, 2012 8:32 AM
> > Subject: [MS_AccessPros] Problem with checkboxes randomly disappearing
> >
> > I had an issue with two checkboxes randomly disappearing on a form in MS Access 2003. What I am trying to do is if a person passes an eye exam, the chkPassEyeMRR is checked so I don't want to see the chkFailEyeMRR checkbox.
> >
> > Below is the code I am using in the "On Current" event.
> >
> > 'Hides checkboxes if one of the other check boxes are checked.
> > If [chkPassEyeMRR] = True Then
> > [chkFailEyeMRR].Visible = False
> > ElseIf [chkFailEyeMRR] = True Then
> > [chkPassEyeMRR].Visible = False
> > Else
> > [chkPassEyeMRR].Visible = True
> > [chkFailEyeMRR].Visible = True
> > End If
> >
> > When I open the form, the pass or fail checkbox displays properly. However, as I move from record to record, the checkboxes randomly disappear and reappear.
> >
> > I have similar code for different controls on a separate tab on the same form and that code works and the textboxes display properly.
> >
> > Any idea what is going on and how I can fix the issue?
> >
> > John F
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

New Members 6
New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

RE: [belajar-access] Mengelompokkan data dokumen jaminan berdasarkan Nomor ADM yang sama

Datanya menggunakan excel 2007 mas.

Salam,

-ignatius s. sinaga-

From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of edi rosadi
Sent: Friday, August 31, 2012 10:05
To: belajar-access@yahoogroups.com
Subject: Re: [belajar-access] Mengelompokkan data dokumen jaminan berdasarkan Nomor ADM yang sama

ekstension lampirannya apa, ya? kok tidak bisa dibuka.....

Salam,

Edi Rosadi

Application Developer & Consultant

Website/Blog :
Algoritma dan Pemrograman

--- On Tue, 28/8/12, ignatius sinaga <ignatiussinaga@yahoo.com> wrote:

From: ignatius sinaga <ignatiussinaga@yahoo.com>
Subject: [belajar-access] Mengelompokkan data dokumen jaminan berdasarkan Nomor ADM yang sama [1 Attachment]
To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Date: Tuesday, 28 August, 2012, 6:31 PM

Selamat sore rekan2 dan para master Access,

mohon bantuan solusi bagaimana caranya agar bisa mengelompokkan secara otomatis data dokumen jaminan berdasarkan nomor ADM yang sama seperti contoh terlampir.
bisakah kita membuat data spt terlampir dgn menggunakan query?

demikian, terima kasih banyak sebelumnya utk solusi yang akan diberikan.

salam,
-ignatius s. sinaga-

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (8)

Recent Activity:

New Members 10

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

RE: [belajar-access] Mengelompokkan data dokumen jaminan berdasarkan Nomor ADM yang sama

Dear pak Harry Mas Uki, pak Sam Duhay, pak Sumiyanto terima kasih byk atas pencerahannya shg saya memiliki byk pilihan utk di combined

Salam,

-ignatius s. sinaga-

From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of Mas Uki
Sent: Friday, August 31, 2012 10:47
To: belajar-access@yahoogroups.com
Subject: Bls: [belajar-access] Mengelompokkan data dokumen jaminan berdasarkan Nomor ADM yang sama [1 Attachment]

[Attachment(s) from Mas Uki included below]

Salam kenal p Ignatius,

Sedikit bagi pengalaman, untuk urusan sortir,pengelompokan,penjumlahan, dll memang bisa dilakukan melalui query, dan khusus untuk urusan pengelompokan data saya lebih suka menggunakan Pivot Table yang datanya dihasilkan dari query, proses cepat hasilnya bagus. Silakan anda coba tampilan PivotTable dan lakukan drag-drop dengan mudah, screenshot terlampir (jika tampilan kurang sesuai, silakan eksplorasi dengan drag-drop).

Best Regards,

Sukiono

PT. Kumala Kencana Cipta

www.kumalahome.com

Dari: ignatius sinaga <ignatiussinaga@yahoo.com>
Kepada: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Dikirim: Selasa, 28 Agustus 2012 18:31
Judul: [belajar-access] Mengelompokkan data dokumen jaminan berdasarkan Nomor ADM yang sama [1 Attachment]

Selamat sore rekan2 dan para master Access,

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

New Members 10

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] Problem with checkboxes randomly disappearing

Crystal,
I tried using the Load event, however, when the form opens, it is filtered so the checkboxes aren't always shown so I get and error "you entered an expression that has no value."

John F

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi John,
>
> perhaps you want to use the form LOAD event -- this fires one time, when the data is loaded. The Current event is triggered upon landing on another record, or a new record
>
> ... but rather than doing this, why don't you use option buttons instead of checkboxes? That way they become mutually exclusive automatically :)
>
> anyway, there is often a better way than using checkboxes ... for instance, store a date/time, and a result like Pass or Fail
>
>
> Warm Regards,
> Crystal
>
> Learn Access on YouTube
> http://www.YouTube.com/LearnAccessByCrystal
> ________________________________
> From: jfakes.rm <jfakes@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, August 31, 2012 8:32 AM
> Subject: [MS_AccessPros] Problem with checkboxes randomly disappearing
>
> I had an issue with two checkboxes randomly disappearing on a form in MS Access 2003. What I am trying to do is if a person passes an eye exam, the chkPassEyeMRR is checked so I don't want to see the chkFailEyeMRR checkbox.
>
> Below is the code I am using in the "On Current" event.
>
> 'Hides checkboxes if one of the other check boxes are checked.
> If [chkPassEyeMRR] = True Then
> [chkFailEyeMRR].Visible = False
> ElseIf [chkFailEyeMRR] = True Then
> [chkPassEyeMRR].Visible = False
> Else
> [chkPassEyeMRR].Visible = True
> [chkFailEyeMRR].Visible = True
> End If
>
> When I open the form, the pass or fail checkbox displays properly. However, as I move from record to record, the checkboxes randomly disappear and reappear.
>
> I have similar code for different controls on a separate tab on the same form and that code works and the textboxes display properly.
>
> Any idea what is going on and how I can fix the issue?
>
> John F

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

New Members 6
New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

[belajar-access] Download Quran Database SE

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

New Members 8

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___

Re: [MS_AccessPros] Problem with checkboxes randomly disappearing

Hi John,

perhaps you want to use the form LOAD event -- this fires one time, when the data is loaded. The Current event is triggered upon landing on another record, or a new record

... but rather than doing this, why don't you use option buttons instead of checkboxes? That way they become mutually exclusive automatically :)

anyway, there is often a better way than using checkboxes ... for instance, store a date/time, and a result like Pass or Fail

Warm Regards,
Crystal

Learn Access on YouTube
http://www.YouTube.com/LearnAccessByCrystal

*
(: have an awesome day :)
*

________________________________
From: jfakes.rm <jfakes@rocketmail.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, August 31, 2012 8:32 AM
Subject: [MS_AccessPros] Problem with checkboxes randomly disappearing

I had an issue with two checkboxes randomly disappearing on a form in MS Access 2003. What I am trying to do is if a person passes an eye exam, the chkPassEyeMRR is checked so I don't want to see the chkFailEyeMRR checkbox.

Below is the code I am using in the "On Current" event.

'Hides checkboxes if one of the other check boxes are checked.
If [chkPassEyeMRR] = True Then
[chkFailEyeMRR].Visible = False
ElseIf [chkFailEyeMRR] = True Then
[chkPassEyeMRR].Visible = False
Else
[chkPassEyeMRR].Visible = True
[chkFailEyeMRR].Visible = True
End If

When I open the form, the pass or fail checkbox displays properly. However, as I move from record to record, the checkboxes randomly disappear and reappear.

I have similar code for different controls on a separate tab on the same form and that code works and the textboxes display properly.

Any idea what is going on and how I can fix the issue?

John F

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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

New Members 6
New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

__,_._,___