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:00July 29th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Loop to create a table with the number of records specified in a field of another table.

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

By |2017-12-01T23:47:39+00:00July 27th, 2011|Computers, Documentation, Internet Explorer, Microsoft|Comments Off on How do I add, edit or delete favorites in Internet Explorer?

I published my web site, but the changes do not show?

========= QUESTION --------- I uploaded my site to the server, but the web site is not updated when I view it in the web browser?   ========= ANSWER --------- Your web site files must be uploaded to the /WWWROOT folder of the server. Check the software you used to publish or upload your web site [...]

By |2011-07-23T13:30:45+00:00July 23rd, 2011|anySiteSolutions.com, Web Design, Windows Hosting|Comments Off on I published my web site, but the changes do not show?

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 under Billing on the Client Area page Fill in the amount [...]

By |2019-08-30T15:31:49+00:00July 23rd, 2011|anySiteSolutions.com, Billing|Comments Off on How do I add funds to or pre-pay my account?

Outlook: Shared task list – hide already assigned

========= QUESTION --------- When viewing a list of shared tasks in Microsoft Outlook, how can I make the ones already assigned to or owned by others, not show?   ========= ANSWER --------- When assigning or taking ownership of the task, un-check the "Keep an updated copy of this task on my task list" checkbox just [...]

By |2011-07-20T05:39:06+00:00July 20th, 2011|Documentation, Microsoft, Outlook|Comments Off on Outlook: Shared task list – hide already assigned

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

By |2017-12-01T23:47:39+00:00July 19th, 2011|Computers, Documentation, Exchange, Microsoft, Outlook Web Access|Comments Off on OWA: How do I open additional mailboxes?

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:00July 15th, 2011|Access, Computers, Documentation, Microsoft|Comments Off on Access Error: Microsoft Access can’t open the Zoom box

Access Error: …is not a valid name

========= QUESTION ---------When running  a query in Microsoft Access, I receive the following error in a pop up dialog box with an OK button: 'QUERY NAME HERE' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.    ========= ANSWER --------- This [...]

By |2017-12-01T23:47:39+00:00July 15th, 2011|Access, Computers, Documentation, Microsoft|Comments Off on Access Error: …is not a valid name

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:00July 13th, 2011|Citrix, Computers, Documentation|Comments Off on Citrix / Xen App: Application launch fails in Internet Explorer 9

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:00July 13th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Use VBA to create directories
Go to Top