Recent content by TopherGeorge

I have actually corrected the last bit, just realised there is a comma that needed inserting after "Get". The code is failing at the following place, but I just cant work out why? If fnSaveDownloadFile(strFileToSave, .respondseBody) = False Then fnDownloadHTTP = False

The code I am using looks as below, can you see if its right. I have assigned the first function to a button that runs upon clicking: Option Compare Database Option Explicit Private Sub Command74_Click() Dim strHTTP As String Dim strFileToSave As String strHTTP =...

I am having issues with the: I am getting an error here .Open "GET" strHTTP, False

This is great, I had something implmented but Im having problems with the code I have so I will try it with what you have added in. Can you tell, will this ensure that it overwrites the file that it replaces everytime it downloads. The code i put together should use the overwriteKill...

I have also tried the following but with no luck, i get "RUNTIME ERROR 3004, Write to file failed" Option Compare Database Sub downloadpde() Dim myURL As String myURL = http://companyname.com/ProjectData.xls Dim WinHttpReq As Object Set WinHttpReq = CreateObject("Microsoft.XMLHTTP")...

I really need some help. I am about to make my database live but I have one big problem I need to overcome. At the moment I can manually download the ProjectData.xls file from the company website using a url similar to www.companyname.com/discovery/ProjectData.xls. I have then written the...

Hi all, Can anyone give me a clear indication how to use combo boxes/text boxes on a form for users to input their user ID and this to update the tblUserID with both the UserID and LoginDate (Date/time) when a person logs into a database by pressing OK on the welcome screen. This needs not...

Indeed, I wish her all the best! Is she at RAF Northholt? I did things in reverse. Spent many a year working out of north carolina and Oceana airfield in Virginia. Its my time in the states that made me decide to leave the military. Im heading back to North Carolina soon. Although now im trying...

Hello all, my name is Topher. What a great forum you have here :rolleyes:, its already answered so many of my questions :confused: and saved my new allbeit short career in the Financial Services :D. Well I guess in the introduction section you want to know about me: I am a 26 year old guy...

Ive given a few methods a go, including running a query to apend data to a table but I cant seem to get things to work. I am using access 2007 to create this database. I am using an input mask for the unique ID number, and have to go on good faith that they enter credentials correctly as it...

Hi all, :D Please help! Hoping someone could offer me some advice. I am making a database for project managers, but I need to be able to monitor their logins. I am relativly new to access but after much learning I have managed to get a database up and working but now I am ironing out some...

That is amazing, I will give it a try now and report back to you. Again thank you so much for your help it is very much appriciated.

I was hoping someone could help me or refer me to the relevent tutorials as I am having some problems. I am working on a databse for project managers to allow them to get a holistic overview of their projects. I am normally an Aircraft Engineerthe Royal Navy not a database expert!!! I have...

This is where I am having trouble. I dont really understand how to do this "Set the rowcourse of the next combo box and enables it"

Your a star. Just given me food for thought. I have my story boards all planned out but when it got down to it I realized how complex this all way. I think that last comment is most helpful. I have only just got into databases. But they seem interesting. If u want I can email u my story board of...