Selasa, 30 Agustus 2016

[MS_AccessPros] Saving files to onedrive via access vba

 

Hi,
We are possibly moving to access 2016 AND onedrive, and I was wondering if it's possible to automate file distribution to a onedrive location with that version of access? 

Currently we are on access 07 with NO onedrive and I just use docmd.transferspreadsheet, and for the file name parameter i just put the full folder path and file name so it saves into the network folder.  I'm not sure how onedrive works though, so I figured I'd start here :)

Thanks
-Lee


__._,_.___
Posted by: leevt99@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

[belajar-access] Tanya Query Union [1 Attachment]

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

Selamat malam para Master Belajar Access


Mohon maaf, saya mohon bantuannya, jika saya punya tabel seperti ini, bagaimana menggunakan query union untuk menggabungkan field akun_debet dan akun_kredit menjadi satu, serta menjumlahkan Field Nilai, 

seperti di tabel query yang diinginkan


terlampir file yang saya tanyakan


sebelumnya saya mengucapkan banyak terima kasih kepada para master belajar access


maju terus milis belajar access


Terima Kasih


Irwan



__._,_.___

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

1 of 1 File(s)

contoh.accdb
Posted by: setiawanted1001@yahoo.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPAM IS PROHIBITED

.

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

[belajar-access] Info Training MS Access - Oktober 2016 [1 Attachment]

 
[Attachment(s) from RumahAccess Indonesia included below]

Bpk Moderator dan Anggota Milis yth. Mohon izin menyampaikan info jadwal training MS Access.

RumahAccess Indonesia (www.RumahAccess.com) membuat jadwal training sebagai berikut:

Sabtu, 22 Oktober 2016 (materi: MS Access - Basic)
Minggu, 23 Oktober 2016 (materi: MS Access - Programming)

Peserta boleh memilih salah satu materi atau kedua-duanya, namun disarankan agar peserta mengambil dua materi sekaligus (Basic dan Programming), karena materi Basic merupakan persyaratan untuk materi Programming.

Informasi lebih lengkap dapat dilihat di www.RumahAccess.com

Mohon forward informasi ini kepada teman atau saudara yang mungkin membutuhkan.
Terima kasih.


Best regards,

Eva Alvionika
Training Administrator

__._,_.___

Attachment(s) from RumahAccess Indonesia | 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.
Training MS Access October 2016 - Small.jpg
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPAM IS PROHIBITED

.

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

Re: [MS_AccessPros] Birthdays Report

 

OK, that makes more sense!  If the day sort is below the group on month, then the records should be sorted correctly.


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




On Aug 30, 2016, at 8:37 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:




OOOPS! Sorry that  Was a typo !!!!  It should be 10. All of the other entries return 10. Yes ten.

Red faced!

 Robin

At 30/08/2016 01:48 PM, you wrote:
  

Robin-

The Month function should return values 1 to 12.  It should never return 19!  Is birthdate a Date / Time field?

John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications
http://www.viescas.com/

On Aug 29, 2016, at 23:48, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:


Duane,

The month provides numeral 1 for the first group and numeral 19 for the second group. There are no other groups.

The day gives the day date for each entry.

I hope that means something to you!

Thanks,

Robin

At 29/08/2016 03:42 PM, you wrote:
  

Robin,

Add a text box to the month group header with a control source of:

=Month([birthdate])

Add a control to the detail section with a control source of:

=Day([birthdate])

What do you see when you run the report?

Duane Hookom

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 29 Aug 2016 08:24:37 +1000
Subject: RE: [MS_AccessPros] Birthdays Report



Thanks Duane,

I have now done that and the first group shows January as the first month and lists birthdays in ascending order.

The next group header is May with all the remaining birthdays in random order. There is not another month group header

What have I missed?

Regards,

Robin


At 26/08/2016 08:17 PM, you wrote:
  
Robin,
 
Display the report sorting and group. Then select to group by the expression:
  Month([birthdate])
Then add another sorting expression of:
  Day([birthdate])
You can format the [birthdate] text boxes in your report sections to display whatever you want.
 
Regards,
Duane
 
> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 26 Aug 2016 14:02:03 +1000
> 
> I have a members database which includes their birthdays. I plan to 
> make a report that groups birthdays on the month and then sorts them 
> by the day.
> 
> How do I do that?
> 
> Many thanks,
> 
> Robin Chapple





__._,_.___
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 (17)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Senin, 29 Agustus 2016

Re: [MS_AccessPros] Birthdays Report

 


OOOPS! Sorry that  Was a typo !!!!  It should be 10. All of the other entries return 10. Yes ten.

Red faced!

 Robin

At 30/08/2016 01:48 PM, you wrote:

 

Robin-

The Month function should return values 1 to 12.  It should never return 19!  Is birthdate a Date / Time field?

John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications
http://www.viescas.com/

On Aug 29, 2016, at 23:48, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:


Duane,

The month provides numeral 1 for the first group and numeral 19 for the second group. There are no other groups.

The day gives the day date for each entry.

I hope that means something to you!

Thanks,

Robin

At 29/08/2016 03:42 PM, you wrote:
 

Robin,

Add a text box to the month group header with a control source of:

