Given the fields:
    StartDate    - the effective start date
    PerMonth     - the number of hours which accrue in a month
    HoursAccrued     - the number of hours accrued since StartDate

I have a report that has two subforms on it.  The report works fine without
the subreports in it but as soon as I add the subreports and link the
correct child master fields, the report stops working.  As soon as you try
to open the report, it seems to freeze (display at bottom ...

This statement works
MkDir Path & Me.[Last Name] & "_" & Me.[First Name]
But this one does not.
MkDir Path & Me.[Last Name] & "_" & Me.[First Name] & "\" & Me.Class

I have some code on my oncurrent event on my form (frmFollow) with subform
(frmClaims).  Some of it is working (the bits with *** behind the line) but
the rest isn't.  There are no errors when I cycle through the records or
enter new records, and the database compiles fine with ...

L.S.
I have a form with 2 subforms.
On subform2 there is a field which has as default date().
On subform1 there is a field with the "due date" of the product.

I'm creating an application to manage client service contracts. I always
enter client information into Outlook, and would like to avoid having to
enter the same client information three times. (Yes, three times - I've
already resigned myself to having to enter the information in ...

When you convert your app to an MDE, is there a special ODBC driver that is
needed for the Internet Information Server. When you look at the
administrative tools in control panel and look at the ODBC drivers, it says
ODBC driver for Access.mdb. Since you are converting to an MDE ...

Hi ppl,
I am using Acc2003, which I have just upgraded to from Acc97 (Finally).
I have this code in a combo which is in a subform
worked fine in Acc97, although this particular code wasn't used in a subform

G'day ppl,
Here's what I would like to achieve.
In a continuous form setup:
Both cmbDepartFrom & cmbArriveAt have |NotInList| , |LimitToList=Yes| &

I drop a table, and try to re-create it later.  I get a message saying the
(dropped)table is still there.
I have tried both (obviously not at the same time):
DoCmd.RunSQL "Drop Table xxx"

Hi Groupies.
In A2K3, I have the following code that works fine:
   Dim stDocName As String
   stDocName = "frmDriversSwampersLabourers"

Hi Experts,
Need to create a form (maybe with a sub-form) to do the following:
As the user types a company name the listbox below this textbox should
update and show matching records from the company table.

OK,
I know this is simple but I am having a brain freeze today.
What I need to do is perform a simple subtraction of fields with th
sum automatically entered into a another field.

I have an expression that does not work in my form in the field "owe", On
Enter:
=[due]-[paid]
I'm not sure why it won't calculate using these two fields above. Thanks.

I have many TextBoxes in my form (about 14 TextBox)
I want all of them to behave in the same manner in the "BeforeUpdate"
event.
Is there any method  to unify the code of the Event procedure, rather