Suppose I have a talble like this,  each record has a unique ID. All
"A"s or "B", "C"s should have only x or y or z property attached. I
want to find A, B or C which has more than one properties.
1 A x ...

The function below takes a serial number entered in the "Serach" control and
then seeks that value in the data table called "PCM Interfaces (Main Table)".
If seek does not return EOF then the absolute position is found and then the
form is set to show that record. This function ...

Can anyone let me know why Access insists that conditions in macros
don't seem to support comparitive operaters for checking ranges, and
only support the Between.. And operators? I had a whole set of
conditions where some were checking between a range of numbers (such

I am trying to create a link table from a database over a LAN which contains
approximately 60,000 records.  When I create the link table and view it only
about 19,000 records are showing up in the table.  I tried just importing the
data into a new table but got the same results. ...

I have a field call part number
the part number is entered into a text box on a form
How can i
1. make it compusary that 12 characters are entered

I have a command button that when clicked deletes certain records from
a subform based on an application number being equal. It deletes all
records with the same applciation number as currently shown on the
main form, see code below:

I am having a lot of trouble binding the second column of a combo to the
record source.
If the "boundcolumn" property is set to 2 and I choose from the list, it
doesn't show what I want BUT if I then change the property to 1 and go back

I have Access XP SP3 and Access 2003 SP2 installed on my machine which is
running Windows XP Pro, SP2.  At some point in at least the last 6 months, I
have had problems when selecting objects in a query window.  When the problem
first started, I only had Access XP SP3 installed.  ...

I just installed the streets 06 essentials and want to update the
construction feature.
It tries to connect then it tells me that there is no internet connection.
I have allowed this program to go thru the firewall.

I have been working in a database that I assumed had the primary key [Program
ID] as an Autonumber field.  Turns out the creator of the DB instead put in
some VB code that simulates Autonumber using the DMax function to increment
the primary key by one when someone creates a new ...

I want to creat a query that would look like the following. The only
trouble is I am not able to get the calculated fields to calculate the
values. It gives me #Error
Names | Contribution | Difference | remainder | Payables

My office just updated from 2002 to 2003. We had an add-in for 2002, but now
it won't run for ACCESS 2003.
I went through the add-in manager and can see it (to be added or deleted),
but when I just try to run it, it is not in the first list of add-ins.

Does anyone know what could be wrong here. I am trying to transfer text from
a text delimited file to a table. This is my code which is simply written to
understand what is going on:
Private Sub Command0_Click()

I spotted a number of fields with # in them in our customers database,
so I thought I would remove them by doing a global edit. I tried
finding # and replacing with nothing. Then click replace all. I got an
error message - but that was not all. It was the postcode field. Next

I have a select query that consist alot of tables and fields,that
issue is making the proccess heavier
is it posible to make it faster then its current stage?otherwise i
need to run a make-table query that will build a table but this