=Month([birthdate])

Add a control to the detail section with a control source of:

=Day([birthdate])

What do you see when you run the report?

Duane Hookom

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 29 Aug 2016 08:24:37 +1000
Subject: RE: [MS_AccessPros] Birthdays Report



Thanks Duane,

I have now done that and the first group shows January as the first month and lists birthdays in ascending order.

The next group header is May with all the remaining birthdays in random order. There is not another month group header

What have I missed?

Regards,

Robin


At 26/08/2016 08:17 PM, you wrote:
 
Robin,
 
Display the report sorting and group. Then select to group by the expression:
  Month([birthdate])
Then add another sorting expression of:
  Day([birthdate])
You can format the [birthdate] text boxes in your report sections to display whatever you want.
 
Regards,
Duane
 
> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 26 Aug 2016 14:02:03 +1000
>
> I have a members database which includes their birthdays. I plan to
> make a report that groups birthdays on the month and then sorts them
> by the day.
>
> How do I do that?
>
> Many thanks,
>
> Robin Chapple


__._,_.___
Posted by: Robin Chapple <robinski@westnet.com.au>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (16)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Re: [MS_AccessPros] Birthdays Report

 

could be it is giving 1 and then 9 ... and there is no space between the 2 values ...

respectfully,
crystal

~ have an awesome day ~


On 8/30/2016 12:21 AM, graham@mandeno.com [MS_Access_Professionals] wrote:
Hi Robin

You don't perchance have your own function called "Month" do you?  That is the ONLY possible explanation I can think of for the function to return 19.

What happens if you open the Immediate Window (Ctrl-G) and type:

?Month(Date) <enter>

It should return 8 (this being August).

-- Graham


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

Robin-

The Month function should return values 1 to 12.  It should never return 19!  Is birthdate a Date / Time field?

John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications

On Aug 29, 2016, at 23:48, Robin Chapple robinski@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


Duane,

The month provides numeral 1 for the first group and numeral 19 for the second group. There are no other groups.

The day gives the day date for each entry.

I hope that means something to you!

Thanks,

Robin

At 29/08/2016 03:42 PM, you wrote:
 

Robin,

Add a text box to the month group header with a control source of:

=Month([birthdate])

Add a control to the detail section with a control source of:

=Day([birthdate])

What do you see when you run the report?

Duane Hookom

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 29 Aug 2016 08:24:37 +1000
Subject: RE: [MS_AccessPros] Birthdays Report



Thanks Duane,

I have now done that and the first group shows January as the first month and lists birthdays in ascending order.

The next group header is May with all the remaining birthdays in random order. There is not another month group header

What have I missed?

Regards,

Robin


At 26/08/2016 08:17 PM, you wrote:
 

Robin,
 
Display the report sorting and group. Then select to group by the expression:
  Month([birthdate])
Then add another sorting expression of:
  Day([birthdate])
You can format the [birthdate] text boxes in your report sections to display whatever you want.
 
Regards,
Duane
 
> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 26 Aug 2016 14:02:03 +1000
>
> I have a members database which includes their birthdays. I plan to
> make a report that groups birthdays on the month and then sorts them
> by the day.
>
> How do I do that?
>
> Many thanks,
>
> Robin Chapple




__._,_.___
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 (15)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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

Re: [MS_AccessPros] Birthdays Report

 

Hi Robin


You don't perchance have your own function called "Month" do you?  That is the ONLY possible explanation I can think of for the function to return 19.

What happens if you open the Immediate Window (Ctrl-G) and type:

?Month(Date) <enter>

It should return 8 (this being August).

-- Graham


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

Robin-

The Month function should return values 1 to 12.  It should never return 19!  Is birthdate a Date / Time field?

John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications

On Aug 29, 2016, at 23:48, Robin Chapple robinski@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


Duane,

The month provides numeral 1 for the first group and numeral 19 for the second group. There are no other groups.

The day gives the day date for each entry.

I hope that means something to you!

Thanks,

Robin

At 29/08/2016 03:42 PM, you wrote:
 

Robin,

Add a text box to the month group header with a control source of:

=Month([birthdate])

Add a control to the detail section with a control source of:

=Day([birthdate])

What do you see when you run the report?

Duane Hookom

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 29 Aug 2016 08:24:37 +1000
Subject: RE: [MS_AccessPros] Birthdays Report



Thanks Duane,

I have now done that and the first group shows January as the first month and lists birthdays in ascending order.

The next group header is May with all the remaining birthdays in random order. There is not another month group header

What have I missed?

Regards,

Robin


At 26/08/2016 08:17 PM, you wrote:
 

Robin,
 
Display the report sorting and group. Then select to group by the expression:
  Month([birthdate])
Then add another sorting expression of:
  Day([birthdate])
You can format the [birthdate] text boxes in your report sections to display whatever you want.
 
Regards,
Duane
 
> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 26 Aug 2016 14:02:03 +1000
>
> I have a members database which includes their birthdays. I plan to
> make a report that groups birthdays on the month and then sorts them
> by the day.
>
> How do I do that?
>
> Many thanks,
>
> Robin Chapple



__._,_.___
Posted by: graham@mandeno.com
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (14)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

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