========= QUESTION --------- I have a database that I use on a regular basis, and when I am finished working with that database, I invariably always move on to the same second database file. Is there a way for me to open another file using a button or sub within VBA? ========= ANSWER --------- [...]
========= QUESTION --------- I just got a new Blackberry phone, how do I perform the Enterprise Activation to get my corporate email account, contacts and calendar synced to my new phone? ========= ANSWER --------- OS 6 Options, Advanced Options, Enterprise ActivationEnter your full email address (You@Domain.com)Enter the activation password provided to you by the [...]
========= QUESTION --------- Is there a Trunc or Truncate function in Microsoft Access, like there is in Microsoft Excel? ========= ANSWER --------- No - but you can write your own very easily!In Microsoft Access, create a new Module, and enter the following code: Function Trunc(vNum As Double, vDec As Integer) As Double Trunc = [...]
========= QUESTION --------- When I run a query in Access, or have large number in Excel, what does it mean when it is a large number with an E-02, or E+02 at the end? Or for that matter, E+/-any number? ========= ANSWER --------- This is Exponential Notation (also known as Scientific Notation or Standard [...]
========= QUESTION --------- When I write a regular query in Microsoft Access against a table in an Oracle Database, and then convert it to a SQL Pass-Through query, it will not run, and shows errors like the following: --- ODBC--call failed. [Oracle][ODBC][Ora]ORA-00903: invalid table name (#903) OK Help--- --- ODBC--call failed. [Oracle][ODBC][Ora]ORA-00396: missing expression(#936) OK [...]
========= QUESTION --------- When trying to run an Access Sync operation, I get the following error: --- Microsoft Visual Basic Run-time error '-2147023080 (80070718)': Method 'CopyFile' of object 'IFileSystem3' failed [Continue] [End] [Debug] [Help]--- ========= ANSWER --------- Believe it or not the best we have found on this error has to do with disk [...]
========= QUESTION --------- I would like to write some notes, or documentation on an email I received from someone else that is in my inbox, or a folder in my Personal Folders. ========= ANSWER --------- Double-click, or open the email From the Actions section of the Message ribbon or tab, select Edit Message (Keyboard [...]
========= QUESTION --------- I keep getting messages that my mailbox is full and mail is getting sent back to sender. How can I adjust the Mailbox Size Limit for my or other user's email accounts? ========= 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 [...]
========= QUESTION --------- When synchronizing in Microsoft Access, I get the following error: ERROR: -2147467259 - File sharing lock count exceeded. Increase MaxLocksPerFile registry Entry. ========= ANSWER --------- Adjust the registry entry MaxLocksPerFile to increase the maximum number - see: http://support.microsoft.com/kb/815281 (Method 1) Start button, Run Type: RegEditClick OK--- For Access 2000, Access 2002, [...]
========= 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 [...]