Regarding date comparisons, all of the following will return the same result:
If Date1 > Date2 Then ...
If Datediff("d", Date1, Date2) < 0 Then ...
If Date2 - Date1 < 0 Then ...

I am using Access 2003 and have built a database Switchboard based upon a
Micosoft Access 2000 Sample database. The sample database works ok in Access
2003 but when I use the Switchboard with my application I get an error
message which says "Compile error Method or data member ...

I have a database which has a main form and sub form.
It's a very basic database but i have one main problem.
I have some users who will only be looking at the data in the database
on the form.

I'm trying to open an powerpoint presentation with this code:
     Set PowerpointApp = GetObject("& strDocName &")
       pr.SlideShowSettings.Run
the strdocname holds the filename and the value is set a few lines before.

I have a main form, frmMain with a tab control.. There are 2 pages on the tab
control and each page has a subform containing only several option groups
These subforms are linked to main form by Child and Master relationship.
What I would to do is when I click a button on the main ...

I have function that finds the next record in a table. I use this function
to auto-generate the next record number (in a non-Autonumber field) in
several tables - although I have to have a separate function for each table.
The function uses the

I'm getting "Can't find project or library" message when I try and create an
event procedure in an Access 2007 form. I'm just getting started with this
version, but have used Access since version 1.... There are no references
with MISSING in the list, but the Microsoft Office 12 ...

Is it possible to determine the main Access window form area current height,
width etc... dimensions?
I'm trying to auto layout a few forms next to one another, and would also
like to respond to a main Access window resize event also.

Ok, let me see if I can describe this well enough to be understood.
I have a form which holds customer main information, then I have a subform
which has tab controls.  I have combo boxes and text boxes that are enabled
or disabled depending on what the user chooses.  The problem ...

Hi Group;
           I have five databases where the code below works great.  However
on one of the five I get the error message on the line indicated below.  Why
is the same Sub_routine working in four, but not the fifth?

I have a select statement in my code that references a query.  My problem is
that I can't find any syntax that will allow me to get at the Student_id and
Att_Date values.  Everything I've tried results in the error   "Item not
found in collection."   If I try various forms in the ...

I have several lines of code that look like this.  Is there some way I can
suppress the message, "You are about to delete x row(s) from the specified
table."  etc.,,, Yes, No.
   ls_sql = "DELETE  from tblAcademics WHERE [student_id] = " _

I have a search coding that it has to find records from 3
tables;tblDocuments,tblTransmittals,
tblTransmittalNo,
tblDocuments consists these fields

I have a linked table tblGoals, which has [Messages] of type integer.  I am
simply trying to assign
dMsgGoals = [tblGoals].[Messages]/20.
Currently, Messages = 1000.  I am expecting dMsgGoals to be assigned 50.  

I have a "search" form which is based on a query. There are several unbound
combo boxes where the user can select criteria, then click a button and the
resulting records are displayed in a continuous form below. I have managed to
figure out all the code to make it work (with help ...