I am getting error 2105 and I don't know why, Can you please help me
with that?
The user needs to enter the user name and the password so it inserts
into the database. After that a reference number is created.

I need to be able to work with elapsed times for operation of a light
aircraft group.  Flight times are logged in hours and minutes.  I use Access
2000 and can work with the date/time data type just fine.  But my problem is
this: when I try to display elapsed hours greater than ...

I want to write a code on double clink event of ole object. By doing double
click a specific programme is opened. For example if I I want to open word
document each time, then If I do double click on ole filed it should
automatically open word file. Does any one know what is the ...

dear friends.
i have 7 tables and all the tables contains date field
now how to find out the least of date among all the tables and
how to find out the lastvalue (very recent value)of date among all the

Is it possible to create a chart from data from more than one query or table?
I have figures for 3 years (in 3 seperate queries) and want to produce a
chart that displays averages for each month across all 3 years- e.g average
for jan, 2005, 2006 and 2007, feb 2005,2006 and 2007 ...

dear friends,
my form setting to the  first record of the table as it opens but i want the
the form to get set for a new record how to this programatically
(WITH OUT SETTING THE DATA ENTRY TO TRUE)

Dear friends,
I have two tables, e.g. Table1 (NumberOfPlot - Primary key)
Table2 (NumberOfPlot - foreign key, Species), which are related as One to
Many.

In Access 2003, I am using VBA to find a string in a table. Every time I try
to execute following line:
anRST.FindFirst "John Smith"
I get "Run-time error '3077':" which says:

I'm new to taht forum so be kind please !
What I need to do is to popullate a list of Order with the total off it.
Some order MAY not have any details.
Sum() is ignoring Null value so I tried this :

I currently have a printed form that has all of the possible requirements
typed on it. The person filling out the form will circle which of the
possible requirements are needed for this particular being issued.  I want to
have the possible requirements be check fields on the ...

Four Report Problems: (So you know my Control Source for the Report, it is a
Query.)
1)Sometimes, the FieldID AutoNumber, ie,”45,” shows in the Report rather
than the entered information, ie, “Client.” I pull the Field Name from the

How do I make every other line on a FORM or REPORT a color so that it's
easier to read when you have a long list?  In Excel I do a CONDITIONAL FORMAT
that states:
=MOD(ROW(),2)+1<=1

I am getting error 2105 and I don't know why (There are no null
fields).
I use the code:
On Error GoTo Error_Handler

If I have a query that has 4  fields, 1 being [Charges] how do I filter a
the drop down list to show all records with the same [Charges]
So as when I click on a record in [Charges] it shows all records with that
have that!

I want to make one of my forms come up when Access starts. In 2003 this was
easy.  How do you do it in 2007?