Home   Fees/Services   Access Templates   Tutorials  Tutorial Downloads   Articles   Search   Contact  Privacy  Links
SQL API Function Example
Yahoo Finance API Query
 






Query Tutorials Index:
Too Complex Query
Aggregate Query
Not In Operator
Choose Function
Crosstab Query
Date Time Query
Delete Query
External Table Query
Report Filter Query
Group By Query
Having Query Clause
Histogram Query
Access Append Query
Master Detail Update
Order By Query
SQL Parameter Query
Predicate Query
Self Join Query
Scalar SubQuery
Master Detail Query
Select Query
Select Top
Union Query
SQL Update Query
Custom Query Function

 

MultiSelect Parameter Forms Query Tutorial


API Function Query Example

Access API Tutorial

Need to use an API to get data from a website into an Access database?  This is a fairly common requirement and we show a great example on this page.  Here we are going to retrieve the current price of stocks trading out there in the stock market.  We will use Yahoo Finance's API for this.



Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. The number of users supported depends on the transaction load and the amount of data but generally we recommend a limit of 10 to 15 users.

Are you looking for an MS Access template database? We have many for sale in our Access Template and Examples Software section.


In the example below we first create a Public Function containing the API code.  The we call that function while using a Select Query to retrieve our stock symbols from our table.

Once see how to dynamically retrieve the current stock prices you can show them in a form or change to an Update Query to save the in a table along with the current date.  If you wanted to you could create an Access database that would wake up once a day on update your database of stock quotes.  This way you can plot them over time.

Here is the table we are using for this SQL API function example:

M_Stocks
Stock_Symbol
INTC
IBB
VOX
F

Next is the function we have created:

get data from website via Access query

And the Access query contains this query code:

vb function in access query

And when we run the query we get:

access api query example

Contact us here at Blue Claw Database Design if you feel we could help you get your job done quickly.  We promise to only charge when we delivery a product or component and we will always tell you how much programming will cost up front.  We have programmed more than 500 databases all over the USA and all over the world.  Contact us today!

You can also read more about Yahoo Finance's stock quote api.  There is a lot more information about each stock that can be pulled using the API.







A Blue Claw Software Design Template:

Prescription Assistance Plan Admin Template
 









A Blue Claw Database Design Article:

ODBC Links To Other DB Systems
 









Blue Claw Database Design Downloadable Tutorial:
Use Global Variables as Parameters  








Microsoft Office:
MS Access 2000 Through Access 2016 & Office 365
 


Contact Information

Copyright 2000-2017 Blue Claw Database Design