I've got a very simple database, with a report that the user wants to
be able to print for a single record immediately after entering the
data.
I've created a button on the data entry form that will open the report

Quick Question.  How do I prevent my subform from focusing on a
control that is one page down.  When I open the mainform/subform I
would like the first field to appear in the form instead of having to
grab the scroll bar and drag it up to see the first feel.  This is

I use Access2002. I have designed a database in a router connected
workgroup envirament. I put it into my shared doc folder so everybody
in the workgroup have access to it. I want to have user level and
object level of security control. I have setup a workgroup and added

I have a user who can not change data in a field to different data
that starts with the same letter.  If the user types in "lag" as the
entry, and then tries to change it to "lg", the data changes back to
"lag" when the user hits Enter.

I'm working with a database developed by an untrained person over
several years - and on a network that has recently been upgraded with
a new server installed and MS office upgraded from 2K (I think - it
might have been XP) to 2003.  The database is impressive, both in what

I am looking for a way to use clipart on buttons in Access 2000.
Is there a download site anywhere on the www?

I can't find the eraser97 tool in Microsoft's download centre anywhere
(2 hrs trying!)
Has anyone got a copy they could email to me?
Thanks

Thank you.  Sorry for the delay, I hope this message, as old as it is,
still gets reviewed.  I'm in the USN, and quite busy with a lot of
different things:
TABLE A

How do you run macros on subforms when a mainform opens up.  I've
tried to link it but it says object doesn't not exists.  It somehow
can't find the subform.
Thanks

I have a situation in which I want to dynamically build a SQL
statement based upon criteria.  The statement would contain different
fields depending upon the criteria.  I created a Stored Procedure that
uses If...Else logic to return the resultset.  What I am finding

I understand you may have posted an answer sometime back which may answer my
query. My posting was
"Is it possible to import a spreadsheet from Excel where the rows contain
the

Hello,
We have a set of Access databases that we extract data from into a
centralized Oracle database.  We have a copy of this database in San
Francisco, New York and London.  The SF and NY team actually use the

I'm trying to use the Current event in a simple MS Access 2000 form.
I'd like to conditionally display a field if another boolean-typed
field is set to True/Yes.
That is, if I navigate to a record where the value of the test field

Using access 2003
I have a front end and back end. I would like to close the connection to the
backend so that I can compact the back end without leaving the front end.
Currently I must exit the datbase and start the repair form from another mdb

I've searched through the archives and can't get an answer, so here
goes.
I have 2 databases where I want to make them relational.  I can key
from one field in my primary database to the other database.