I am printing out a report and there are 35 copies of the same thing.  How do
I delete the multiple copies so I can just print one?  I'm not sure how I got
this in the first place but I was trying to copy subreports so this may have
something to do with it.

I have a database that includes a phone number field. I want to prevent a
user from creating a new record that contains a phone number that is
currently in a record that exists in the database.
I am using a form for data entry into the table. Somehow I'd like for there

I did post this earlier too I confess- but no response :( Anyone have
any comment?
I am an newbie user of MS Access 2007. I want to able to send a
specific record by email and update the record autimatically. My db

I would like to know if any one can instruct me on how to slip my file in
two...to be able to place it on a network...i know if i put the file as is in
the network it will slow down it performace drastically...
Any ideas

I have a query that does some calculations.
One particular column is a statement that says something like this:
ColumnE = If (columnA = 'HR', ColumnB * ColumnC / ColumnD)
I have set the format to Standard and decimal place to 4 on this column.

Does Access have the ability to Gererate a Random list of Numbers like Excel
can?  For example I have account numbers in my database and I have to
randomly select several accounts at various times.   Presently I export the
list into Excel and use the Data Alalysis tools to do ...

2003/2007
Have need to import massive 2MM plus record files from MF.
The MF files have headers of more than one line.
I would like a ACCESS macro to delete the first three "rows".

Is there any way to know the date when a field changes?  Like the date
modified when a form changes?  Same thing, only on a field.  I need this date
to be displayed in a table so that I can run queries and reports from it.

Despues de pegar varios botones en un formulario en Access2003 no me deja
abrir el formulario ni en modo de ejecución ni en vistab diseño y me saca el
mensaje:
Memoria insuficiente para realizar esta operación. Cierre los ...

I am working at a corporation where I have multiple clients with their own
instance of the same Access 97 Database.  This same database is also used by
separate companies all over the world.  They use these databases to place and
track their orders.   All the clients access their ...

Hi,
I understand a crosstab query that has parameter function is hard to make a
report.
Here is my way: After runs to query, I use Print Preview and print the out

I seem to be going around in circles with this any help would be gratefully
appreciated
I am trying to format a field on a tabular form based on the unique number
being equal in another table

I assumed when you enter the expression Date()+14 would give you 2 weeks of
information from the current date, but when I entered Date()-14 it gave me
more information than the 1st expression, can anyone explain this to me?

does anyone know how to retrieve records in a query like 2 weeks from the
current date? Example I know i have some authorizations about to expire and I
would like notification before they expire. So what expression could I use to
find the ones that are about to expire? thanks

 How can i detect if the computer is locked through MS Access,I need it
urgently as it's the base on which I'll st up my program.