Hey!!
I've created a Query based on one table which should display every
record in the table. However instead of displaying every record it
displays the one record three times. I tried deleting that record, if I

How can I tell what version of jet a computer is running?
dixie

I am running Access 2002.  I have some reports I would like to be able to
run from VBA or interactively.  The reports use queries with parameters.  
When the user runs the report, the parameter prompts for the query are
displayed, and the user fills them in.  What I would like to ...

Can any one please help me out with how to remove data control from the
form. I create a form with sub form too and it shows 2 controls and i
want to hide/remove the subform control form the main form.
Thanks in advance,

I need the 11,13 equipment1 in table tbl_Events from table
tbl_EquipmentChronology
Table:tbl_EquipmentChronology
TicketNum Outlet    Equipment1

I'm sure this is simple, I'm just not up on anything like VBA syntax &
functions.
I need an Access 2002/VBA code that gets an XL file from
http://www.somewhere.com/name.xls and saves it to the hard drive under

Is there an inbuilt function within MSSQL that converts zero-length
strings to nulls? Or do I have  to create a custom built function.
I am having issues with these zero-length strings as I develop allot
with an MS Access frontend and MSSQL backend.

The database has been split into front and back ends and both are on
network drive. Somehow if one person is in it and another one tries to
open it, it will say 'locked by machine number XXX' and doesn't allow
multiple users to use it at the same time. But this error only happens

I have a form where I enter each time someone looks at a horse or our
farm.  When I print the report it looks like
Date
Person a

How do I write this SQL in VBA code:
SELECT DISTINCTROW Employees.UsernameHold, [Expense
Reports].ExpenseReportID, [Expense Reports].EmployeeID, [Expense
Reports].ExpenseType, [Expense Reports].ExpenseRptName, [Expense

1)Access2003, beating my head against the wall, every other iteration
is "can't find macro Upshift" followed by carefully verifying that no
blank properties have been entered.  Making NO changes at all,
sometimes the message goes away, sometimes not.  Any clues?

I copy a form from another database into my database. I need help how
to i link the table which is in another database with  that form.
Thank you.

In the Format property setting field
in the format properties window of
A97 - what is the correct syntax to
convert  "3364751212" to

If you have a select with 2 attributes where you group by one attribute
and do a count() for the second attribute, if the count() is 0 then
that row is never displayed.  How would you  instead see a line item
where you list the attribute with 0 as the count.

I have a report that displays four pieces of data by default, but two
of these fields are not neccessary for all people to see.
I have made a form that gives the user the choice to select what data
to display when the report is being run. After the selection has been