========= 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 [...]
========= 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: http://www.anysitesupport.com/error-microsoft-access-has-stopped-working/) The scary thing is even when I attempt to open the backups, they may work, but the code still disappears! Is there a [...]
========= 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 [...]
========= 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 [...]
========= QUESTION --------- When attempting to ADD or EDIT an ODBC connection from the ODBC Data Source Administrator in Windows, I receive the following error: Microsoft ODBC Administrator The setup routines for the X ODBC Driver could not be loaded due to system error code 126: The specified module could not be found. (C:......dll). [...]
========= 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 [...]
========= 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 --------- 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 [...]