"We have been very pleased with the competent, prompt and courteous service they have provided to us."Stu Perlman
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.
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.
"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."
"Thanks to all!! Nice job on the changes. They look good, thanks for your quick response !!"
Tulip Systems, Inc.
"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.
Steve Da Silva
Manager – Customer Support
The Hospital for Sick Children
Toronto Ontario Canada