Posts Categorized: Access

To simulate these two Excel functions in Access Visual Basic, paste the following code into a new module and save it:

Public Function Ceiling(ByVal X As Double, Optional ByVal Factor As Double = 1) As Double
    ' X is 

VBA has a Format() function that you can use to pad numbers.

animal = “sinani-” & Format$(i, “00”)
This will pad single-digit numbers with a 0. Your two- and three-digit numbers will continue to work as expected.

From:https://stackoverflow.com/questions/31628535/pad-single-digit-numbers-with-a-zero…

Text Functions, Workbook
Before continuing please be aware of the following information available in Excel HELP

FIND(find_text,within_text,start_num)
Worksheet Description VBA
CHAR Returns the character specified by the code number CHR
CLEAN Removes all nonprintable characters from text
Characters 0-31, 129, …

I am using switch statement in access 2007, i want to know how I can specify default value.
select
switch
(
MyCol = 1, ‘Value is One’,
MyCol = 2, ‘Value is Two’
) from MyTable
-

SELECT
Switch(MyTable.[MyCol]=’1′,’Terrestrial’,
MyTable.[MyCol]=’2′,’Value …