I have a database with a ole field called Picture. I placed inserted a
picture in the field for each record, however, it does not display the actual
picture onto the form, instead it displays the name of the picture file. Can
anyone help me to display the pictures. Thanks very ...

I accidently deleted one table in my database.  The table was called
"departments" and only has about 10 entries.  It was mostly used for a drop
down in other forms of the database.  I have a queries that uses it also.
When I run the "dependency" option, since the table is not ...

I have a key on my main form and wish it to go to the subform to be written
on the second table.  Then I wish it to join up with the Date/Time element to
write to the second table.  How do I do this?  I know how to join the two
table elements in a query but how do I do it on a ...

I have the following expression in a report in Access:
=Sum(NZ((IIf([Ind]="Actual-LIHTC",[1],0))+(IIf([Ind]="Actual-HTC",[1],0)))
-(IIf([Ind]="Original Proforma-LIHTC",[1],0)+(IIf([Ind]="Original
Proforma-HTC",[1],0))))

I have built a database that has score for each name and I don't know how to
calculate a total amont that the 'name' has scored. For example, I enter
three records and the 'name' has scored a 3, a 5, and a 1, I need to show on
the form that the 'name' has scored a 9 and every ...

I’m not sure how this can be done but here is the situation.  I have a table
of records that users will take that information and input it into another
program.  When completed they will click the checkbox that will indicate its
done.  Because I will have approx 3 people working ...

I have several drop down list boxes on a form.  I would like to change the
view to a form from continuous form to single form based upon which drop down
list box is selected.  I am unable to find the code but I know a single form
= 0.

Anyone who can help!
I need help setting up a manual date calculator in my access program
(Example)
Fixed Date: 1/1/2008

Long story short... dealing several legacy access databases that I inherited
and now I have run into a brick wall (caused by one data field).
I need to find a quick/simple way to convert a NUMBER field to a text field
for comparison within an update query.  I realize simplest ...

I tried posting this in microsoft.public.activex.controls,
but no luck.
Upon reflection, it seems better suited to .access because
it seems to be something about how MS Access VBA handles

I have an image on a tab of a tab control that I'd like to change depending
of a field value. I know VB code can help me do this but I am not proficient
with VB code in Access yet.
The images are that of an icon representing a Male and the other a Female.

I have a problem that is apparently simple but which I struggle to
solve. I have the following tables (simplified):
Table tblClient
Client_id

I have a table that contains data in 2 columns. Column 1 = Part Name Column 2
= APL number.  I want to create another table that has mulitple columns for
the APL number going across in a row format.
Ex.

I think I'm having trouble grasping the concept of cross-tables.
My data originates from huge delimited-text (CSV) files consisting of almost
1,500 fields per record. I have been successful in designing tables that
address only one subject, designating primary keys in each table, ...

Is it possible to contain OpenTable or OpenQuery within an Access
form?  Instead of in its own window?
Why do I want to do this?
I have a form that shows all of the fields, data types, descriptions,