========= 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 --------- 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 [...]
========= QUESTION --------- I need to add a new favorite in Internet Explorer. I need to edit a favorite in Internet Explorer. I need to delete a favorite in Internet Explorer. ========= ANSWER --------- Internet Explorer v8 --- Adding a Favorite Open Internet Explorer Browse to the web site you wish to add to [...]
========= QUESTION --------- When viewing a list of shared tasks in Microsoft Outlook, how can I make the ones already assigned to or owned by others, not show? ========= ANSWER --------- When assigning or taking ownership of the task, un-check the "Keep an updated copy of this task on my task list" checkbox just [...]
========= QUESTION --------- When I am logged in to Outlook Web Access, is there a way to access other mailboxes or inboxes like I do when using my Outlook desktop software? ========= ANSWER --------- Click your name in the upper right corner of the Outlook Web Access window Type the name of the mailbox [...]