I have an OLE ("package" whatever that means) field type in access. I want to
merge in word or publisher. How? Can I accomplish somethimng similar with
catalog merge and then not have the picture in access but just lookuped in a
folder. The purpose is to print envelopes with ...

I want to create a one-to-many relationship.  I drag the primary key
field from table A to the matching foreign key field in table B.  The
edit relationships window appears and says this is a one-to-ONE
relationship, with no way that I can see to change the type.  What am

I have a query with a field which strips numerics and
sometimes results with two numbers put together.
So for example I have two queries that I want to join.
Query 1                  Query 2

I have a table with year 1, 2, and 3 across in columns and have 13 rows of
data that start at 1 and go to 4 in one-fourth increments.  For example, row
1 is 1,1,1; row 2 is 1.25, 1.25, 1.25, row 3 is 1.50, 1.50, 1.50 all the way
down to 4.  I know that I have 1706 possible ...

I have created a database of students who are attending our summer program.  
I have a form, based on the table of applicants, that has a subform attached
where staff members can enter comments.  The subform is linked to it's own
table.  I would like to count the number of ...

..code snippet..
fname = Dir("C:\Bob\*.*")
If fname = "" Then MsgBox "There Are No Files On The SD Card.", , "": Exit Sub
If fname <> "" Then..

Both my co-worker and I are working off the same database. Within the
database is a report. When I preview the report, the labels for all of
the text boxes are completely visible. When my co-workers views the
report from her computer, some of the labels are truncated.

I have a subform with several check boxes and text fields.  If a user
goes to the subform, clicks on some check boxes, then unchecks them,
or clears a text box, a record is getting saved in the table bound to
the subform.  Is there a way to prevent the record from getting saved

I have a query with a field which strips numerics and
sometimes results with two numbers put together.
So for example I have two queries that I want to join.
Query 1                  Query 2

I added the Microsoft Calendar Control as an ActiveX to my form. Access won't
allow me to see the tables available for the source of data. When I'm in the
form view and looking for controls in the properties window, I can see the
form, detail, and various labels, but the calendar ...

I'm trying to create a module that will calculate the difference between to
date values that will exclude weekends and holidays. I can seem to get the
string to work that's suggested in Microsoft help.  Anyone care to share the
module if you done this before? Thanks.

I'm new to Access and am trying to combine some statements so as to populate
one field on a form instead of two separate fields.  Can someone help me
create one IF statements to yield the results of either of these statements?
=IIf([ssa_ft_summer_enroll]="Y",-1,0)

I am trying to create a query to retrieve jobs numbers from a
database in which the primary key is Job#.  The primary key
is the same in 13 tables I have set up.  Can this work?
Can you give me a sample or solution? and what about

I have a database with a column for time, and I would like to calculate the
difference between times sequentially.  For example in Excel, I would
subtract (A2-A1).  Is there a way to do this in Access 2003?

I'm using a subform that includes a date field.  The user enters the date and
at least 1 other value for each record in the subform.  I'd like to
automatically update any subform records that contain blank date fields with
the first date that the user enters.  I'm sure I need to ...