Anyone have an idea how to reference a particular row in a subform datasheet?
i can pull the details for the top row but don't know how to reference e.g
the selected row.
Any help is greatly appreciated

I keep getting this error whenever I run my ASP page
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.

We have recently converted to MS 2007 and for the first 10 days, the property
sheet in Access displayed and I was able to utilize it.  Now, it will not
display, regardless of whether I am working in an established database or a
new one.  One other person in my section has the ...

In Access 2000, I have a form set up to create an event.  In another form, I
am able to assign a rep to that event.  In a third form, I have fields set up
to record the event performance.  I have the form and the fields configured
via the properties to allow data entry.   I need ...

Am using Access 2002.
Is it possible to have a message box appear on screen, for say 10 sec, and
then automatically disappear?
If so how can that be achieved?

I want to convert emails to text files, place them in a database, and then
operate on the filenames to sort and parse them.  The end result will
hopefully be that I can pick up some of the converted emails and embody them
in reports or resource material for meetings.

In Access 2000, my main form lists data from a table holding info on an event
location to include a city and a state in seperate fields.
I have a subform in which I list reps who live in the area and (in a table)
have cities they will work in support of the event.

Hello, I love the tooltip code of Stephen Lebans
(http://www.lebans.com/tooltip.htm)
I am able to use it a couple forms in my database. However, it is giving me
"Run-time error'91': Object variable or with block variable not set" in a

I have a datasheet as a subform. Is there any way i can set the column
widths to automatically refresh to the width of the contents when re-queried?
I've found various solutions elsewhere (set datasheet's ColumnWidth property
to -2, using the fields Tag property, etc) but none ...

After user selection, how do I display a column other than column 1?
I display 4 columns: Level 1, Level 2, Level 3, and Description.  The user
is selecting the Description field, but Levels 1-3 are there for
informational purposes.

I need to be able to count how many different vendorID's are in a
list.  The list will contain duplicates of each vendorid so the query
has to be able to ignore duplicates and look at the list and say there
are 2 vendors involved.

If I want to go back 1 year from now and get everything from 1 year
ago until now or 6/24/07 to 6/24/08 is this correct? If so it's not
bringing back any information.
DateAdd("m",-12,Date())

DateAdd("m",-12,Date())

I have a form with half a dozen subforms (each on its own tab....) I have
combo box on the main form whose record source is different from the form's
record source. When I select an item from the combo box (cbFilterforaMICAP),
here's the code that's fired. Essentially, it filters ...

When a form loads, I want to set the subform's sort order based on the
value of a text box on the parent form.
For instance, if  the field txtGender on my parent form, "frm_Parent",
is "MALE" then I want to set the sort order of the subform,