This video demonstrates how to install and configure the MySQL ODBC driver on a Windows-based PC and then use it to connect either Microsoft Access or Open Office Base to a MySQL database. Part 1 of 2.
Tag: Access
ASP.NET AJAX – Sys.Net.WebRequest to Access Web Service – Part 1 of 4
The tutorial shows how to access web services using client side ASP.NET AJAX libraries. We use Sys.Net.WebRequest to access remote web service.
Querying Table Data Using Visual Basic Code in MS Access
In order to fully utilize the capabilities of MS Access, one must learn not only learn the Visual Basic (VB) programming language, but should also learn Standard Query Language (SQL). Once a grasp of these two languages have been obtained, MS Access users can begin to build faster and more efficient databases.
One tool that has proved itself very useful to me over the years is querying data from tables or queries using VB and SQL code. A brief introduction to this process is presented in this article. To best understand this process, an example is provided below along with an explanation of its parts.
'*********CODE*********** Dim rstTemp As Recordset Dim strSQL As String Dim routeNum As Integer strSQL = "SELECT [Route], [Main Route PM], [Intersecting Route], [IntBeginPM], [IntEndPM] “ strSQL = strSQL + “FROM Intersections_list WHERE (((CStr([Route])) = """ + cmbRouteQuery + """));" Set rstTemp = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset) If (Not (rstTemp.EOF)) Then rstTemp.MoveFirst routeNum = rstTemp(0) '************************
Continue reading “Querying Table Data Using Visual Basic Code in MS Access”