The table source for the combo box doesn't have anything in it and I have
code in the "not in list" event to add to the list. When I try to add
something to the list I get the following error:
A problem occurred while Microsoft Access was communication with the OLE

I have a form with a subform which has the Default View set to Continuous
Form. In the subform header is a textbox which contains a value used for a
calculation in each record in the subform. If the value in the textbox in
the header is changed, I want all of the records in the ...

I would like to change the color of a row or the properties of a field in a
row in a tablular form depending on a value in the row. I can do this with
reports. Is this posible in a form.
Thanks,

What I am trying to do is create a simple button that will +1 to the value of
a field.
Say for instance, record 1 has field "pens" and value 10... i want a simple
button that will change that to 11, then 12 if clicked again.

I have two subforms on one main form. They are both controls of the same main
form. Neither is a subform of the other, and they are not linked. Nor are
they linked to the main form. This arrangement is to allow simultaneous
viewing using a continuous form for form 1 and datasheet ...

I have a form frmEst with a subform sfrMat. On sfrMat are two combo boxes,
cboCat to choose a Category and cboPartNo to choose a Part Number. I want to
limit the choices in cboPartNo to only those parts that are members of the
Category chosen in cboCat. I'm really struggling with ...

In my form i want to lookup a field in the query and multiply this to the
value of a control.I get however errors.is it possible to do what i am doing :
Dim NewUnitprice As Double
set NewUnitPrice = " CCur(Nz(DLookUp("NewUnitPrice";"qryAmount";"OrderID=" &

Please can anybody inform me how to set the back colors for Listview and Treeview SP 6 controls. I can set them for separate nodes, but would like to give them an other appreance than the standard white.
Thanks in advance,
regards, Jos
--------------=  Posted using GrabIt  ...

i have a table that has an image for each record.  I am trying to create a
form to view the data and the image.  When I place a bound OLE Object on the
form and set its Control Source property to the field in my table that has
the photo...the image never appears.  I can see the ...

This seems to be an old problem. I have seen several questions but no real
good answer. What I have now is the following.
A form with a combo box to select records using the AfterUpdate propery. It
is smple, it works, in current access it is even created by a wizzard.

i ask if there is a way to change a control's property but in only a certain
record
in another words
i have a form which is tabular

How to export an Access query to a text file without the column heading? The
query consists of single column and is used to import to an accounting
system. Thanks.

I was suggested to use only one table from my project.  The reason is that I
want to break it apart by different queries, send the individual tables to
the different field reps, they update the information, send back the tables
and then with a UnionQuery, combine the information ...

I need help with a custom login screen. The following tables and fields are
what I have to work with;
Table              Field
Staff Info        SN (Staff Number) (Primary Key)

I have  a  Front End/Back End Access aplication.A friend of mine is
developing an aplication  using
.Net and WEB Service which should be able to connect to my ACCESS Back End
database.