Skip to content

PULSE INFOMATICS

Business Automation, Workflow, & Analytics Consulting

  • HOME
  • SERVICES
  • CONTACT
  • ARTICLES
  • Menu

Tag Archives: parameters

MS Access – Passing a Variable and Unknown Number of Parameters to SQL Server

Posted on May 3, 2018May 3, 2018 by Matthew Moran

Summary How to avoid VBA errors with single quotes in a string being passed to a SQL Insert or Update Error. Includes how to passing parameters for an unknown or variable number of variables. Technologies Microsoft Access, SQL Server, ADO Something funny I hadn’t used this in a few years. When I ran across the […]

Continue reading→
Learn how to automate using Visual-basic for Applications

Recent Posts

  • Using Google App Scripts for contract assembly and save as PDF documents
  • How to use Google App Scripts to send HTML emails from Google Sheets with Airtable Data
  • Airtable Reporting Dashboard using Google Apps Script, Google Big Query and Google Data Studio
  • Airtable Database Systems: The Good, The Bad, and the Ugly (really ugly)
  • Excel VBA Google Distance Matrix API and Google Static Map Image API
  • Solving line breaks and other unstructured data when importing CSV files
  • How I check if optional parameters were passed to a c# method
  • Updated: Microsoft Excel VBA and Google Maps to calculate distances and time from multiple locations

Categories

Pulse Infomatics: Software Development, Office Automation, Technology Consulting