I receive daily an Access 2000 table and some of the records need to be
deleted because the record may have two fields with identical value. How can
I do this. Right now I am sorting the records on these fields and then
deleting when I see the identical value on these two fields ...

I am trying to make a chart to use with the 1st column starting with an 8 digit number, and I want the next row down to start with that number, +1 .  i.e.  22046025 and under that still in the same column, 22046026, etc
I remember the old database spreadsheets where you could just ...

Hello to all.
I need to design a database for tracking a supplier's
prices.  I order items from them on an as needed basis
but there are hundreds of them.  Basically I would be

I've just created an empty database and want to import the data from a table
in another database to a similar table in the new one.
Can sks tell me how to do it. (Ive experimented with the 'Get External
Data/Import' option but it just seems to import the whole table).

I have an edit record form and I want to force the user to enter notes in the note field every single time they make a change to any of the other fields.

Hi.  I'm getting this "Microsoft Access can't start
because there's no license for it on this machine", when
trying to start Access 97.
Is there some kind of fix as it is a legit copy with

I am a newbee, so need a little help
I have made a SQL statement which I am trying to run by RunSQL SQL command.
although the NewCA and OldCA field has been defined it asks again to enter the parameter. I guess below syntax is wrong....could somebody please let me know where it is ...

I have an Access 2000 database that is using linked
tables to SQL 2000.  I am trying to get a query to work
where I want to filter a datetime field from SQL Server.  
I have tried putting the # symbols around the date in the

need to delete record having two different fields with same identical value
daily I am given a table (access 2000) where a record may have the same
identical value in two of its fields. I have to delete such a record. Can
anyone help me with this

I'm having a problem with the following code. I'm trying
to create a recordset using a query. I run the query
earlier in the code and it returns multiple records but
when I run it with the following code it doesn't return

I run a query from code but don't want the results
displayed to the user. How do I hide the result table?
I looked under tools/options but couldn't spot anything.
Is there something I put in my code?

Is it possible to close and open forms in vba
from another form that is being used,
my input form is named Collection and the form
I want to close is called Artist and then open a

If I have a table of customers and the prices they are charged for
product depending on the quantity they purchase (such as);
0-10  Items $1.00
11-20 Items $1.25

Running a program that archives files and removes records from the .md
file, however after completion the .mdb file does not decrease in siz
but the records do not display if .mdb file opened in access??
Opened the .mdb file in access and deleted 10,000 records from 30,00

we have access database file on windows network at our business.  when i attempt to open database to add entries i get a "cannot lock file" message.  have uninstalled/reinstalled access program to try to clear problem (no success). have called our tech rep and he can't understand ...