========= QUESTION --------- How can I use VBA to loop through and rename a long list of files in several sub-directories? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- Private Sub RenameFiles_Click() Dim fName As String Dim fName_New Dim myPath As String Dim myCounter As String DoCmd.Hourglass True DoCmd.SetWarnings False Set [...]
========= QUESTION --------- How do I format numbers, dates, etc in my VBA code? ========= ANSWER ---------see EXAMPLES ========= EXAMPLES --------- Format(rs!Store, "0000") Formats a number field that may contain only one digit (i.e. 2) to four digits with leading zeros (i.e. 0002) ---------= Format(Now(), "hh:mm AMPM")If the current time is 5:04:23 in [...]
========= QUESTION --------- How do I disable an individual Outlook Add-In? ========= ANSWER --------- Outlook 2010: File, Options, Add-InsSelect COM Add-Ins from the Manage drop down list at the bottom of the window, and click [Go...]Un-Check the box next to the add-in you wish to disable and click [OK] ========= EXAMPLES --------- see [...]
========= QUESTION --------- How do I add a record to a table using SQL? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- SQLTxt = "INSERT INTO 0000T_Log (Dt, Log) VALUES (#" & Now() & "#, '" & Me.CurrentStatus & "')"CurrentDb.Execute SQLTxt ========= APPLIES TO / KEY WORDS --------- Microsoft Access SQL Insert [...]
========= QUESTION --------- How do I add an icon shortcut to a web site on my iOS (iPad, iPhone, iPod) device? ========= ANSWER --------- On your iPad, visit the web site you would like to add. Tap the action button (box with a curved arrow on it) next to the web address field at [...]
========= QUESTION --------- I have a database that I use on a regular basis, and when I am finished working with that database, I invariably always move on to the same second database file. Is there a way for me to open another file using a button or sub within VBA? ========= ANSWER --------- [...]
========= QUESTION --------- When I am ready to publish a new version of my web site, my web site editing software won't let me specify which folder to upload it to on the server. This means that all my web site content gets uploaded to my FTP Root folder, instead of my /wwwroot folder where [...]
========= QUESTION --------- My web designer is asking me for the information they need to publish my web site. What is it? ========= ANSWER --------- Your web designer is likely looking for FTP access to your web site. FTP access allows you to logon to the file folder system behind your web site and [...]
========= QUESTION --------- Is there a Trunc or Truncate function in Microsoft Access, like there is in Microsoft Excel? ========= ANSWER --------- No - but you can write your own very easily!In Microsoft Access, create a new Module, and enter the following code: Function Trunc(vNum As Double, vDec As Integer) As Double Trunc = [...]
========= QUESTION --------- I have a table with one record per entity, and a field with the number drawing entries they have. How do I take this and create a table with one record for each of those drawing entries? ========= ANSWER --------- Use the code in EXAMPLES below to open each record in [...]