"We have been very pleased with the competent, prompt and courteous service they have provided to us."Stu Perlman
You may run across 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, but this approach uses a little VBA code to create a translation sequence based on the abbreviation.
Below we have 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 below function.
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 that you wish. If you lack the time to integrate this database into your system, please Contact Us and we'll be glad to help. If you like the basics of what you see, but need enhancements to make the system functional for you, please Contact Us and we'll develop a quote for you to implement the additional features and enhancements that you need.
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.