i'm using a code in the following form:
http://img169.imageshack.us/img169/3230/frmcontmonthlydetailsedqn4.jpg
when the user click on "Add New", the last record should be duplicated
according to the append query "strSql_ContMonthly", the the form is closed

I haven't coded Access forms for years, but I recall that I used to be able
to get a user's user name programmatically and insert it in a field. The
typical use for this was when someone updated a record and you wanted to
record who the someone was. I seem to recall a function ...

Problem:  spell checker (F7) no longer working in runtime version of Access
XP when it is installed on new laptop.  New laptop has Office 2007
installed, and the spell checker works ok in Word 2007.  New computer is
running Windows XP Professional.

As I learn more about coding, I see a lot of examples where folks use a
recordset to update a table rather than write a SQL statement and use
docmd.RunSQL.  Just from a syntax standpoint, the rs.update method seems much
easier for me.  Is there another, more technical reason to ...

I have two forms (single forms) that have the same table as their record
source. Form 2 is opened by pressing a command button on form 1 and it shows
the same record as form 1. In the On Deactivate event of both forms I have
    If me.Dirty Then me.Dirty = False

I have a DSum and I was wondering if this is the same or different?
They both seeem to gice the same answer.
DSum("(QTY*(Price+DisAmount))*Tax","tblTest")
Or

An input form with several bound fields, two tables with referential
integrity invoked. I fill in the fields in the form and when leaving
the last field ......  if the [ItemCode] value in the first field is
not in the [ItemCode] master table Access tells me that. I open a

I'm trying to use TableDefs in another DB other than my current DB.
I have a function that finds the other DB as thiscan change.
Here is the function.
Public Function REDACT() As String

Subform reference !!
I hav a main form (named A1) and a subform (named A11).
On the subform I have a combo box in which I can choose an index in a table
containing a bunch of persons with their names,addresses, phone numbers etc.

Access 03  200 format
Using an OnClick event from a text box, I open a new form (frmDHall-Add)
from a subform (frmDiscipline!subDisciplineReferral).  I want to pass 2
values to frmDhall-Add from the subform LocID (6 digit number) and DhallID

I have a table with 3 "time" fields:
1 starttime
1 stoptime
1 "worked time"

Hi all, I have a command button on a subform.  Which clicked I want to print
out a word document whose path and name is in textbox.  So far I'm just
opening form in code but I can't get it to work.  Here's code so far:
Private Sub Option60_Click()

I have frmA(main), fsubB(subform of frmA), fsubC(subform of frmB).  I want
to requery fsubC, when fsubB.combobox value changes/after update event.  I've
tried below code and many others with no success.  Please help.  Thanks.
   Forms![frmA]![fsubB]![fsubC].Form.Requery

I have a list box LstDetentions in which a user can select a specific
detention date.
A control cmdDelete allows the selected date to be cleared later if
required. However if more than one date has been selected, using cmdDelete

I am designing a database for a group of ladies who are older.  Some of them
have 15" screens set at the larges possible resolution, others have more
standard set-ups.  I am trying to design a form that is functional, yet will
still fit completely on the screen of the most ...