Welcome to your HiTech Coach-HiTech Coaching for Access Databases and more ...

HiTech Coaching for Access Databases and more ...

Main Menu

Login Menu

Popular Downloads

Report Dialog Examples (284)
(Example Reports)
File Icon

Dynamic Report based on a Crosstab query (250)
(Example Reports)
File Icon

Reminders (228)
(Example Date and Time)
File Icon

Document Links (193)
(Example Forms)
File Icon

recipes template 2000 format (176)
(Templates)
File Icon

Universal Search on many text with details (176)
(Example Forms)
File Icon

Centering a form in the Access window (132)
(Example Forms)

Office 2010 Beta is here

Anyone can download and work with the latest versions of Office 2010 for free in this testing phase.

To download and see a video Click Here

Parsing out City State ZIP

Written by Boyd Trimmell

Here is some sample code to parse out the City State and ZIP form a string.

Example usage:

? GetCity("Some Town, OK 73101")
Some Town
? GetCity("Some Town OK 73101")
Some Town

? GetState("Some Town, OK 73101")
OK
? GetState("Some Town OK 73101")
OK

? GetZIP("Some Town, OK 73101-0000")
73101-0000
? GetZIP("Some Town, OK 73101")
73101

Following is the VBA code for the functions used above:

Displaying specific dates

To display specific dates, you can use the DateSerial() function to manipulate the day, month, and year portions of a date. For example, you can use the following expressions in the ControlSource property of a text box or in the Immediate window to return specific dates:

Main Menu

Login Menu

Popular Downloads

Displaying specific dates

Sponsored Links

Latest News

Popular