Email: Clean up your email folders

========= QUESTION --------- I want to keep my email folders cleared out to save disk space - how do i take care of this? --------- I have been receiving Domain Size Limit Exceeded errors and need to clean up my email folders to save disk space.   ========= ANSWER --------- Logon to webmail http://www.anysitesupport.com/how-do-i-logon-to-webmail/ Select [...]

By | 2017-12-01T23:47:41+00:00 June 18th, 2011|anySiteSolutions.com, Email|0 Comments

Email: Folder Auto-Clean rules

========= QUESTION --------- Can I setup rules to automatically delete old emails from my email account folders?   ========= ANSWER --------- Logon to webmail http://www.anysitesupport.com/how-do-i-logon-to-webmail/ Click the Settings button at the top of the screen Double-click the Filtering folder under My Settings on the left Click Folder Auto-Clean under Filtering Under the Options tab on [...]

By | 2017-12-01T23:47:41+00:00 June 18th, 2011|anySiteSolutions.com, Email|0 Comments

Email: Disk Usage Summary report

========= QUESTION --------- I need to see a report showing how much disk space each of my email accounts is using on the webmail or email servers.   ========= ANSWER --------- Logon to webmail with an email account that has been assigned administrator privileges http://www.anysitesupport.com/how-do-i-logon-to-webmail/ If your email account is assigned adminstrator privileges, contact us [...]

VBA: Access: Calling Linked Table Manager

========= QUESTION --------- Can you call or open the Linked Table Manager in Microsoft Access from your VBA code?   ========= ANSWER --------- See EXAMPLES --------- Another interesting way of doing this would be to simply execute a query in your VBA code against each linked table in your database, thereby causing the logon prompt [...]

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

VBA: Can you open Windows Explorer from VBA?

========= QUESTION --------- Can I open Windows Explorer from my VBA code?   ========= ANSWER --------- See EXAMPLES   ========= EXAMPLES --------- Private Sub WindowsExplorer_Click() Dim rst As RecordsetDim retval As String Set rst = CurrentDb.OpenRecordset("Parms")retval = Shell("explorer.exe " & rst!Path, vbNormalFocus)Set rst = NothingEnd Sub   ========= APPLIES TO / KEY WORDS --------- Microsoft [...]

By | 2011-06-15T13:27:19+00:00 June 15th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments

Access: DLookup

========= QUESTION --------- How do I use the value from the field of one table as the criteria in a query against a different table? How do I use the DLookup function?   ========= ANSWER --------- See EXAMPLES   ========= EXAMPLES --------- Number Fields:DLookup("FieldName" , "TableName" , "Criteria = n") Text Fields: DLookup("FieldName" , "TableName" , "Criteria= 'string'") Date [...]

By | 2017-12-01T23:47:41+00:00 June 13th, 2011|Access, Computers, Documentation, Microsoft|0 Comments

Content Management Systems

========= QUESTION --------- What are some Content Management Systems I can use while hosting with anySiteHosting.com?   ========= ANSWER --------- http://WordPress.org http://www.cmsmadesimple.org/ http://drupal.org/ http://www.kentico.com/ http://moodle.org/  http://www.silverstripe.org/ http://DotNetNuke.com http://Joomla.org http://www.xoops.org/  http://www.websitebaker2.org  http://www.concrete5.org/    ========= EXAMPLES ---------   ========= APPLIES TO / KEY WORDS ---------   ========= REF ---------   ---http://www.anysitesupport.com/content-management-systems/ http://anySiteHosting.com

By | 2011-06-12T11:34:39+00:00 June 12th, 2011|CMS, Documentation, Internet/Web, Web Design|0 Comments

Access: Run-time error 13 Type MisMatch

========= QUESTION --------- I converted a Microsoft Access database from .mdb to .accdb format, and now when I run my usual VBA code to export a report to PDF, it gives me the error: Run-time error ‘13’: Type mismatch   ========= ANSWER --------- If you are not using an ADO object library, clear the reference to [...]

By | 2017-12-01T23:47:41+00:00 June 7th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments