I have multiple forms in my access application. I want all the forms
to have consistent formatting for fields appearing on the forms (i.e.
same background color, fonts, font color etc).
Obviously, it can be done manually. But is there some template

Hi MVP's,
I was trying to write an assignment declaration within my report that would
reference an active form:
Private Sub Report_Activate()

Hi MS Access & MS SQL Server Gurus !
I am trying to delete duplicate data from a LINKED SQL Server 2000
table (LinkedTable) and insert the result into a local (in Access)
table.

Various versions of my app have been in use for the last 5 years or so
(in Access 97, 2K and XP editions). To upgrade the back end for people
I have to add fields to some tables, some new indexes, and a few
tables.

I have a table which has fields "year", "odometer", and "annual"....
what i currently do is enter manually data for all fields,... what i
want to have happen is the annual figure to be added automatically by
subtracting the previous year odo reading from current year reading

Hi!  Help!!
I'm new to VB, and although I understand all the theory I need to
program, I don't know the docmd commands.  In particular, right now
I'm just trying to open a table in Access -- yes, that's all -- but

Can anyone tell me how I can run code/macro in a different database???
Below are the two situations where this may be applicable.
1. run a macro/code in another database that sends a file. I do not want
these tables/code/queries etc... to be part of my standard database, because

I must create an application with Access 2003 which generate a
fabrication planning
i don't know how i can sort cells because i have different parameter
has to take into account.

I am currently developing a database that will spit out job completion
stats each day of a given month.  I have a table that has lists the
number 1 through 31.  I am using this as a static table.  I have a
query that for a given employee lists # of jobs completed, hours

In a gradebook database, every new semester, several classes will have
identical groups of activities (i.e. "Participation," "Essays," "Exams,
etc.)  They will also have the same weights as in other semesters.  So when
creating a new class (or course) I have a form with two combo ...

wondering if anybody could spot anything wrong with this SQL DELETE
statement, both my Access and SQL skills are not what they used to be
so i reckon its something simple, any suggestions appreciated.
-----

Good morning,
I have a client with an Access 2002 database that is giving an Error 3197
upon open (The Microsoft Jet database engine stopped the process because you
and another user are attempting to change the same data at the same time.).

I'm building a table of grades report based on a crosstab query where
students are in the rows and the activities are in the columns.  The grades
are in the body where the rows and columns intersect.
The problem is that the activities will change from semester to semester.

I have a lookup table from which I want to categorize various bands of
customer net income.  Some of the income is positive, some is
negative.  The bands vary in size (ie, <500, -200 to 0, 100 to 1000).
When I have a lookup table w/ the "threshold" amounts of income, I'm

Just when I thought I knew everything...
Does anyone know why sometimes when creating a subform, the
RecodSource property is totally unavailable, this appears to happen
when you don't use the subform wizard. Instead of a "RecordSource", it