Internet Transfer Control Trouble - DRIVING ME POTTY!

[cfmonk]

Hi guys,

I am going completely out of my mind so I thought I would make my first post here.

I am trying to use the Internet Transfer Control to stroe information in Google Calendar. How to do this is documented all over the place but I am struggling to get the control to work on the most basic levels.

I can use it to download a web page, no problems and I can use it in VB to access google calendar BUT I cannot seem to make it work in Access.

I want to use it to execute a command, but whatever execute command I give it, the StateChanged event NEVER SEEMS TO HAPPEN!!!!

Here is some code I have been using, copied directly from the microsoft website:


Private Sub Form_Load()
' Set a reference to the Internet transfer control.
Set objFTP = Me!axFTP.Object
End Sub

Private Sub cmdGetFile_Click()
Dim strSite As String
Dim strFile As String
strSite = Me!txtFTPSite
strFile = Me!txtFileName
objFTP.Protocol = icFTP
objFTP.URL = strSite
objFTP.Execute strSite, "Get " & strFile & " C:\" & strFile
End Sub



PLEASE does anyone have a working example or can help???

 

[cfmonk]

Bump.

PLEASE any help would be great!

Or any other way of using Google Calendar....