Jiangws's Blog

 
 
 
  • About

    夢を叶える為
 
Buffalo NAS external drives & Windows 10 will not connect June 13th, 2020

Control Panel – Programs and Features – Turn Windows features on and off and enabled:
SMB 1.0/CIFS File Sharing Support
Restarted and everything worked.

Add-Remove Programs client method

https://docs.microsoft.com/en-us/windows-server/storage/file-server/troubleshoot/detect-enable-and-disable-smbv1-v2-v3…

Posted in driver || Comments Off on Buffalo NAS external drives & Windows 10 will not connect
Pad single-digit numbers with a zero June 4th, 2020

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

Posted in Access || Comments Off on Pad single-digit numbers with a zero
Strings and Manipulations(VBA) June 4th, 2020

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, …

Posted in Access || Comments Off on Strings and Manipulations(VBA)