Hi Everyone.  I'm sure this is not a new question to Access pros...
I've got one table showing all possible selections contained in 1 column,
from which users choose an appropriate "department".  The table
actually has 2 columns, but column 1 is just an auto number field - not

I am making some changes to a database that I didn't create and ran into a
problem where the original creator used the word 'Time' as a field.  I am
trying to run an INSERT sql statement on this table and naturally, it
doesn't work because of the Time field. Is there a way around ...

Can someone help me make this work? I know there is a way I just am stumped.
If Forms![Inland Marine]![Inland Marine] "IS ACTIVE" Then Me.Inland_Marine =
Forms![Inland Marine]![Inland Marine]
Thank you so much for your help

I'm trying to email a report based on the current record (you'd think there'd
be a wizard for sending ONLY the current record; I mean, who sends every
Invoice every time?).  I've used the code below along with several
variations, but still can't seem to send only the current ...

Is there an easier way to code:
f Me!txtActivityCode = "EMAIL" Or Me!txtActivityCode = "INCAL" Or
Me!txtActivityCode = "TMADJ" Or Not (IsNull(Me!txtComments)) Then ...

I have proberly done this the wrong way to start with.
I have:
tblShip
tblSources

I have created a form which allows the user to open a
report using various values merged into the
stLinkCriteria. This works great due to some help from
this newsgroup. I have also added the final line in the

I have an unbound textbox on a form that I want to type some text into and
then filter the data showing only the records that contain the word. The
field I'm trying to filter is a text field called loss description. I'm
having triouble filtering the data using wildcards. My first ...

I have a continuous form that display rows of records. There is a field in
the form that is calculated for number of days. I want to change the colour
of that field if it is greater than 10 days (for example).
Could someone point me in the right direction as to how I would change ...

I have a subform that, unless a certain value in a combobox is selected,
remains invisible.  Under this subform are other fields that will need to
be filled in regardless of the subform. My question is, is there a way to,
if the subform is opened (made visible), create code that ...

Is there a way to check to see if multiple linked tables are present ?

I'm working my way out of a very bad situation believing that somehow there
must be a better way to accomplish the task than the solution I've got right
now.
I have appr. 10 reports that users would like to have filtered by topic, and

I have been creating switchboard items in applications without trouble in
the past but now i get an "Error in Loading DLL" on the line of code in
switchboard.
Set con = Application.CurrentProject.Connection

I have 2 combo boxes and 5 text boxes. I want the second combo box only to
display the items that are linked to my selection in combo box 1. Then when I
select the appropriate text from combo 2, I want the 5 text boxes to display
the text that is linked to my cvombo 2 choice in ...

Hello -
Is there a way I can put in an "on current" event that
when a value in a combo box is true, then lock the entire
record.  I need it so if my "approved" field is "no",