UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Automate Uploading A Report To A Website    
 
   
WhiteNite1971
post Dec 5 2010, 07:05 AM
Post #1

UtterAccess Veteran
Posts: 322
Hey Gang

Has anyone dabbled in automating uploading a report to a website using a macro in Access 2010?

Cheers

WN
Go to the top of the page
 
+
HiTechCoach
post Dec 5 2010, 10:03 PM
Post #2

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
QUOTE (WhiteNite1971 @ Dec 5 2010, 06:05 AM) *
Hey Gang

Has anyone dabbled in automating uploading a report to a website using a macro in Access 2010?

Cheers

WN


I don't think it is possible with just macros. Honestly I have never tried it with macros. I rarely uses them do their limited error handling capabilities. I need bullet proof error handling since I use the Access runtime most of the time.

I do know it is possible with VBA code. I to do it regularly. Here is some sample code that might help: FTP Client functions
Go to the top of the page
 
+
WhiteNite1971
post Dec 7 2010, 05:10 AM
Post #3

UtterAccess Veteran
Posts: 322
Hi HTC

Will check this link out. Much appreciated.

Regards

WN
Go to the top of the page
 
+
WhiteNite1971
post Jan 2 2011, 06:08 PM
Post #4

UtterAccess Veteran
Posts: 322
Hi HTC

Looks rather advanced. I'm just dipping my toe in the water at this point. Any suggestions i.e. articles, samples, templates?

Cheers

Jase
Go to the top of the page
 
+
HiTechCoach
post Jan 2 2011, 08:03 PM
Post #5

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma
QUOTE (WhiteNite1971 @ Jan 2 2011, 05:08 PM) *
Any suggestions i.e. articles, samples, templates?

Jase,

The link I gave you was for a sample and template.

FTP'ing is not a simple/trivial task. Access does not have the built in ability to FTP. Windows does have a command line ftp utility that you can use. There are third-party custom controls that you can buy that might be easier for you. There are some freeware versions that are good also.

I am thinking that Chilkat Software has a Lite version of their FTP control that is freeware. You can find a link to then here: Access Developer Tools: Apps, Add-ins, VBA Code
Go to the top of the page
 
+
« Next Oldest · Access Q and A · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 05:28 AM