In a query i want to count the field SR (formatted as number),but this
field my be repeated twice or three times,so I want to count every SR one
time only...
Can anybody help?

I need to print a constant number of lines per group, as my report
needs to print on pre-printed forms, and the data needs to land in the
correct location on the paper.
I found the following support article on Microsoft's web site, but it

  I've 2 Textboxes on my form:  FROM,TO and a combobox called AGENT
 I want to select an agent in the combobox then press on a button so that I
may Write the agent in all the records between FROM and TO in a tabe called
CAP

Hi. I've got a report based on a querie. On that querie I've got a column
that returns me a percentage of a value, may column formula is:
Perc_Cons_Corpos: ([Dif_Cons_Corpos]/[Prod_diaria_cravadeira]) ,and sometimes
the column [Prod_diaria_cravadeira] has the value of zero and ...

I am using the code below to send an email from Access.  It works fine on
some machines but on others I get this error message:
Run-time error: '-2147319779 (800280id)':
Automation error

I have this table (with 1 column, 14 records), now I need to make a new
table showing all possible combinations of these records, to which I can than
add more columns.
BTW the table is used elsewhere.

We have installed Office 2003 but did not get the suite that included Access
2003.  We are working with Access 2000 but would like to upgrade to Access
2003.  I cannot seem to find the software for this exclusively.  Can you
advise source and cost, please?

I notice in the Northwind Sample Database that the 'Products' table has a
Primary Key of "ProductID" and is related to the 'Order Details' table by a
One to Many relationship using 'ProductID'.
The 'Order Details' table shows 'ProductID' as a Primary Key - how is this

My Combo Box [cbOwnerName] has a Row Source [qPayableTotalForPayment] which
has 9 Columns in combo box the last Column being
[My Date]MyDate: Format([MaxOfBillDate],"d-mmm-yy")
I want to code my Button to Change the date in [tbStartDate] to the date im

I've created a simple database using Access 2002 tracking donations made by
individuals and donations made by Corporations.  These donations are being
used to rebuild the old arena in town so I created two separate tables - one
for Corporations and the other for Inidividuals ...

My question,....
I have a query which count the number of records in a table (as a
result of the menuoption view-> totals ->count) as a result of the
group by function for unique records.

  I want to sort a fom ascendingly according to the RECEIVED field,what's
the code that i should use in the click event of a button?
 I do want to do the same to sort it decendingly..

I need help as I want to create a central code library of re-usable
VBA functions that can be used by any one of the four Access
developers in our team.
I have set this up by creating a Access add-in database

haber grubum türkçe olsaydi daha iyi olurdu

What is the assignment for english about, the one for the director to make a
poster board for.  I forgot my paper for the assignment, could you type up
the the assignment for the posterboard one. Please and Thank you.
                                           x.o.x.o. Haley