How to convert a field of a table to UPPER CASE, lower case, Proper case, through program?
How to convert a field of a table to UPPER CASE, lower case, Proper case, through program?
Use UCase(), LCase(), StrConv() functions.
Do you want to actually change the saved data? Run UPDATE action.
Review http://www.databasedev.co.uk/access-...functions.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Do you want to change the case of table field values OR table field names?
For table field names see this link.
Don't advise all one case for naming convention - harder to read. Also advise no spaces nor punctuation/special characters (underscore only exception).
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Use UCase(), LCase(), StrConv() functions.
Do you want to actually change the saved data? Run UPDATE action.
Review http://www.databasedev.co.uk/access-...functions.html
Thanks!!! God Bless You!
Could you suggest some sites where I can find schemas of different projects like Guest House Mngt., Stock Mngt. etc.
For free, generic data models and tutorials and other data management articles see Barry Williams' site.
I have prepared a form, but when I press the form itself moves up & down.How to keep it fixed & only let records move forward & backward? The form properties [Scroll Bar] is (Neither) & [Movable] is (No).For free, generic data models and tutorials and other data management articles see Barry Williams' site.
For free, generic data models and tutorials and other data management articles see Barry Williams' site.
When we open a report in Layout View the conditional formatting doesn't work even after selecting a value in the Report. What is the reason and how to solve it?