The above subject continues to baffle me!
http://www.mvps.org/access/queries/qry0020.htm
This link was posted a few messages ago but IMO these methods don't work
when there are duplicate combinations of the GroupBy and Totalled Fields in

Good morning all,
One of our larger Access db projects has grown, and I'm thinking maybe it's
time to move the backend to SQL. We are running SBS 2003 which has SQL
server installed, but I know absolutely nothing about the server piece.

Hello,
Does anyone know how I can fix this.....
It means that the control is set to read only (Enabled = No); that the
Form is read only (Allow Edits = No); or that the subform is based on

Hi I'm currently working on a database, basically I have a combo box
which lists three values "Trial", "Normal" and "Exeptional". When the
user clicks on "Exeptional" a Comment Box (standard text box) should
appear, however when they click on "Trial" or Normal" or when the form

I have downloaded a plug-in for windows media player from Microsift
which allows me to export my music library to a text file which I can
then import into access. What I would like to do is generate a report
that lists all the Albums I have grouped under the Artist heading. The

I have a need to do 2 things in relation to my list box
1) Like in a combo box I want to enter the letters ie Smith and have it move
down the listbox within the "S" rather than go from the "s's" to the "m's"
etc. Is there a way to write vba to do that?

I want to have a unique identification number that will be called our
internal batch number. I want it to consist of 3 fixed letters, a number,
letter and auto number. The fixed letters will be 'BNS'. The number will
depend on the month and the letter on the year. For example:

I would like to know if the following is possible with Access 2000:
Can data from Access in Query or Report format be automatically emailed?  By
automatically, I mean that no one has to manually send the email--the email
is sent at the same time every day as long as the computer ...

In the click event of a button,i have input the following code:If [Language]
= "Greek" Then Command48.HyperlinkAddress = "\\10.43.0.132\Company\MSKB\Auto
Reply\Greek.doc"
If [Language] = "Hebrew" Then Command48.HyperlinkAddress =

Hello - I am making a form (with subforms) to enter daily batch/deposit
information. I put a Close button on the form, which I would like to do a
"check" before it closes the form. There are three fields included:
TotalDeposit, which is the Sum of CashAmt+CheckAmt

basic design with 1:many in the direction of the arrow.
tble_Query -> tble_CCode <- lkup_CcodeS <- Lkup_CCodeT
When I try to enter a cause code in the form, I get the message:
"You cannot add or change a record because a related record is required in

From time to time, since migrating to Access 2003 a year or so ago, we have
noticed what appears to be a corrupted record in one table or another.  E.g.,
unprintable characters appear at the beginning of the record, text data is
moved to (and often split between) other fields, ...

Okay, apparently I don't know how to construct IF Then statements.  This one
is not giving me the right price structure.
If (52 < Me!Length <= 61) Then
Me.Price = 40.95

I have linked a database to an excel spreadsheet.  I have blank cells on my
spreadsheet that are showing a "Zero" in the database field.  How do I change
it so the fields will show blank and not a zero?

In my database, I have 4 forms that all have the following code
attached to a command button.
----------------------
Private Sub cmdSave_Click()