========= 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 [...]
========= 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 [...]
========= 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 [...]
========= 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 [...]
========= 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 [...]
========= QUESTION --------- I need to have double quotes (") in a string in VBA, as I am entering WHERE statements in a SQL statement, but every time I have quotes in a string, it errors out. ========= ANSWER --------- Any time you have double quotes ("), simply double them ("") and you will [...]
========= 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 [...]
========= 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
========= QUESTION --------- I have a spreadsheet where I need to have a number in a cell for the calculations being done on that cell, but I want TEXT to actually display in that cell, not the number. For example, I have a spreadsheet showing a per line item cost, and the per line item [...]
========= 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 [...]