ACCESS FEED

Rabu, 02 Desember 2015

Re: [MS_AccessPros] Re: weird page visibility issue

Hi Bill,

happy you can smile ~ life goes on, as it must

warm regards,
crystal

~ have an awesome day ~

On 11/30/2015 9:40 PM, 'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals] wrote:

Hi Crystal

I don't have a response for this:

>> just don't aim the water at my parts

But then that's just too funny! I once knew a girl who was very slender. She told me she had to run around in the shower to get wet.

This whole topic has become more entertaining than enlightening. But that's okay, too!

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 30, 2015 6:01 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: weird page visibility issue

Hi Bill,

my eyes dry out too -- perhaps a humidifier in the environment where you are will help ... too bad they aren't so good for computers. I have one -- just don't aim the water at my parts .... but then again, some is ok -- helps coagulate the dust buildup so Q-tips can do the job ~

and heaters... I don't like them either .... sometimes though it is a must since it also is cold! In a car, I have found that it helps not to open the upper vents, and crack a window just past where it whistles ~ and when inside, splash cold water on the face and especially eyes ... rehydrate :)

btw, in my eyes, you are a king ... perhaps it is time to blog?

hope you are well ... and you too, Liz.

warm regards,
crystal

~ have an awesome day ~

On 11/30/2015 3:23 PM, wrmosca@comcast.net [MS_Access_Professionals] wrote:

Liz-

So far I'm just using eye drops. My ophthalmologist says that's the way to go. My sister is using Restasis but says she can't tell if it is helping or not. She still uses eye drops.

Remembering to look away from my monitor once in a while is the hardest part but helps a lot. I've had to learn to live with my car heater/air conditioner set so it rarely comes on. That really dries out my eyes.

-Bill

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

Bill, I'll follow this thread because eyes for those of us working long hours on computers is an issue.

Are you getting treatment for your syndrome them?

I also have a lot of floaters and found a doctor in VA who has been doing surgeries with a different type of laser with a 95% success rate. I had a recent PVD in just the last few weeks so I've got a bunch more. At least it isn't what it could be since my lenses were replaced from cataract surgery. Oh the woes. I won't even begin to bother you with the rare AZOOR I got in 95.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 30, 2015 2:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: weird page visibility issue

Liz

I can sympathize. I've got dye eye syndrome and blur up from time to time so much I can't read anything on my monitor.

Just remember, a tab control has pages. Why they are not called tabs, Mosca don't know. Mosca only pawn in game of life.

Bill

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

Bill, THANKS!

Okay, you want to know something embarrassing? I selected the tab control to see what the name was so I could follow this syntax and guess what? I had named it "Archiving." So yes, I was effectively setting the whole thing to invisible.

In my defense. I have multiple eye issues with the latest being meibomian gland dysfunction.

Arrgh.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 30, 2015 1:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: weird page visibility issue

Liz

You have to refer to the tab control's Pages.

Me.myTab.Pages("Archive").Visible = False

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

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.

__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (13)

Visit Your Group

New Members 1

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Selasa, 01 Desember 2015

[MS_AccessPros] Re: Help with VBA code

All you need to do is set the .Picture property of an image control.

Private Sub cmdLoadPic_Click()

Me.Image14.Picture = "C:\DB_Pictures\Dilbert_BugReward.bmp"

End Sub

To remove the picture, just set the .Picture proprty to an empty string like this:

Private Sub cmdUnload_Click()

Me.Image14.Picture = ""

End Sub

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, <kenaf42@yahoo.com> wrote :

ACCESS 2010

Please help, I need code for button on click event to embed a picture in FORM and code for second button to remove the embedded photo from The same form.

__._,_.___

Posted by: wrmosca@comcast.net

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

[MS_AccessPros] Help with VBA code

ACCESS 2010

Please help, I need code for button on click event to embed a picture in FORM and code for second button to remove the embedded photo from The same form.

__._,_.___

Posted by: kenaf42@yahoo.com

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

[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 (105)

SPAM IS PROHIBITED

Visit Your Group

New Members 2

• Privacy • Unsubscribe • Terms of Use

__,_._,___

[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 (137)

Please zip all files prior to uploading to Files section.

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Re: [belajar-access] Simpan dari dua form ke satu tabel [2 Attachments]

[Attachment(s) from Darsono darsono72@yahoo.com [belajar-access] included below]

Hallo Satri,

Mencoba menjawab,

Coba gunakan modul,
caranya buat modul Public :

Option Compare Database

Public Sub simpan_data(data_nya As String)

Set db = CurrentDb

SQL = "INSERT INTO Table1 (Field) Values('" & data_nya & "')"

db.Execute SQL, False

db.Close

Set db = Nothing

End Sub

selanjutnya

buat event onclik pada tombol simpan (bukan menggunakan Macro) pada kedua form

Private Sub Command2_Click()

Call simpan_data(Text0)

End Sub

selamat mencoba.

Darsono
Simpati - WA : 0812-8670-1010
M3 : 0856-878-1010
FB : Darsono Kroya
Twitter : @darsono72

BB : 5570F542

On Tuesday, December 1, 2015 3:52 PM, "satriauad@yahoo.co.id [belajar-access]" <belajar-access@yahoogroups.com> wrote:

[Attachment(s) from satriauad@yahoo.co.id [belajar-access] included below]

Master...
Mohon bantuan, saya punya 2 form yang identik dan proses simpan keduanya sama ke 1 tabel (file saya sertakan).
Bagaimana ya caranya agar penulisan codenya/module nya cuma satu, biar proses editnya mudah, maaf dan terimakasih

__._,_.___

Attachment(s) from Darsono darsono72@yahoo.com [belajar-access] | View attachments on the web

1 of 1 Photo(s)