Customize Not In List error message
How do I programmatically add an item to a combo box that wasn't originally in the list? When my users type in a value that is not in my combo box list, they get an error. Instead, I want a message to ask the user if they want their desired item added to the list. How do I do this?

---

Replace system error message with a custom message
In Access 2003/XP/2000/97, I have a form that is linked to an Oracle table. When I enter duplicate data, I receive an error message "ODBC - failed... Unique Constraint violated...".

---

I get the error message "Could not delete from the specified tables"
When you run a delete query (delete query: A query (SQL statement) that removes rows matching the criteria that you specify from one or more tables.), Microsoft Office Access 2007 may display the error message Could not delete from the specified tables. This article lists cases in which you can use a delete query, explains why the error message appears, and provides steps for correcting the error.

---

Create a list of choices by using a list box or combo box
When entering data on forms, it is often quicker and easier to select a value from a list than to remember a value to type. A list of choices also helps ensure that the value that's entered in a field is appropriate. A list control can connect to existing data, or it can display fixed values that you enter when you create the control. This article describes the list controls that are available in Microsoft Office Access 2007, and shows you how to create and customize them. What do you want to do? * Learn about the types of list controls * Create a list box or a combo box by using a wizard * Create a list box or a combo box by adding a Lookup field to a form * Create a list box or a combo box without using a wizard * Edit a value list while a form is open in Form view * Customize a list box or a combo box

---

ActiveX component can't create object
When you use Microsoft Access, you receive the following error message: ActiveX component can't create object This article describes some common causes for this error message and offers methods that you can use to resolve the issue.

---

Run-time error on form
I have set up a database for monitoring users of our financial system. with the user ID being numeric, and everything has worked fine. Recently the administrators of the database have asked me to alter the database to accept alphanumeric ID's. After changing the data type to text, certain of my forms that use a filter are producing the following error message. "Run-time error '2501' The ApplyFilter action was cancelled. You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box." I know that the error message is due to the change in data types, because when I delete the alphanumeric data and change the type back, the forms work again.

---

Problem opening access form
I am getting an error message that says "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again". I have shut everything down and still the error occurs.

---

MsgBox Macro Action
You can use the MsgBox action to display a message box containing a warning or an informational message. For example, you can use the MsgBox action with validation macros. When a control or record fails a validation condition in the macro, a message box can display an error message and provide instructions about the kind of data that should be entered.

---

How to get table names from ms access(mdb file) by using odbc library.
I am writing a c++ program get the data from mdb file using odbc library. By the way, I couldn't get table list from mdb file. I already wrote a lot of part of this program so i don't want to switch database library. And the query gives "no read permission on 'MSysObjects' " error message. If you know how to get the table list from a mdb file by using odbc library, please share your experience.

---

Security: Turn off the Message Bar and run code safely
Learn how to turn off the Message Bar and its security warnings. This course explains how to turn off the Message Bar by "trusting" digital certificates or creating trusted locations. After completing this course you will be able to: 1)Add a digital certificate to your list of trusted publishers. 2)Remove a digital certificate from your list of trusted publishers. 3)Create a trusted location. 4)Run files that contain unsigned code in a trusted location.

---

Customize driver settings
Customize text driver settings, Customize Microsoft Excel driver settings, Customize dBASE driver settings, Customize Paradox driver settings, Customize Lotus driver settings, Customize Microsoft Exchange driver settings, Customize ODBC driver settings, Customize HTML driver settings.

---

Database variable not defined error
I'm running an Access 2003/XP/2000/97 database with some VBA code in it. Within the VBA code, a database object is declared as follows: (Dim db As Database) When this code is encountered, Access highlights the line and I receive the following error message: (Compile error: User-defined type not defined) I've seen this code work in other Access databases. How come it does not work in mine?

---

Preventing Duplicates from being entered
There will always be situations where you need to ensure that you do not have duplicates entered into your Microsoft Access database. Ideally you will want to validate data at the lowest level possible, so if you can enforce the rules at the table level (using Primary Keys), that's great. However, while you can customize a field validation message at the table level, it's not so simple for index violations. One possible approach is to check for the problem in a Microsoft Access form when the user is entering data, either in the Form Error event, or in the Before Update event of the controls.

---

When I go to open .mdb it gives and error then installs
I have Office XP installed and all apps within it work just fine when I open them except Access. When I try to open Access with a shortcut on my desktop, I get and error that says "Windows cannot find the file...". Behind that message, another opens that says "Preparing to Install... please wait while Windows configures Office XP Professional" If I go to the folder called C:Program FilesMicrosoft OfficeOffice10 and click on the MSACCESS.EXE file itself, there is no error, but it does the install part. Word and Excel start perfectly without this issue. I tried using the cd to repair the installation, but this had no effect.

---

