========= QUESTION --------- When attempting to execute a DataMart in MicroStrategy, it fails with the following error: --- The following History List delivery was not successful. Delivery/update and destination information: Run at: <DATE> <TIME> Error message: (QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:972: on HSTMT] [MicroStrategy][ODBC Oracle [...]
========= QUESTION --------- I have switched web site development firms so many times now we have no idea what our Google Analytics account information is. Is it possible to retrieve your Google Analytics account info if you have no idea what your logon id is? ========= ANSWER --------- Take a look at your web.config [...]
========= QUESTION --------- What registrar, hosting company, or data center is responsible for these white label Name Servers and Domain Names? ========= ANSWER --------- 2GetItDone.net = BlueHost.com DomainControl.com = GoDaddy.com EmailSrvr.com (webmail.emailsrvr.com, pop.emailsrvr.com, imap.emailsrvr.com, SMTP.emailsrvr.com) = Rackspace FTPToYourSite.com = Rackspace HostedResource.com = GoDaddy (generally used for their mysql database servers and things of that [...]
========= QUESTION --------- How do I import an existing bootcamp partition into my VMware Fusion installation on my mac? ========= ANSWER --------- see: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1015088 ========= EXAMPLES --------- ========= APPLIES TO / KEY WORDS --------- VMware Fusion Mac Macintosh ========= REF ---------http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1015088 ---http://www.anysitesupport.com/fusion-import-a-bootcamp-partition/http://anySiteHosting.com
========= QUESTION --------- I want to calculate my own Metrics based on metrics already in my report - similar to what you do with a formula in Excel, or a calculated field or Expression in Microsoft Access. ========= ANSWER --------- This is called a Derived Metric in MSTR terminology. To create this Derived Metric, [...]
========= QUESTION --------- How do I run a DOS command at the Command prompt from VBA? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- Shell "cmd.exe /k dir c:windowssystem*.exe", vbNormalFocus ...consider running a .bat file for more involved commands? ========= APPLIES TO / KEY WORDS --------- Microsoft Access VBA Command Prompt Commands [...]
========= QUESTION --------- Can you execute or run a Saved Export in Microsoft Access from VBA? ========= ANSWER --------- Yes - see EXAMPLES ========= EXAMPLES --------- DoCmd.RunSavedImportExport "NameOfSavedExport" ========= APPLIES TO / KEY WORDS --------- Saved Export Saved Import ========= REF ---------http://bytes.com/topic/access/answers/895859-how-can-i-run-saved-export-vba ---http://www.anysitesupport.com/vba-run-saved-export/ http://anySiteHosting.com
========= QUESTION --------- How do I do a find and replace within a string using VBA? How do I replace a character in a string? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- Sometimes you will stumble across someone having entered a phone number in a database with a "/" between the area [...]
========= QUESTION --------- We need to see if a new domain name we would like to register is available - how can we do that? ========= ANSWER --------- You can always simply email your sales rep @anySiteHosting.com, or support@anySiteHosting.com and we can check into it for you. --------- You can also browse on your [...]
========= QUESTION --------- I am working on a report in Microsoft Access and would like indicate with a down or an up arrow that the report is sorted on a particular column. How do I show a down or up arrow in the text of the column header? ========= ANSWER --------- It is very [...]