Search results

Basicly I enter the work date and then the times in and out below. At the moment I have to enter the date each time I enter a time. I'm just trying to simplify it a little and make it so I enter the work date and then the times and it adds up the hours. There are occasions where the times can...

I have a form that has a date worked at the top and then an area to enter times in and out. The times in and out use the default Date/Time field and then calculate the hours worked. How can I have the times in and out read the date worked field for the date section and only require me to enter...

I had tried that before but kept getting errors saying the object did not exist. The problem was the placement of the renaming section. I moved that section to before the "Exit_SaveImage:" and now it works perfectly. I will post the entire code in case anyone wants to use it.

Ok. So I have learned my lesson on saving images into an Access DB. Now I'm using VBA (another good learning experince) to save the images back to a folder. I have a code working that will save the images but I need it to also rename the images after saving. The section "MyFile = OldFile"...

OK. So I have the code so that it puts the data into a table... now I can't seem to get it to loop through... if the sitenumber field would increment by 100 and the loop back through the code until the number reaches 1,000 then I would have all the data. If I manually change this and then run...

Ok. How do I call the API and get the info into the DB?

That's why I'm stuck. So far, this is the only code I've managed to piece together (with absolutely no code schooling) and actually get anything from the API. I have a few sites that provide a web API like this one. That's the reason I'm trying to figure out how to use an API like this and...

The complicated code? What would that be? I thought it would be easier to just download the already available XML file and import that. I already have a way to import XML and even a kill code to get rid of the file once imported. All I really need now is a way to save the XML once it's called...

Baisicly I just want the code to pull the information from the site and import the information into the correct field in Access. I've figured out how to get to the site holding the information. Now I need to get the information from the site and into the DB.

That is way to advanced for me. I started with something like this code below. It brings up the explorer with the information on it. If you could help me figure out how to get it to save the xml, or maybe even import the data without having to save the file...

ANY help is more than welcome

http://www.giantbomb.com/forums/api-developers-3017/quick-start-guide-to-using-the-api-1427959/#6

I'm trying to learn on a game DB. The site I'm using is...

OK. I found the website has an API that returns XML. I know how to use xml once it is on my computer. I need help on how to use VBA to call the website's API, search for the title, then import the xml file that is returned. Any suggestions on where to find this? Google isn't much help on this issue.

Excel is much easier. But the task is to get an Access DB to do it.

I'm trying to learn how to automate my Access database to get information from a web site. Any suggestions on how to learn this or where to learn this?

Good catch... I had labeled "EpisodeNumberTitle" instead of "EpisodeNumberTotal". I corrected that and began getting a different error stating "File Sharing lock count exceeded. Increase MaxLocksPerFile registry entry." A quick google search gave me this line of code... "DAO.DBEngine.SetOption...

I copied the code onto a button to test it and tried changing the lines to fit what I need. I keep getting an error on line... Set rs = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset) The error says... "Run-time error '3061': Too few parameters. Expected 1.

I understand what you guys are trying to say. I still concider myself a novice at coding although I have gotten some pretty intense codes to work. Like a button to import many xml files while replacing any instances of the & symbol. I just needed a point in the right direction of how to start...

I know the differences and when to use the actual autonumber function. That was just a way to explain what I'm trying to do. I just dont want to site for hours numbering episode records in the hundred thousand range. I want Access to number these for me but I don't know how to make it do that.