One day it was working fine and then hte next day my database won't work and
keeps coming up with the error message:
"ID is not an index in this table"
Unfortunatley it does not say which table or what the error is. Has anyone

I would like to bind a disconnected ADODB (v2.7) recordset to a listbox's
recordset property.  For some reason, the values aren't being displayed.
here's the form's coding:
...

Hi, I have two combo boxes and two text boxes on a form. When the form loads,
the first combo box gets pre-filled with the column values. The user selects
a particular value on the first combo box and adds comments in a particular
text box.

I have a main form (frmGetCustomer) that opens another form (frmCustomer) to
a specific record.  I am using acDialog because I want the code to pause
because the next line is a requery for the main form.  So if there is any
changes the main form will be updated.  However, when I ...

I need to transfer records from a utility database to temp tables in the
frontend of a  frontend/backend system.  Later, these are appended or
updated into the backend database.
My question is whether it is more efficient to empty the temp tables via

I have a subform of a form which view is continuous - it shows many records
at once. I tried to use an editbox which should be somehow filled with a
text from a query. I created a query
SELECT [Medicines].[ID_MEDICINE], [Medicines].[MedicineName],

Considering some of the more advanced coding I've done, I should be
able to know how to do this but I don't.
I have a form that allocates payments to invoices.  I need to find the
first record where Paid=No (yes/no field) and then do something with

I have a field that contains strings of characters.  Some of the are
unprintable, and show up as boxes.  I know they are not char 10 or 13.  What
VBA code do I use to find out what they are?

I am having trouble with FileSearch:
With Application.FileSearch
   For i = 1 To .SearchFolders.Count
       .SearchFolders.Remove i

I need the user to be able to select the printer for 2 different reports.  I
have seen the printer programs that others have made, but I can't change
system information because of another program that uses the default printer.
Option A: I would like to have a form that shows only ...

I have a text box on a continuous form which displays a
concatenation of string values from three separate fields.
(i.e. Title, initials and surname)
If I scroll up or down, using the scroll bar, then the calculated

I'm trying to perform, or simulate, the changing of certain control
properties with Conditional Formatting that aren't available in the
Conditional Formatting dialog box.
I want to change the Visible or BackStyle property of a control in a

I have a data input form and need to automatically duplicate the existing
record as a new record in a new table (Annonce_OUi) by clicking a button.
Many thanks in advance!

I want to fill a combobox with records from a table in another database (the
table is not active (nor local or linked) in this front-end database)
I can open the database and get the recordset, but I don't know how to bind
the combobox to the recordset.

I am using Access 2003. When I use Dim db as Database,  I get a Compile Error
message telling me that the data type is not defined. How do I get around
this problem?
I am trying to open a recordset and I am using the following code: