========= QUESTION --------- Ever since I upgraded to IE9, my applications will no longer launch from Citrix Xen App in my browser. ========= ANSWER --------- This is due to the increased Security Settings in Internet Explorer v9 You likely lost the Citrix Xen App site being listed in your Trusted Sites dialog during the [...]
========= QUESTION --------- Can I create directories from within my VBA code? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- MkDir "c:TOTNExamples" --------- If Len(Dir("c:TOTNExamples", vbDirectory)) = 0 Then MkDir "c:TOTNExamples"End If ========= APPLIES TO / KEY WORDS --------- VBA Directory Directories md MakeDirectory Make Directory ========= REF --------- http://www.techonthenet.com/access/functions/file/mkdir.php [...]
========= QUESTION --------- When a user adds a web site to their home screen on their iOS device (iPhone, iPod, iPad), how do I make my icon appear on their screen instead of the default icon. =========ANSWER---------Include an image file named apple-touch-icon.png in the root directory of your web site. iOS takes care of [...]
========= QUESTION --------- How do I link in a local database to a Snap Survey hosted on line? ========= ANSWER --------- See REF --------- Summary of stepsStep 1: Setting up the Database Linkage Wizard Step 2: Creating the data link for the SQL database Step 3: Matching records between the survey and the database [...]
========= QUESTION --------- All of a sudden when I am running a query that includes the standard Microsoft Access function Right(), it is erroring out on me with the error: "Undefined function "Right" in expression" ========= ANSWER --------- Apparently functions like this can go missing from time to time for varying reasons. To get [...]
========= QUESTION --------- Can you copy over the directory structure from one folder to another without copying the files in those directories? ========= ANSWER --------- Use XCOPY from the Command Prompt using the /t and /e switches to include empty directories and subdirectories. See EXAMPLES ========= EXAMPLES ---------xcopy "Q:PRODDATAReports" "C:UsersmyUserDocumentsSubDirSystemsQReports" /t /e [...]
========= QUESTION --------- We just switched to your hosting services, and we are still seeing our old web site at our past hosting provider, how do we fix this? How do I clear my DNS Cache? How to Flush DNS Cache ========= ANSWER --------- When a site is switched over from one hosting company [...]
========= QUESTION --------- How do I ignore an error for one section of code, but then disable ignoring errors for other sections of code? ========= ANSWER --------- See EXAMPLES ========= EXAMPLES --------- To ignore errors: On Error Resume Next To turn off ignoring errors: On Error GoTo 0 ========= APPLIES TO / [...]
========= QUESTION --------- Every time I open an Access Database from the network using Access 2010, I can't work in it until I click the [Enable Content] button. Is there a setting somewhere I can change to avoid this? ========= ANSWER --------- Access 2010Select File, Options Select Trust Center, Trust Center Settings… --Macro Settings: [...]
========= QUESTION --------- I need to change the color of an object from within my VBA code. ========= ANSWER --------- See EXAMPLES ========= EXAMPLES --------- Private Sub ReLinkTables_Click() Me.ReLinkTables.BackColor = RGB(186, 20, 25) Me.ReLinkTables.ForeColor = Hex(FFF200) Me.CurrentStatusLabel.Caption = "Clicked: ReLink Tables" Me.CurrentStatusLabel.BackColor = Me.CurrentStatusLabel.ForeColor = vbWhite Me.CurrentStatus = _ "Opening Linked Table Manager" & [...]