VBA: Loop to create a table with the number of records specified in a field of another table.

========= 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 [...]

By | 2017-12-01T23:47:38+00:00 July 29th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments

How do I add, edit or delete favorites in Internet Explorer?

========= QUESTION --------- I need to add a new favorite in Internet Explorer. I need to edit a favorite in Internet Explorer. I need to delete a favorite in Internet Explorer.   ========= ANSWER --------- Internet Explorer v8 --- Adding a Favorite Open Internet Explorer Browse to the web site you wish to add to [...]

How do I add funds to or pre-pay my account?

========= QUESTION --------- I would like to pre-pay on my account, or add funds to my available balance to be used for payment next time I have a bill.   ========= ANSWER --------- Logon to the Client Portal http://www.anysitesupport.com/how-do-i-logon-to-the-client-portal/ Click the Add Funds link below your address/contact information on the Client Area pageFill in the [...]

By | 2017-12-01T23:47:39+00:00 July 23rd, 2011|anySiteSolutions.com, Billing|0 Comments

OWA: How do I open additional mailboxes?

========= QUESTION --------- When I am logged in to Outlook Web Access, is there a way to access other mailboxes or inboxes like I do when using my Outlook desktop software?   ========= ANSWER --------- Click your name in the upper right corner of the Outlook Web Access window Type the name of the mailbox [...]

Access Error: Microsoft Access can’t open the Zoom box

========= QUESTION --------- When I right-click a field cell in a query and select Zoom I get the following error in a pop up dialog box with an OK button: Microsoft Access can't open the Zoom box. The Microsoft Access Utility add-in is missing or was modified. Rerun Microsoft Access or Microsoft Office Setup to [...]

By | 2017-12-01T23:47:39+00:00 July 15th, 2011|Access, Computers, Documentation, Microsoft|0 Comments

Citrix / Xen App: Application launch fails in Internet Explorer 9

========= 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 [...]

By | 2017-12-01T23:47:39+00:00 July 13th, 2011|Citrix, Computers, Documentation|0 Comments

VBA: Use VBA to create directories

========= 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   [...]

By | 2011-07-13T08:50:11+00:00 July 13th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments