I'm using Access 2003 FE and a SQL 2000 BE. When attempting to update a
record in a recordset (ADO connection), I get the following error:
"Row cannot be located for updating. Some values may have been changed
since it was last read"

Since the SetFocus method doesn't work with combo box controls, how do you
programatically do this for a combo box?

I am not sure if this is the right group, but I have an issue when
automating tasks between Access and Outlook.
The issue relate to the warning box that Outlook displays.  I have the
following code to add and retreive tasks:

I am experimenting with passing parameters to queries.  I have a query
where I need to select information based on two fields.  At the moment I am
passing this data to the form via OpenArgs (using a custom routine to
extract information from a variant).

I am creating an employee database.  I have everything set up in a form with
that shows all their information including their employment status (Active,
Leave, Termed, etc...).  I have details about their employment and
demographics in subforms.

Hello!  
I have a main form which display a single company, which contains a
continuous subform with the company's contact names. I would like to have a
listbox with the specific tel, email, etc. for each of the separate contact

I am very new to access. I just found out about the "form" feature. I am
creating a form that I have linked to a back-end database table. Id like to
have the form clear after the final text box has been completed and the focus
to p be placed on the first text box. Also, I dont ...

In a single form, I am looking to multiply the result of a combo box
selection and a label entry to show up in another label automatically
here are the elements I am working with
Table: "tbl_parts"

How do I get to the collection of column names (or column heads) on a list
box with multiple columns (using vba)?

We have Windows XP and MS Office 2003 in a network environment.  In my
Access application, I have my reports hard coded to print to a specific
printer.  Last week IT replaced our network printers with new ones.  They've
done this in the past, and all I have to do is put the name ...

I have combo box contains client_code, client_name and program. I'd like to
eliminate the list based on the program that I entered before. Here is the
list:
Client_code         Client_name       Program

I've got some continuous forms that display information such as: itemName,
itemPrice, itemSize.  On each form, when the user clicks the column heading,
the records will sort either ascending or descending, depending on what the
current sort is.  For example, if the the current ...

I have a table that include 10 different districts with at least 50
records per district. Is there a way I can select 10 records per
district? In other words a total of 100 records with 10 records from
each district. Thank You.

I have a details subform in continuous view. I have code to set the default
value of combo2 after updating combo1.  When testing the code, combo2 default
value was set correctly, however it was set in a new record, not the current
record.  What's going on?  

I am working on a single form with many records.
When I preview my form I would like only the selected record to be
displayed. At the moment it goes to the 1st record. I do not want to preview
using a report.