I have a combo box with three fields; fldPainID (hidden), fldPainScore,
fldPainScoreDefinition. The fldPainScore has values like; 0,+1, +2, +3, etc.
and the fldPainScoreDefintion has text corresponding to those values
explaining how to score a patients pain. I want the list's ...

Hi, everyone
I have a form where I used a Dlookup. But then I keep on having an
error message from vb saying "Previous operation cancelled.". Here is
the code could anyone tell me what is wrong with it.

I have 10 unbound combo boxes on a form.  Users will use these to selected
the desired attributes for display and printing.  The problem I'm having is
determining if the combo box has a value.
I'm looking for an automated way of checking them, rather than 10

I need someone to please walk me thru how to set this even. I have a
combo box and I want it to return to the default value when the user
clicks somewhere else...be it in the form or another program. I have
no clue how to do this. Can someone please walk me thru this. I can

In my startup option I always check the box for the application to be used
for the form/report icons. When I go to distribute my app, I put the icon in
the same folder as the program. It does not show up on the distributed app.
I've created the UseAppIconForFrmRptIcon=1 property ...

I want to create a scoring system for every time a user gets a correct answer
to a question. (Max 10)
At the moment I am using an unbound text box with a calculated ‘SetValue’
macro to record each correct entry based on a simple Yes or No unbound

In 2003 the code:
Dim rst As New adodb.Recordset
works.  In 2007 I can't get the software to recognize there is a recordset
typ ADODB.  Any help or suggestions?  How do I use an ADODB recordset in 2007?

I read SandyR's post but could not solve my problem.
In a form, I am trying to make the user enter a date of employee transfer or
seperation (Unassignment). If the user checks either the Transfer box or
Archive box and does not enter the date, I want a message telling the user to ...

Property for the form's record selector is set to "YES" and the record
selector is still missing - why?
thanks in advance
Linda

Using Office 2003 and Windows XP;
I have a couple combo boxes on a form that are being used like filter
choices for two subforms.
1) How can I programmatically set a combo box to the first entry (combo is

Microsoft is ready to release, on January 30, the retail version of
its operating system called Windows Vista. It has taken more than five
years, about $6 billion and over 5,000 developers around the world.
Vista is a major overhaul of Windows operating system (OS) and offers

My problem is that I have a payroll application which works pretty well. I
want to expand it to simplify another task. This task is to export to the
results of a query in payroll to an excel file on my A-drive that is created
each month after the completion of payroll.  I have ...

I have a listbox with two columns.  The first column contains numeric data
and the second column contains alpha data.  When I display the listbox, how
do get the numeric column to be right justified and the alpha column to be
left justified?

I want to create a scoring system for every time a user gets a correct answer
and place the value in a form control.
I have an Answer combo Box that if the user selects the correct answer,
updates an unbound ‘Answer’ text box with the value “Yes” or “No”.