-
Recent Posts
- SQL Azure link to managing permissions
- SQL Azure – Take Complete Backup of Azure Database (Structure and Data)
- Connect MS Access 2003 to MySQL
- VBA : Scripting in MS ACCESS to run multiple Queries consecutively
- VBA Code : Run a Function and Link Functions together ( or Scripting in MS Access)
- Upload Shape Files into SQL Azure using OGR2OGR – Explanation of SQL Azure Connection String to be placed within OGR2OGR Command Line
- VBA Function to Create Table of Import strings using OGR2OGR targeting a SQL Server
- SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables
- MS Access VBA Function (Part 5) – Run SQL Queries from a table
- MS Access VBA Function (Part 4) – Write queries to a table
- MS Access VBA Function (Part 3) Address Matching – Find X Replace Y
- MS Access VBA Functions (Part 2) Address Matching – UK Postcode String Finder
- MS Access VBA Functions (Part 1) Address Matching – Add and Drop Fields
- MS Access – Separate Number from a combined Number Street Field
- MS Access front end – SQL Azure back end Link to Configuration Set UP FMS Group
- MS Access VBA Function – create UID starting at prescribed number
- Linking to SQL Server / Oracle – don’t skip the set key field on linking
- MS Access VBA Function – Loop through Query Objects and write SQL to Table
- MS Access VBA Function – Automated Multiple Query Object Creation from previously created table of SQL
- Chrome v:56.0.2924.87 – Run Web Applications in Application Mode
Archives
- September 2017 (2)
- August 2017 (5)
- July 2017 (1)
- June 2017 (5)
- April 2017 (5)
- March 2017 (6)
- February 2017 (1)
- January 2017 (1)
- December 2016 (2)
- November 2016 (1)
- October 2016 (1)
- July 2016 (1)
- June 2016 (1)
- April 2016 (7)
- March 2016 (2)
- February 2016 (3)
- January 2016 (2)
- December 2015 (3)
- August 2015 (1)
- July 2015 (2)
- June 2015 (4)
- May 2015 (4)
- April 2015 (2)
- March 2015 (4)
- February 2015 (2)
- January 2015 (4)
- December 2014 (2)
- November 2014 (4)
- October 2014 (8)
- September 2014 (3)
- August 2014 (7)
- July 2014 (6)
- June 2014 (7)
- May 2014 (12)
- April 2014 (8)
- March 2014 (2)
- February 2014 (1)
- August 2012 (1)
Monthly Archives: April 2016
Links to VBA Functions
Allen Browne Functions Index Technet list of functions
Posted in All, MS Access, VBA Code MS Access
Comments Off on Links to VBA Functions
What’s the difference between Sub Routines and Functions
I was curious Sub Routines and Functions appear to perform almost the same thing what is the difference and what are their relative advantages? Functions return a value that is stored whereas subs don’t. The main difference is not only … Continue reading
Posted in All, MS Access, VBA Code MS Access
Comments Off on What’s the difference between Sub Routines and Functions
Typical While Loop VBA
Function TypicalWhileLoop() ‘This performs the same as next loop but uses the while loop Dim LCounter As Integer LCounter = 1 While LCounter < 10 MsgBox (LCounter) LCounter = LCounter + 1 Wend End Function
Posted in All, MS Access, VBA Code MS Access
Comments Off on Typical While Loop VBA
Typical For Next Loop
Function TypicalForNextExample() ‘This performs the same as the while loop but uses for next Dim i As Integer For i = 1 To 9 MsgBox (i) Next i End Function
Posted in All, MS Access, VBA Code MS Access
Comments Off on Typical For Next Loop
Typical DAO.Recordset VBA for looping through and altering
Function TypicalDAOrecordset() ‘Make sure the name of the recordset is unambiguous ‘Good practice to reference the actual library Dim rs As DAO.Recordset Dim db As DAO.Database Set db = CurrentDb Set rs = db.OpenRecordset(“SELECT * FROM T001Main where T001Main.ValueNumber = … Continue reading
Posted in All, MS Access, VBA Code MS Access
Comments Off on Typical DAO.Recordset VBA for looping through and altering
VBS – Pieces of code
Shutdown computer Option Explicit Dim oShell Set oShell = Wscript.CreateObject(“Wscript.Shell”) oShell.Run “SHUTDOWN -T 60 -S” ‘wait 60 seconds before shutting down Trigger speech Option Explicit Dim speechobject set speechobject=createobject(“sapi.spvoice”) speechobject.speak “Your system is setup and ready for your day” Delay … Continue reading
Posted in All, Configuration, VBS Scripts
Comments Off on VBS – Pieces of code
MS Access VBA Function – Count Numbers of Records in Tables and list.
Not quite finished yet but place here for later correction. Public Function CountAllTablesRows() Dim rs As New ADODB.Recordset Dim rsRC As New ADODB.Recordset Dim strTbName As String Dim lngRowCount As Long Dim tbl As TableDef CurrentProject.Connection.Execute “Delete from TABLE_INFO” rs.Open … Continue reading
Posted in All, MS Access, VBA Code MS Access
Comments Off on MS Access VBA Function – Count Numbers of Records in Tables and list.