Loading...

VBA: Change the Color of an Object

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

By |2011-06-20T08:05:33+00:00June 20th, 2011|Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Change the Color of an Object

Email: Domain size limit exceeded

========= QUESTION --------- Every time I send an email, I get a bounce back message saying "Domain Size Limit Exceeded" how do I fix this?   ========= ANSWER --------- The reason for this is that the email system allows each web site or domain 1000MB of shared disk space for all of the email accounts [...]

By |2011-06-18T19:40:13+00:00June 18th, 2011|anySiteSolutions.com, Email|Comments Off on Email: Domain size limit exceeded

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:00June 18th, 2011|anySiteSolutions.com, Email|Comments Off on Email: Clean up your email folders

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:00June 18th, 2011|anySiteSolutions.com, Email|Comments Off on Email: Folder Auto-Clean rules

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

By |2017-12-01T23:47:41+00:00June 18th, 2011|Advanced Statistics, anySiteSolutions.com, Email|Comments Off on Email: Disk Usage Summary report

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:00June 15th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Access: Calling Linked Table Manager

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:00June 15th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Can you open Windows Explorer from VBA?

VBA: How to put double quotes in a string

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

By |2017-12-01T23:47:41+00:00June 15th, 2011|Access, Documentation, Microsoft, VBA|Comments Off on VBA: How to put double quotes in a string

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:00June 13th, 2011|Access, Computers, Documentation, Microsoft|Comments Off on Access: DLookup

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:00June 12th, 2011|CMS, Documentation, Internet/Web, Web Design|Comments Off on Content Management Systems
Go to Top