I was wondering if someone could tell how I get a DLookup Function t
return the last or latest record.  I have a DLookup Function whic
looks up the date field for a given user.  If this user has more tha
one record in the table I need the DLookup function to return th

I have a form with 2 subforms visible, the top subforms has detailed
information on the item selected in the bottom subform, on the top subform is
am unbound name field which when double clicked bring up a new form to
enter/change the name, when it is closed, the data is passed ...

In Access 2000 I would like my user to be able to click on a data point in a
record on a continuous form and have that block of text selected and copied
to the clipboard to be pasted elsewhere.
This:  

You guys have been wonderfully helpful to me in keeping me on the right track
with my
database. I have some expertise in creating web sites but this is definitely
nothing

Please help me on this...
I have a form1 with some controls.When i select editcontrol on form1 it
opens up form2.I have some settings(variables) in form2.I make some
changes to the settings in form2.When i click on ok on the Form2,i

Hello;
I know how to requery controls on subforms, but what about this one?  I can't
seem to figure it out:
I have a form with subforms on it.  One of these subforms contains a control

A textbox date field has an edit mask of 00/00/0000;0;_
The user put a valid date into the field, but some time later discovered
that it was premature to enter any date value.
So, the question is: How do you code an edit pattern to allow the removal of

I have string SQL like this when I run by Query it OK but when I bring to
code it doesn't work. I don't know why. Please anybody can help me
strSQL = "SELECT Qry_SLTDTemp1.ID, Qry_SLTDTemp1.Time INTO TblSLTDTemp1"
strSQL = strSQL & " FROM Qry_SLTDTemp1"

I had the impression that someone had come up with faster versions of
the various built in domain functions like DLookup() and DCount(). But I
can't find them. Anyone know if such are available?

I am very confused!!
I am working on an application that includes public subs in a module.  An
example is:
         Public Sub CancelCurOrder(NewOrderNo As Long)

slowly feeling my way forward as usual ....
I have a main form that contains 3 unbound combo boxes allowing user to
choose employee, month and year (of monthly timesheets).  Event code in a
button on main form then collects the value of the timesheet ID (primary key

I have a form with three subforms.The two subforms contain dates.
In third subform I want I present records using as criteria the dates from
the other two subforms.
What code it should I write in the  open form in order to it works?

I have a switchboard that opens my Home form that when clicked upon in two
errors has code to open my f_PrimaryEntryScreen which has two subforms -
f_BudgetUnit and f_PrimaryEntry.  When I click on a record in f_BudgetUnit it
opens up in f_PrimaryEntry the appropriate records.  ...

I have code that works already, with the exception of a date range.  In the
database there is a field named BarDate that I want to run a query on.  My
current form has code where if a field is blank on the form when you hit the
Apply Filter button, it uses the * to grab all of ...

I have a form that connects to a remote database and creates several
recordsets. Depending on the state of the remote db, this code may take some
time to run. I would like the user to be able to cancel out and stop the code
by hitting the ESC button or clicking a button. The code ...