Summary Some visual-basic for applications code to extract all the formulas from every sheet in an Excel Workbook and save them in a text file. Background Avoiding a long explanation, we’ve been writing a reporting tool that combines a Microsoft Access front-end to a SQL Server database. It generates and updates some Excel reports/data visualizations […]
Continue readingSharing Microsoft Excel Data Using SQL Server or Microsoft Access
Summary Demonstrate how data can be cleaned up and shared across multiple users while allowing reports and visualization in well-known and common tools. Technologies Microsoft SQL Server (Express) Microsoft Access & The Access Runtime Microsoft Excel Add-on: Microsoft Power BI The need Provide a data aggregation and cleanup tool with customized and shared Excel reports. […]
Continue readingListing Excel Workbooks and Sheets from Microsoft Access using VBA
SUMMARY: Tutorial to show how to use Microsoft Access VBA to retrieve and display open Workbooks and their Worksheets. I create a lot of dashboards, reporting systems, and document automation projects built extensively using Visual-Basic for Applications. Often, the infrastructure looks like: Microsoft Access as a front-end application. SQL Server as the back-end data repository. […]
Continue readingBusiness Automation
Workflow automation solutions. Document assembly (contracts, reports, proposal systems, letters, emails) – all driven by your data. We’ve built solutions for insurance, legal, manufacturing, and entertainment.
Continue readingDatabase & Application Development
We build custom applications and databases. Mobile, Web, and Desktop. Providing solutions that connect your team, your customers, your partners, and more to your business.
Continue readingData Analytics and Digital Dashboards
Your data means something. We help it speak to you. Better business intelligence, decision support, exception reporting, and visibility to the challenges, and more importantly, the opportunities your data is telling you about.
Continue readingUsing SQL Server Express for Your Microsoft Access Projects
Summary: Some of the reasons why you should use SQL Server (or SQL Server Express) to store data for your Microsoft Access projects. Plus, code to simplify connecting to SQL Server and attaching tables without manual linking. The Access DB is miserable but awesome! Can we be honest. It’s slow, clumsy to move around, inherently […]
Continue readingMS Access – Passing a Variable and Unknown Number of Parameters to SQL Server
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 readingHow to Create a Default Website Image for Facebook Sharing Using Google Drawings
Whew!!! Long title. I published a simple tutorial on how to create the image below with the text overlay and semi-transparent background. Google Drawings is a FREE app that comes as part of your Gmail address or with your GSuite subscription. Benefits FREE! Cloud-based: any computer, any location, no software to install Allows collaboration: Team […]
Continue readingUsing Excel VBA to Automate SQL Server Data Migration
Data Migration Sucess Some simple concepts to help you with more successful conversion and migration projects. Front-load the Automation Automation requires more work at the start – on the front-end of a project. Create simple data connection and output tools immediately. Doing so will give your team the confidence to defer to the automation tool […]
Continue readingNew Prospecting and Sales Call Software – Hyper Call Q
Los Angeles, CA – Pulse Infomatics Streamlines the Sales Call and Prospecting Process Pulse Infomatics is preparing to release it’s flagship Sales Prospecting and Call Center software, Hyper Call Q, for limited custom release in January 2017. Hyper Call Q provides a simplified, single-screen and push-button actions, for almost all call resolutions. Additionally, sales reps […]
Continue readingEmbedding Google Forms on WordPress
If you run a wordpress site and want to include simple poll questions or other specialized input forms on your pages or blog posts, consider the Google Forms plug-in from Mike Walsh. I’ve used it for years and it combines the power of Google Forms with WordPress. In your WordPress console, add & activate the […]
Continue readingExcel Automation for Data Analysts
Should you learn VBA? Note: A very simple sample file and code can be downloaded just above the video. A lot of “real” programmers dismiss VBA and Visual-basic in general. This is short-sighted for a number of reasons. Building solutions should be about effective solutions, not a myopic focus on the “most powerful tool.” When […]
Continue readingWhat is server virtualization and why do you care?
Let’s start with the, “Why do you care?” question. Short answer: You don’t! You’re a business owner or manager, not a computer tech/system engineer. But… you might care, if you knew a little bit about it. And by that I mean, knowing what it is and more importantly, how it benefits the business using it. […]
Continue readingHow to migrate SQL Server instances with permissions to a new server
We recently virtualized a client’s server environment. We’ll write more about virtualization, general concepts, at a later date. As part of that, we had to migrate 3 SQL Server instances to a new server. This was made significantly simpler with a Powershell Script. DBATools – Powershell Scripts to Migrate SQL Instances Download and install the […]
Continue readingProject and Collaboration Tools rundown – G Suite, Asana, Glip, Slack, and more
A friend and business coach, Bill Hart, asked the following question on Facebook: “Q: how do you manage your calendar, tasks and projects?“ In the future I’ll write a bit more about how your responses to online questions or emails you send can be turned into content for your social media. This is one of […]
Continue reading