I have a address filed which contains data like this - Jacksonville, FL 32205-9351
I like to be able to separate it into city, state and zip fields.
Sometimes this filed contains only the address like - David Lipscomb University (without city, state and zip)
FYI I do not know VB. Is there anything I can do in Access.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…