Restrict a table to a single record

========= QUESTION --------- I use a table called Parms in my database to store application specific parameters.If a user accidentally added a record to this table, instead of simply editing the single record containing the appropriate values, it would cause major issues for the application. Is there a way to restrict a table to contain [...]

By | 2017-12-01T23:47:35+00:00 October 28th, 2011|Access, Computers, Documentation, Microsoft|0 Comments

Can I backup my VBA code?

========= QUESTION --------- I have been having a lot of trouble lately with my Microsoft Access database files being corrupted and losing all of my code. (a sometimes fix for this: The scary thing is even when I attempt to open the backups, they may work, but the code still disappears! Is there a [...]

By | 2017-12-01T23:47:35+00:00 October 26th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments

VBA: String Manipulation

========= QUESTION --------- What are some ways I can manipulate strings within VBA?   ========= ANSWER --------- see EXAMPLES   ========= EXAMPLES --------- Title field has values like: Company Manager, Company Assoc, Company Director, etc...Remove Company: =IIf([Title] is null,"",Replace([Title],"Company ",""))   ========= APPLIES TO / KEY WORDS --------- Microsoft Access String Manipulation Strings VBA   [...]

By | 2011-10-25T10:23:53+00:00 October 25th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments

Error: Microsoft Access has stopped working

========= QUESTION --------- When opening a Microsoft Access database file, Access crashes with a pop up message stating: -------------------------------------------------------------------- Microsoft Access -------------------------------------------------------------------- Microsoft Access has stopped working  Windows is checking for a solution to the problem...  [Cancel] --------------------------------------------------------------------   Finally resulting in the following message: ---------------------------------------------------------------------------------------Microsoft Access ---------------------------------------------------------------------------------------Microsoft Access has stopped working A problem caused the [...]

By | 2017-12-01T23:47:36+00:00 October 19th, 2011|Access, Computers, Documentation, Microsoft|0 Comments

SQL: Insert Statement

========= QUESTION --------- How do I add a record to a table using SQL?   ========= ANSWER --------- see EXAMPLES   ========= EXAMPLES ---------  SQLTxt = "INSERT INTO 0000T_Log (Dt, Log) VALUES (#" & Now() & "#, '" & Me.CurrentStatus & "')"CurrentDb.Execute SQLTxt   ========= APPLIES TO / KEY WORDS --------- Microsoft Access SQL Insert [...]

By | 2017-12-01T23:47:37+00:00 September 2nd, 2011|Access, Computers, Documentation, Microsoft, SQL, VBA|0 Comments

Access: Truncate Function

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

By | 2011-08-16T12:18:02+00:00 August 16th, 2011|Access, Computers, Documentation, Microsoft, VBA|1 Comment

What does E-02 mean in a decimal number?

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

By | 2017-12-01T23:47:38+00:00 August 12th, 2011|Access, Computers, Documentation, Excel, Math, Microsoft|1 Comment

Access: SQL Pass-Through Query against Oracle

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

By | 2017-12-01T23:47:38+00:00 August 9th, 2011|Access, Computers, Documentation, Microsoft, Oracle|0 Comments

Access Error: Method ‘CopyFile’ of object ‘IFileSystem3’ failed

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

By | 2011-08-09T08:23:35+00:00 August 9th, 2011|Access, Computers, Documentation, Microsoft|0 Comments