Operation must use an updateable query
I receive the following error message when trying to save changes i made to database: microsoft ole db provider for odbc drivers error '80004005' [microsoft][odbc microsoft access driver] operation must use an updateable query. /tablename_edit.asp, line xxx

---

Access 2007 Error - when I try to import a text file
I am having some issues with Access 2007. When I try to import a text file into a table using a predefined spec, the routine will run for a while and then error out with the message "the search key was not found in an record". Any ideas on what this is and how I can fix it??

---

Can't Access Table in MS Query
I received the following error message when trying to create a new database query in Excel 2003: Can't access table C:Documents and Settings…My DocumentsTester.mdb.qryTest. I found a few knowledge base articles, but nothing relevant to my situation. I almost never use the wizard to create external data queries, but I thought I'd give it a shot. Using the wizard, I get this error: Undefined function 'Nz' in expression.

---

Error message: Microsoft Access couldn't print your object
This article applies to a Microsoft Access database (.accdb and .mdb) and to a Microsoft Access project (.adp). This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you try to preview or print a report in Microsoft Access, you receive the following error message: Microsoft Access couldn't print your object. Make sure that the specified printer is available.

---

You receive an error when you try to create a new report in Access 2000 without a default printer
When you try to create a new report, you may receive one of the following error messages. You may receive the following error message if you use the wizard to create a new report: You must install a printer before you can create a report. To install a printer, point to Settings on the Windows Start menu, click Printers, and then double-click Add Printer. Follow the instructions in the Add Printer wizard. Click OK in this dialog after you have done this, and the report wizard will continue.

---

Error Trapping
You can use the On Error GoTo statement to trap errors and direct procedure flow to the location of error-handling statements within a procedure.

---

Elements of Run-Time Error Handling
When you're programming an application, you need to consider what happens when an error occurs. An error can occur in your application for one of two of reasons. First, some condition at the time the application is running makes otherwise valid code fail. For example, if your code attempts to open a table that the user has deleted, an error occurs. Second, your code may contain improper logic that prevents it from doing what you intended. For example, an error occurs if your code attempts to divide a value by zero.

---

Set options and send objects in electronic mail from Access
Learn: Add a digital signature to an outgoing message, Add a digital signature to all outgoing messages, Have replies to your message sent to another user, Manually check names before sending a message, Choose which e-mail account to use to send a message, Send a database object's output as an attachment to an e-mail message, Send a data access page as the body of an e-mail message.

---

Troubleshoot importing and linking
The Get External Data command is disabled. I get an error message saying the wizard is not installed or is disabled. I started the wizard, but it disappeared. What do I do? I don't see Microsoft Excel listed in the Files of Type box. I get an error saying Access cannot import data from my file. The option to append data to an existing table is disabled when importing a spreadsheet. I am importing data from a spreadsheet, but I cannot specify field options for any field other than the first.I get errors when I import or link to a spreadsheet or text file, or the data doesn't get imported (or linked to) properly. Importing a text file is taking a long time. I get errors when I append data to a spreadsheet or text file. Some field values appear truncated in a linked table. I get the Numeric field overflow message when I query a linked table. I can't open or update a linked Microsoft Visual FoxPro or dBASE table. I can't open or update a linked Paradox table. I can't open or update a linked SQL table. I get a key violation message. I imported a file and Access says it created a Tablename$_ImportErrors table. I'm trying to import or link data from my security-enabled database. File extensions don't show up beside the file names in the Files Of Type dialog box. I get an "ODBC - connection to datasourcename failed" message when I open a table or form in a converted database.

---

Add, remove, or change error bars in PivotChart view
Error bars graphically express potential error amounts relative to each data marker in a data series. You can add one set of error bars per series.

---

Show or hide the Message Bar
The Message Bar displays security alerts, workflow tasks, server document information, and policy messages. In such cases, the Message Bar appears by default to provide you with this important information. You can hide the Message Bar and then view it later.

---

Enable users to find a record by selecting a value from a list
When you design a form in Access, you can create a list box (list box: A control that provides a list of choices. A list box consists of a list and an optional label.) or a combo box (combo box: A control used on a form that provides the combined functionality of a list box and a text box. You can type a value in a combo box, or you can click the control to display a list and then select an item from that list.) that can be used to find a record when a value is selected from the list. This makes it easier for users to quickly find existing records without having to type a value into the Find dialog box.

---

Resend a data collection message
If you want to send an existing Data Collection e-mail message to additional users, or if the original message didn't reach some users, you must send the message again.

---

Customize the list of recently used files
Many Microsoft Office programs display the last few files you opened in that program. You can use the links on this list to quickly access files. This feature is turned on by default, but you can turn it off, turn it back on, or adjust the number of files that it displays. If this feature was turned off and you subsequently turn it back on, only the files that you open and save after you turn it on are listed. If you close a file, and then move it to another location, such as by using Windows Explorer, the link to that file in the program in which you created it no longer works. You must use the Open dialog box to browse to the file to open it. After you save the file in its new location, that link is added to the list.

