I have been able to set up a Find Record Button on my switchboard to
take me to a form with the correct case number by using a parameter
query and macro.
When I try to run the Find Record button from the macro on the form I

I have lately strugled more and more with Access, what started as a
simple database has brought me to the fundaments of Access.
I need to transfer fields from various tables to a word-document to
make a decent report (transferring a report from access to word means a

 I have an application that has been running for years
and had little problem with it.  We've been retesting the
latest code under Windows 2003 and found a surprise.
 There is a certain case where we allow the MDI app

I have a form that won't allow me to enter data.  The sub-forms work
fine, but the main one won't allow input or a new record.  What am I
overlooking?

Finally put together the new box I've been going on about for the past 6+ weeks.
The old one has Semantic Antivirus and FireWall on it.
I'm guessing that the new one will need a separate license of whatever product I
choose.

Every day, three times a day, I take and record a certain tank level.
These levels are taken on the first shift, second shift, and third
shift. I have a table containing TankLvl1, Tanklvl2, and TankLvl3 and
this table is populated by entering the data on a form. I would like

I have an access dbase that draws data from an external program (SQL server)
I am not sure if I have an access based problem, or something with the ODBC
settings..
When I compare the settings on my machine with a coworkers (that is

I have a query that joins 3 tables. One of the tables (SalaryData) has data
where there may be duplicate records with different dates.  Of those
duplicate records, I want the query to show me only the one with the latest
date.  The query below shows me all the records - including ...

I am using Access 97 and developed a database that can run on most of
computers except one notebook computer.  When I open the database, an error
message as below displays.
Microsoft Access

I am trying to use a consolidated filter form, where I pass
the desired report I wish to run.  I would like to install
this form on my custom menu bars, but I can't figure out any
way to pass data to the form via the menu.  

This will be not easy to explain as my mother language is not english,
so my apologies in advance if it sounds confusing.
We have a database access 97 wich controls time of people in their job
in order to finally know how many money costs us to run some projects.

We recently upgrade form Office 97 to Office XP.
Under 97 we had about 15 small databases for various departments that shared
data.
In this example I'll use our Disconnect Database.

What in this code is stopping me from adding new records?
Private Sub ListProd_Click()
    On Error GoTo GotError
    DoCmd.GoToControl "[Sales Details]"

I have 2 tables:
Product_List
Product_ID (PK)
Product_Name

In a query, a category has a number of products identified by numbers,
i.e. 240, 300, 560 etc. Each of these products can have any number of
items each with its own value. I need the sum of various groups of
products. Say products from 240 to 330, sum of the values. Sum of