• Skip to main content
  • Skip to header right navigation
  • Skip to site footer
Foster Solutions (FSI)

Foster Solutions (FSI)

The Solution is in the Process

  • Home
  • What We Do
    • Websites / Hosting
      • Author’s Sites
      • Boutique Websites
      • Corporate Websites
      • Open Source CMS
      • Quick and Dirty Websites
    • SQL Databases / VBA Automation
    • GIS / Market Research
    • Government/Planning
  • Case Studies
    • Databases/Automation Case Studies
    • GIS/Market Research Case Studies
    • Local Government Case Studies
    • FSI – crosspollination – examples
  • Clients
  • Articles
  • Contact Us

MS Access

You are here: Home / Archives for Articles / MS Access

Create TXT settings file for VBA apps

June 21, 2014 by doug

It’s very useful and easy to use a text file as a settings file for VBA applications. The below code is a function that will open a file called adm_settings.txt in the directory of the application file and loop through it to see if it can find the passed setting.  If it does, it will …

Read moreCreate TXT settings file for VBA apps

MS Access Form Error when editing SQL Server tables

May 5, 2013 by doug

I have found a frustrating write conflict error while building MS Access forms with linked SQL Server tables. There are issues with not having a Timestamp (RowVersion) field, but I finally stumbled across the culprit that was affected several forms.  If there is a bit field with null values, you can’t edit the record.  You …

Read moreMS Access Form Error when editing SQL Server tables

Sidebar

Subjects

  • Business Intelligence (2)
  • CSS (4)
  • drupal (2)
  • ecommerce (2)
  • Excel/VBA (9)
  • Exographics (2)
  • GIS (2)
  • Internet (4)
  • Javascript (3)
  • MS Access (2)
  • MySQL (1)
  • PHP (2)
  • PowerPoint/VBA (4)
  • Pyxis (2)
  • SEO/Marketing (4)
  • SPLUNK (1)
  • SQL (7)
  • Stats/Software (3)
  • Technology/Analytics (1)
  • Web Design (5)
  • Web Development (7)
  • WordPress (26)

Ready to get started?

Client Survey

Please take this survey if you are interested in a new or modified website. We will assess and get back with you as soon as possible.

Finding Solutions

We work with you to make things faster, easier and better.

Sites

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Features

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Support

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Copyright © 2021 · Foster Solutions (FSI) · All Rights Reserved

Back to top