---

The Message Box
A message box is a Windows(operating system)-created form used to display some information to the user. As opposed to a regular form, the user cannot type anything on the box. There are usually two ways you can use a message box: you can simply display a message to, or request an answer from, the user.

---

Resolving report errors
How do I avoid #Error in my reports? I want to use Sum([InvoiceAmt]). InvoiceAmt is a number field. However, in some cases there is no data and the Sum function does not work. The report prints a #Error and the total is "#Error". How can I get around this?

---

Avoid #Error in form/report with no records
Calculated expressions show #Error when a form or report has no records. This sort-of makes sense: if the controls don't exist, you cannot sum them. How to suppress the #Error that Microsoft Access displays in forms and reports that have no records.

---

Enable or disable security alerts on the Message Bar
The Message Bar displays security alerts when there is potentially unsafe, active content in the document you open. For example, the document might contain an unsigned macro or a signed macro with an invalid signature. In such cases, the Message Bar appears by default to alert you about the problem. If you don't want to be alerted, you can disable the Message Bar.

---

Avoiding divide by zero errors in Access
If you try to divide a number by zero in Access, you receive a #DIV/0 error if you are in a form or report, or a #ERROR error if you are in a query. To avoid a divide by zero error, you can use the IIF function to set the results field to a zero-length string ("") if the divisor in a calculation is zero. You can then search the field for any values that contain a zero-length string and flag the results. The following steps demonstrate this technique by creating a table and a bound form, inserting three text boxes, and entering an expression.

---

Handle Run-Time Errors in VBA
When you are programming an application, you need to consider what happens when an error occurs. An error can occur in your application for one of two of reasons. First, some condition at the time the application is running makes otherwise valid code fail. For example, if your code attempts to open a table that the user has deleted, an error occurs. Second, your code may contain improper logic that prevents it from doing what you intended. For example, an error occurs if your code attempts to divide a value by zero. Learn how to trap run-time errors.

---

How to fix a Compile error in query expression Error
In Access 2003/XP/2000/97, I tried using the Left function in a query and I get the following error: ("Compile error.in query expression") I've seen this function work in other Access databases. How come it does not work in mine?

---

Combo boxes, list boxes, and other controls
Learn to add controls to your Microsoft Access forms or reports. Customize controls, assign data values and links, and apply data-driven conditional formatting.

---

Automatically correct spelling and insert text and symbols by using words in a list
You can use the AutoCorrect feature to correct typos and misspelled words, as well as to insert symbols and other pieces of text. AutoCorrect is set up by default with a list of typical misspellings and symbols, but you can modify the list that AutoCorrect uses. What do you want to do? * Understand the AutoCorrect list * Add a text entry to the AutoCorrect list * Add a text entry to the AutoCorrect list during a spelling check * Change the contents of a text entry in the AutoCorrect list * Rename a text entry in the AutoCorrect list * Use AutoCorrect in InfoPath

---

Syntax error - missing operator
I am trying to compile a code for emailing individuals from my database but come up with a syntax error from ther where statement.

---

Troubleshoot speech recognition
I can't tell if speech recognition is on. My company name isn't recognized when I say it. I tried speech recognition once, and now I can't get rid of the Language bar. I closed the Language bar, and now I can't get it back. Either Dictation or Voice Command mode is on the Language bar. Both Dictation and Voice Command modes are not on the Language bar. I said something, but the computer didn't do anything. I adjusted the microphone, and I can't hear anything when I play back dictated text. I opened another program, and now speech recognition isn't working. Speech recognition isn't working with the Office Assistant. I'm working in another language, and speech isn't working the way I expect it to. When I say "right-click" over a spelling error, the shortcut menu does not have any spelling alternatives. When I say "escape" in Microsoft Word when I'm using the correction alternative list, nothing happens. I see messages on the Language bar. I see a blue box on the screen when I dictate. I see a gray box instead of a blue box on the screen when I dictate. I'm not using speech recognition, but text is appearing in my file or menus are opening. Sometimes when I say a command, it appears in my file. When I create a list, there are two lines after each item instead of just one line. The size of my file is large after I save it. I want to save speech input data in my Word document. When I use the Office Clipboard in Word to cut, copy, and paste dictated text, I can't right-click an error and see the corrections alternative list. Text-to-Speech (TTS) doesn't work after I installed speech recognition. I added another keyboard, but it isn't available when I open my program. My microphone won't work in other programs while speech recognition is running.

---

Troubleshoot HTML formatted files
Problems: My server-generated HTML files do not appear as expected when I display them in a Web browser. I can't open a file on the Internet. I want to open an HTML file in Access, but it opens in another Office program. I get an error message when I try to import or link to data on a FTP or HTTP Server.

---