Senin, 31 Agustus 2015

[belajar-access] Access dalam LAN

 

Dear para master,

saya sangat awam masalah jaringan, saya terbiasa bekerja dengan access.
Saya ingin aplikasi yang saya kembangan di komputer saya dapat dimanfaatkan dari komputer lain (share database dan interface).
Mohon pencerahan apa yang harus saya lakukan, jika ada File yang bisa saya pelajari saya akan dengan senang hati memperlajarinya.


Terima Kasih

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

.

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

Re: [MS_AccessPros] Application defined, or object defined error

 

Adam-


That's usually a library problem.  On a machine where you're getting this, open the VB Editor, then choose References from the Tools menu.

If that looks OK, could be some minor corruption.  Try creating a new blank database, then import all the objects from the old one.  Be sure to compile the VBA project, save, then compact / repair after doing this.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Aug 31, 2015, at 5:49 PM, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


I get the message "Application defined, or object defined error" intermittently when closing and (I think) opening forms via VB. It's in an Acess2000 application. I think this started about the time they upgraded their OSs from XP to Win7, but I'm not sure. Since the application was supposed to be replaced, after the company I developed for was purchased, and since the application worked fine otherwise, we didn't feel like it was worth my time fixing it. However, 2-1/2 years later, they're still using the app.


Any ideas what may be causing this and how to fix it?


Adam


__._,_.___
Posted by: John Viescas <johnv@msn.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] Application defined, or object defined error

 

I get the message "Application defined, or object defined error" intermittently when closing and (I think) opening forms via VB. It's in an Acess2000 application. I think this started about the time they upgraded their OSs from XP to Win7, but I'm not sure. Since the application was supposed to be replaced, after the company I developed for was purchased, and since the application worked fine otherwise, we didn't feel like it was worth my time fixing it. However, 2-1/2 years later, they're still using the app.


Any ideas what may be causing this and how to fix it?


Adam

__._,_.___
Posted by: runuphillracing@yahoo.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:

Bls: [belajar-access] Bikin Report di Win 10 lemot banget....

 

Terima kasih bang haer & lainnya untuk responnya....

Alhamdulillah sudah solved...dimana sepertinya masalahnya di setting default printernya...

wassalam,
Idwan






Pada Jumat, 28 Agustus 2015 10:25, "salmankomputer salmankomputer@yahoo.com [belajar-access]" <belajar-access@yahoogroups.com> menulis:


 
Maaf maksudnya win 10 atau Office 2010?


Sent from Samsung Mobile



-------- Original message --------
From: "IdwanATuharea idwan_rmk@yahoo.co.id [belajar-access]" <belajar-access@yahoogroups.com>
Date: 25/08/2015 2:15 PM (GMT+08:00)
To: belajar-access@yahoogroups.com
Subject: [belajar-access] Bikin Report di Win 10 lemot banget....


 
Assalamu'alaikum ...

Dear All...

Mohon pencerahannya sejak saya menggunakan Win 10, jika ingin create atau edit sebuah Report lemot/lambat sekali....untuk hal yang lain seperti create table, query, form, macro & module cepat sekali... sudah dicoba  di "compact and repair" namun tetap lemot/lambat sekali...

spek :
- Dual core
- Ram  4 GB
- 32 bit win 10
- HDD free space 159GB

sekali lagi mohon pencerahannya....terima kasih atas attensinya....

Wassalam,
Idwan




__._,_.___
Posted by: IdwanATuharea <idwan_rmk@yahoo.co.id>
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:

Minggu, 30 Agustus 2015

RE: [MS_AccessPros] Re: Using imgMso in Access 2013

I have lots of ideas but no idea which of them if any you might be interested in.

You might want to make sure your reply includes enough of the previous messages to provide some context.

Duane Hookom, MVP
MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Sun, 30 Aug 2015 08:49:52 -0700
> Subject: [MS_AccessPros] Re: Using imgMso in Access 2013
>
>
>
> Any ideas?
>
>


------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Re: Using imgMso in Access 2013

 
.

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

Jumat, 28 Agustus 2015

[belajar-access] Analisa selling by time [1 Attachment]

 
[Attachment(s) from endro.ssl@gmail.com [belajar-access] included below]

Dear Masters,


Saya masih sangat kesulitan untuk membuat pivot selling by time yang gambaran excel-nya seperti pada file terlampir.

Sebagai contoh apabila saya mau bikin interval 1 (penjualan jam 07.30 - 08.30) apabila saya bikin syntax vb-nya:


iif([jam]>=08:30:00;penjualan;0) 


ini tidak mau jalan (error). Apakah yang harus saya lakukan?

Atas pencerahannya saya ucapkan banyak terima kasih.


