"We have been very pleased with the competent, prompt and courteous service they have provided to us."

Stu Perlman
Monarch/USESI (New Jersey)

Microsoft Access Sample Code

Function for Converting a Month Name to a Number

Iowa Headquarters
301 Alexander Ave., Suite C
P.O. Box 726
Ames, Iowa 50010
Tel: (515) 239-9900
Fax: (515) 239-9800

Driving Directions to the Ames Iowa Headquarters
Florida Headquarters
4200 Evans Ave., Suite 10
Fort Myers, Florida 33901
Tel: (239) 267-2749
Fax: (239) 267-9936
Caribbean & Latin America
(Puerto Rico)
Tel: (787) 303-0042
South Dakota - Sioux Falls
Tel: (605) 496-9580
Texas - Austin
Tel: (512) 593-1056
New Mexico - Albuquerque
Tel: (505) 289-1364
Want quick Answers?
During normal business hours you can reach us via our live chat program.  Try it, it's really cool!!
Click Here To Chat With Us Now Live!!
Partner Locations
Quad Cities, Iowa
Cedar Rapids, Iowa
Winning Solutions Inc. is an independent service provider for THIRD PARTY PRODUCTS where WSI provides support on remote, chat and over the phone basis for issues related to computer software. All other trademarks, registered trademarks, company names, product names and brand names for the third party trademarks are the property of their respective owners, and WSI disclaims any ownership , right , affiliation or endorsement of or by any such third party. The use of any third party trademarks, logos or brand names is for informational purposes only.
Chat Now

Microsoft Access Sample Code

Function for Converting a Month Name to a Number

You may have experienced a situation in your Access Programming where you receive the month in an alpha format, such as Jan for January (1), Feb for February (2), etc. You may also need to store that field as a numeric value in your database. There are a number of ways to accomplish this task, but this approach only uses a little VBA code to create a translation sequence based on the abbreviation.

Below you can see a function where the month is passed in as an abbreviated text string, and the function returns the numeric value associated with that abbreviation.
To get the full month name (January, February, etc.) from a date-formatted field, you can use the function below.

Download a Demonstration

Are you having problems getting the code to work for you? If so, then try the demo to see how it can meet your needs.

Download a demo version for free to test! The demo version is in Access 2007, which will work with either Access 2007, 2010, 2013 or 2016. If you need a previous version of Access to try, please Contact Us. Please note that the demo version of the software is fully functional but does not allow you to see the code implementation. The full version allows you to design the code implementation and make adjustments for your needs.

Access 2007 Download
Access 2010/2013/2016 Download
Access 2010 64 Bit Download
Access 2013/2016 64 Bit Download

The full version of the database is a standard Access Database file. You will have full access to the database window, all design objects, the visual basic project code, and you will be able to modify or add to the design in any way you wish (this does not apply to the run-time/compiled versions). If you lack the time to integrate this database into your system, please Contact Us and we will be glad to help with your integration process. If you like the basics of what you see in the database, but need enhancements to make the system functional for your business, please Contact Us and we will develop a quote for you to implement the additional features and enhancements that you require.

Purchase Price

$4.99 - this allows you to use this database template however you wish within your organization.

Once your purchase is complete - you will receive an email with a link to download the full version of the database.
If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft Access Development needs. 
Click Here to learn more about the WSI quoting process.


"Once again, you guys have outdone yourself. The service and support you have provided has been the best I've ever experienced from a software development team. You guys have the best Access calendar GUI I've ever seen."
Mike Mattas
New-Tech Systems
Plainfield, IL

"Thanks to all!! Nice job on the changes. They look good, thanks for your quick response !!"
George Ells
Tulip Systems, Inc.
Pittsburgh, PA

"Thanks for all your help. Your service is great as I find you and your team easy to deal with and very responsive in terms of getting the changes done.
Great work."
Steve Da Silva
Manager – Customer Support
The Hospital for Sick Children
Toronto Ontario Canada

On October 5, 2015 I was working on an Access database program, and needed assistance to get it in use quickly. I found Winning Solutions via google/chat now, they contacted me with their programmer Andres Dominicci the next day. With the expertise of Andres the database was put in the store for use just 4 days later. The efficiency of his programming and the added benefit of video to refer back to in case of small adjustments brought what seemed like a daunting task into reality very quickly. You can get quick, efficient, trustworthy help directly into your office regardless of your location. This is utterly amazing. I would not hesitate to recommend this company for specialized projects in your office.

Much thanks to Winning Solutions… Andres you are a winner!

Debbie Hunt
Glendon Bald Eagle Holdings Ltd.
British Columbia, Canada