I create a query and when I generate it, it pulls nearly 17,000 records.
After sifting through the records, there are only about 100 files, but is
duplicated 100 times. Is there anything I can do to eliminate the duplication?

Hi John,
You have helped me incredibly in the past and I have been trying to post
generally and working on my own with Access, plus reading books, etc. You
have been so generous with your advice and I didn't want to become a pest,

I am a new Access user and don't use code, just the wizards & design view.  I
am trying to create some large tables that will have multiple fields that
have the same properties (e.g. field size, format, validation rules) and
wanted to know if there was a way of doing this without ...

I want to insert a picture on to a data entry form and on to a report.  When
I resize the picture, it cuts off part of the picture.  Is there any way to
resize the graphic on the form or report  design form.  
Ted

I am able to print all other size labels except for MACO (ML 1450) on my
computer.  I don't see it under the other MACO templates.  Where would I find
it?  It is 1 1/2 x 4"
Thanks.

can anyone assist me in making a Golf Start List programme?
each day i need to enter some 150 players in groups of 3 or 4 at tee off
times from 0800hrs and at 8min intervals thereafter. the problem is entering
the handicaps. each person has their own (changing) handicap, however ...

can i send mail from access. i have made database with contacts and email
info. can i list opp some of the contacts, and send them an email direct from
access, and howe do i do that. can any one help me. I just startded using
access

I want to design a access database for aircraft flying hours calculation, in
which i need to keep record of daily flying hours and that has to be
cummulatively added and processed for various needs.
Basically I could not find any functions or methods to add time beyond

I am new to Access and I trying to write a simple database where the user
can only type in a date as DD/MM/YY.  I have tried playing around with input
masks (99/99/99) but I am allowed to miss off the year (Access then assumes
the current year).

I'm currently facing a problem in form. It was required to allow user to
enter any criteria in any fields, and those records meet the criteria will
have all the records details in the same screen... Is it possible?
I had try on filter by form, however i need to view on all other ...

I have a form in datasheet view which when opened I need the focus to
go to a new record.
I already have a command "GoTo Field".
How do I do that?

trying to download attachments with email but it tells me i need a fil called
xls.?

How do I type in the date i.e. 5/10/2005 in one field and in the other field
have it autofill the day Tuesday.  I looked at other post and found this
Format (date(),"dddd")
I tried entering this in the format section of the second box and it didn't

I have a checkbox that I set to "true" as
      chkSuppressHeader = 1
But when I run the following debug statements....
Debug.Print "chkSuppressHeader " & Str(chkSuppressHeader)

Sorry for what is probably a simple question but I am having problems.
I have a query which is just returning records that have a 'Location Code'
of STHT.  In each record is an ID number of a person.  Each person can have
multiple records in the query.  I want to add a new column ...