Salam,

Endro

__._,_.___

Attachment(s) from endro.ssl@gmail.com [belajar-access] | View attachments on the web

1 of 1 File(s)

Selling by time.xls
Posted by: endro.ssl@gmail.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
SPAM IS PROHIBITED

.

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

RE: [MS_AccessPros] RE: color constant or line of code

 

Haha. Back in the 70s I did have a lime green shirt. Those were the days when Mod was the style. My kids still laugh at all the photos of my wife and me.

Sent from my Kindle Fire



From: "Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: Fri Aug 28 13:37:49 PDT 2015
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] RE: color constant or line of code

 

Funny Bill.  Would you wear a shirt that color?  ;-)

 

I finally found one and used a forest green rgb.

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, August 28, 2015 1:25 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] RE: color constant or line of code

 




Liz

 

What’s wrong with lime green? Millions of limes can’t be wrong. Look online for a color picker. I usually use http://www.w3schools.com/tags/ref_colorpicker.asp

 

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]
Sent: Thursday, August 27, 2015 3:37 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: color constant or line of code

 

 

Or me.lblthis.forecolor = rgb(0,255,0) = trying this so I may have this.  Intellisense was helpful with my guess.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, August 27, 2015 3:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] color constant or line of code

 




Pros, I’m wanting something green but the vbGreen is lime.&! nbsp; Do NOT like it.  How do I get a dark green?  Do I need to RGB it and how would that look?

 

Me.lblthis.forecolor = (0,255,0)  ?

 

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-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 r ecipient, please contact the sender by reply e-mail and destroy all co! pies 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.

 






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: Bill Mosca <wrmosca@comcast.net>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (8)

.

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

RE: [MS_AccessPros] RE: color constant or line of code

 

I've got a shirt that color. I typically wear it around Easter time with family. My wife wants me to toss it. I think that's why I hang on to it ;-)
 
Duane
 
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Fri, 28 Aug 2015 20:37:49 +0000
Subject: RE: [MS_AccessPros] RE: color constant or line of code



Funny Bill.  Would you wear a shirt that color?  ;-)

 

I finally found one and used a forest green rgb.

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, August 28, 2015 1:25 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] RE: color constant or line of code

 




Liz

 

What's wrong with lime green? Millions of limes can't be wrong. Look online for a color picker. I usually use http://www.w3schools.com/tags/ref_colorpicker.asp

 

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]
Sent: Thursday, August 27, 2015 3:37 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: color constant or line of code

 

 

Or me.lblthis.forecolor = rgb(0,255,0) = trying this so I may have this.  Intellisense was helpful with my guess.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, August 27, 2015 3:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] color constant or line of code

 




Pros, I'm wanting something green but the vbGreen is lime.&! nbsp; Do NOT like it.  How do I get a dark green?  Do I need to RGB it and how would that look?

 

Me.lblthis.forecolor = (0,255,0)  ?

 

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-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 r ecipient, please contact the sender by reply e-mail and destroy all co! pies 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.

 






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: Duane Hookom <duanehookom@hotmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (7)

.

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

RE: [MS_AccessPros] RE: color constant or line of code

 

Funny Bill.  Would you wear a shirt that color?  ;-)

 

I finally found one and used a forest green rgb.

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, August 28, 2015 1:25 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] RE: color constant or line of code

 




Liz

 

What’s wrong with lime green? Millions of limes can’t be wrong. Look online for a color picker. I usually use http://www.w3schools.com/tags/ref_colorpicker.asp

 

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]
Sent: Thursday, August 27, 2015 3:37 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: color constant or line of code

 

 

Or me.lblthis.forecolor = rgb(0,255,0) = trying this so I may have this.  Intellisense was helpful with my guess.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, August 27, 2015 3:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] color constant or line of code

 




Pros, I’m wanting something green but the vbGreen is lime.&! nbsp; Do NOT like it.  How do I get a dark green?  Do I need to RGB it and how would that look?

 

Me.lblthis.forecolor = (0,255,0)  ?

 

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-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 r ecipient, please contact the sender by reply e-mail and destroy all co! pies 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.

 






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: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)

.

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

RE: [MS_AccessPros] Re: Alternative multi user options?

 

Adam

 

I'm not sure. I think 2013 creates actual independent web pages that can be accessed in a browser, but do some research before you go crazy with this. And you will need a host like Office 365.

 

Regards,

Bill

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, August 27, 2015 9:25 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Alternative multi user options?

 

 

Bill,

One more question. Can I assume that an upgrade to 2013 for web app is only required for the developer, me, and not all the users?

 

Adam

__._,_.___
Posted by: "Bill Mosca" <wrmosca@comcast.net>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (14)

.

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