I have a subform within a main form. In the subform instead of displaying all
records, I only want to display the record from last year plus allow input of
this years data.
Right now I have 2002 data, 2003 data, 2004 data & I can enter (new record)

I'm trying to use DLookup to return a date if it falls within a certain
range and so far it doesn't work. Can someone please tell me what's wrong?
Here's my code:
txtNewDate = DLookup("[Date]", "tbQOL", "[PatientID]='" & TheID & "' AND

I have this line in VBA: sbfrmItems.Locked = True
to lock the subform sbfrmItems.
When I compile, I get a "Variable not defined" on "sbfrmItems" .
Access 2000 (9.0.2720) (it works in Access 2003)

Any idea how I can have the following not prompt me for a number and dial
whatever is DIAL_NUMBER (which is a phone number stored as text)?
Private Sub Dial_Number_Click()
On Error GoTo Err_Dial_Number_Click

I know that you can print each record seperatly, but I also need to have
each record go to a different printer?  Anyone know how this might be done?
Thanks
DS

Can Access identify the machine or network user name?
I would like to restrict some forms to certain machines or users.
Thanks in advance.
Ted

I want to bold some text inside of a listbox. How can I bold only certain
text within a string?
Thanks, Brad

ADP Dynamic Combo Box is S L O W
I have a combo box in which  I am supplying the value list programmatically.
The combo box has 4 defined columns and is bound to the first column.  If
the combo box has only a few entries all works just fine.  But I have a case

In the Format menu you have the ability to place a control back another
control.
I have a continous form with a control placed behind other controls. I want
to have this field colored when it gets focused.

I has two forms open.  One form show all the data in datasheet view.  How do
we transfer the record from the form (with datasheet view) to another form
ie the user select a records from a table and dispay it in a form format.
many thanks

I've read the listing preposted- but I am trying to get a combo box in a
subform to filter based on the selection of another combo box in the same
subform.  I'm very new at VBA coding (so I pretty much am copying what I see
on here) - I have 3 tables 1) Process table - fields: ...

I have a small form, being used as a subform, with a Delete Record command
button (created using the Wizard). I also have a couple of text boxes which I
will make invisable when I've finished the design. When the command button is
used, it will delete just one subform record per ...

I want to use the "analyze data in Excel" feature, with data in a subform. As
of now, when I use the command interactively, it does not work. It will work
with the subform opened on its own, but not when it is embedded in a master
form, even if the cursor is in the subform.

i am trying to create a form which is a register, i have fields monday, tues
etc and i have a field called actual which i want to store the days that the
people are in, i need this to happen everytime the record is updated
heres what i have

I HAVE BEEN WORKING ON THIS SIMPLE PROBLEM FOR DAYS!!!
****All I want to do is when a user selects option "X" for the option group:
1) that option group selection should go fetch the corresponding script from
tblScripts