Very simple, uses the VBA function StrReverse to reverse the input string. ‘A function to reverse a string provided as input‘For example, the string “abcd” will become “dcba”‘Uses the VBA function StrReversePublic Function ReverseString(sInputString As String) As StringOn Error GoTo ReverseString_Error ReverseString = StrReverse(sInputString) Exit Function ReverseString_Error: ReverseString = “#ERROR#”End Function
Continue readingOh, man, I can’t tell how useful that concatenate function is. One repetitive use I found is to create OR/AND conditions for Access queries. I copy and paste the field values of a column from Access, do some filtering and my conditions are ready. Then I use this concat2 function to create a string to […]
Continue readingRecently, I had the need of printing the data structures of many dbf files. A google search reveled the DBF.COM file that would output dbf file structures, number of records, file name, date of last update, etc. Download this file here: files/DBF.COM (Caution: I downloaded this file from the internet, and I do not make […]
Continue readingWeka, an open source data mining software, uses arff input data format. You can use this code to convert any Access table to arff format. Download the Access database with code: Convert2Arff.mdb This can very well be designed using forms, but this should get one started. Use Alt + F11 to see the code, then […]
Continue readingIf you want to export Access tables using ODBC/DSN connections, use the following code. This procedure uses the File DSN and ODBC connection to export Access tables using DAO object TableDef. Sub ExportTbls() Dim sTblNm As String Dim sTypExprt As String Dim sCnxnStr As String, vStTime As Variant Dim db As Database, tbldef As DAO.TableDef […]
Continue reading