Please can anyone help, the instuction below used to work in '97 but 2003
does not like it at all????
Private Sub Doc_Name_DblClick(Cancel As Integer)
Dim retval

This is probably an easy one, but I'll be darned if I can figure it out!
I have a table with one record per student and another table with one record
for each class a student has or will take. I have a "date updated" field in
the student table that correctly changes to the current ...

I have a need to format table fields programmatically.  Here are the details.
What I am doing is importing a table.  I then do some stuff to it and create
a new table from it containing certain of the records.  (I need it to be a
table, not a query or a report).  I create the new ...

I’m trying to filter my data in a form by 3 combo boxes (can use list boxes
if necessary).  For instance, my user will choose a store from the Store
combo box.  Once the store is chosen, I want the other 2 combo boxes, First
Name and Last Name, to only include those names for the ...

I have a form is Continuous Forms.
There are displayed 1 to Lastrecord.
LastRecord = ???
Howmany records are there?

I am looking to validate a field (field2) on a couple of criteria.
First, a prior drop down selection (field1) must =1, if any other option is
selected, field2 will perform normally.  However, if field1 =1, then field 2
must validate the data as follows:

I would like to restrict modifications to a table (Say TableA)  based on
userid.
I have user information allowed to modify records in TableA in another table
say TableB. The two table are connected with a key.

Hey all,
I've designed a database to track the time and tasks of 9 employees.  I've
created a form that allows them to enter their time and detailed task.  
I've also created various queries, in order to generate bi weekly reports.

I have a button on a form to open a corresponding form.  However, if there is
not corresponding data I'd like a message box to say that rather than having
a blank form open.  How do I write the code for that?  My current code is
simply:

I am trying to implement code in my form where if the preivew button is
pressed, if it's a new record, or if you are a certain user (in the code
below the user is Jimmy) that the preview button is enabled. I want to do
this because my preview button allows edits to be performed ...

i have a "customer's online order" database, in one of the form, i have
"billing info" & "shiping info", most customer's billing address are also the
shiping address, to provent miss typing or type in wrong info, i'm trying to
set up a check box, when i check that box, means the ...

I have a form that is used to edit a specifc row of data. the row is selected
based on  input criteria passed from another form.  The user optionally
updates multipl fields on the form.  The form fields are independantly
evaluated for "not null" values and if not null, a sql ...

I have the usual form and continuous subform. In some cases there's extra
data to be entered on a line in the subform. Logically this should really go
on the subform row - but it won't fit nicely so the solution is a popup. I've
added the extra fields to the underlying table but ...

Ok Here goes the situation, I have posted already, but only one person
answered and the answer didn't manage to sort it.
I use a subform named CommercialConditions_subForm, that has the
following fields:

Novice
I had the following code on a tab page.
Private Sub lblSelectNewRecord_DblClick(Cancel As Integer)
   'select a new record by double clicking on the label