I have an access 2000 database running a custom application.  I have a
record management form which displays all the details for an item in the
system, (covers 4 main tables, decending in details 1 -< 2 -< 3 -< 4 >- 5 and
a lookup).  The fornt end stores the code, and the backend ...

In looping through the Forms collection,changing the names of several control
names in the FormHeader, I triggered an error on a form that doesn't have
one.  How can I test for this?
Thank you.

Can anyone explain in simple layman's terms what Class modules
are and how they can be used? I have read numerous articles and
book chapters on the subject and still can't quite get my head around
the concept. I have a rudimentary knowledge of VBA and have successfully

I seem to remember that I used to be able to refresh all linked ODBC tables
at once.  Now I don't seem to be able to do that.  It's possible I'm
remembering wrong; that's been known to happen;  or equally possible that
there's a way to make it happen that I've forgotten.

Can anyone please help me with this?
How can I link my other email accounts to my outlook express account?

I have a form based off a workload table.  Once a specific task is completed,
a checkbox is marked yes then a report is created and saved in a snapshot
format.  Each snapshot is given a specific name for identification purposes.  
As things stand, we cannot check several items off ...

I need to set up a database, is there a program to do this, it is for
storing, contact details & telephone numbes.
If there is such a program can I get it free, or do's any-one have this
program that I can have.

I am new to computing, I need to set up a database so that I can store
contact details and telephone numbers. is there a program that I can get, or
do'es any-one have a program that they would like to let me have.
please help as this is important.

pls help me with teh following problem
i have written a pice of code, how shuld i define stQueryAuslauf if the
variabe should present the output of an query (eiter there is any or none)?
Dim stQueryAuslauf as Variant

I have come across a Function that calculates networking days takin
into account bank holidays. My problem is that the Function work
perfectly in Access 97 but does not work in either a 2000 or a 200
version. I believe it has to do with ADO & DAO, but I do not understan

I have a client running an app (Access MDE code SQL2000 data) I developed
using
Windows 2000, Access 2000 under very rigid update control.
I find difficulty in matching MDAC & dll versions between my development

I created a Word Table using
WordObj.ActiveDocument.Tables.Add(WordObj.Selection.Range
NumRows:=3, NumColumns:=2
The problem is that I cannot get the entire table to align to th

I want to set the secondary axis to the same value as the Y axis....this
code modifes the Y axis, but how to reference the secondary axis?
Me![Graph0].Object.Application.Chart.axes(2).maximumscale = 7
Thanks

Is there a built-in function in VBA Access that returns the number of days in
a month in any given year?  Or you have to develop your own.  
Thanks in advance

We have an ever-growing multi-purpose application whose grey forms have
become a little tired-looking.  We'd like to make some simple changes to
color and positions of the title and eyebrow from their current locations,
etc.  The title and eyebrow are in a consistent place form ...