Mini SQL Query aims to satisfy the most common tasks what the average user seeks to achieve, in doing so it keeps the size and complexity of the application to a minimum.
Some Core features: ** Note that all these types of connections depend on your system configuration ** Note that the target audience for this tool is not developers who tend to only deal with MSSQL, it's geared towards having to hit several different database sources... See Setting-up-a-Mini-SQL-Query-Development-Environment. Originally hosted out of my site - Sql Query/ - also see the blog for some info but needs updating!
Members are able to post questions and help others with problem solutions.
Utter Access has been seen in over 160 countries, recording over one billion hits to date.
Microsoft Access Tables, Queries, Forms, Reports, Pages, Macros, Modules...you'll find all the free samples and answers here!
Project Description Mini SQL Query is a minimalist SQL query tool for multiple databases (MSSQL, MSSQL CE, SQLite, OLEDB, MS Access/Excel files etc).
The project has been imported to Git Hub and further updates will happen there: https://github.com/paul-kohler-au/minisqlquery - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - See Mini SQL Query v1. for a version that included SQLite.
This is the main release now :-) Current Stable Release Mini SQL Query is "deliberately minimalist".
Software too often becomes bloated and less usable while trying to satisfy the 99% of what every user wants.
Function Update Transaction Date() As Boolean Dim db As Database Dim LUpdate As String Dim LMsg As String Dim LTransaction Dt As Date On Error Go To Err_Execute 'Query user for Date of R LMsg = "Enter the Date of R Form __/__/____" LMsg = LMsg & Chr(10) & Chr(10) & "Format date as: mm/dd/yyyy" LTransaction Dt = Input Box(LMsg) Set db = Current Db() 'Re-Assign Date to Transaction Date LUpdate = "update [Chapter Form Bulk Input Table]" LUpdate = LUpdate & " set [Transaction Date] = #" & Format(LTransaction Dt, "mm/dd/yyyy") & "#" db.
Execute LUpdate, db Fail On Error Set db = Nothing Msg Box "Changing the Dates was Successful." Update Transaction Date = True On Error Go To 0 Exit Function Err_Execute: Msg Box "Updating the dates failed, you will need to enter each date individually." Update Transaction Date = False End Function You can then call the function from a Form (ie: button click event, etc) or a Macro and it will update the Transaction Date field.