Blog Archives

Splitting a string using Split function

I made a quick program to separate the first and last name fields. It was able to grab the middle name as well. I had just finished the blog post and I realized that there was a much quicker way

Tagged with:
Posted in Database

Separating first name and last name

I did a quick blurb on how to change data programmatically in Access. This program took a full name (entered into a field called “Alias”) and separated the first and last name and placed them in their respective fields. Here

Tagged with:
Posted in Database

Programmatically changing data in Access

I wanted to pull together some fun test data for a membership database. I did a search for a list of famous people and found this list (copy of it). I took the table below and pasted the names into the

Tagged with:
Posted in Database