I am setting up a query and want the criteria that if "WWI" is in one or
more of the columns (6 to choose from) then the entry shows up.  How is this
done?
In the query design view, I tried putting "WWI" in the 'or' row, but none of

Has anyone used FMS for emailing Access reports/forms?
I need to email parts of a report in the body of the email.  It sounds like
FMS will do this.  Is this true?  Is it easy to use/set-up?  Is there
anything better out there?

After installation of Office 2003 SP3 a combo box in an existing database no
longer displays the contents of the list.

I get "error 3075 Syntax error (missing operator) in query expression
'[InvNum]81441."  (81441 is the invoice number being acted upon.)
DoCmd.OpenForm "2frmDELabor", , , "[InvNum]" & Me![InvNum], acFormEdit
1. InvNum is a number field, long integer.  

how can I serach for ? (question mark) in a field data

I am new to adp projects. I have a sp on a SQL 2005 that runs a select into
statement. When I try and run this from the .adp it timesout. If I run the sp
from sql using the username I have no problem.  I am running this in a test
env so the SP takes about 39 seconds when run in ...

I have several programs on my computer that when I try to open them, I get
the following:
Microsoft Access Data Components (box opens)
It then tries to run Turbo Tax ItsDeductible 2006

I have a table and that I have sorted the data by the first column
(ascending) and then added a column next to it as "No." as Autonumuber. Now
when I go to my table after saving it scrambles the whole sort. e.g. record 1
is No. 1 but the second record which should have No. 2 is ...

I have Office 2003 installed on my machine. I need a copy of Students
Database Sample downloaded from
http://office.microsoft.com/en-us/templates/TC012253551033.aspx?pid=CT101428361033
and can not view it since I do not have Office 2007. Could anyone out there

I have a form that I’m using as main form menu, I need three different
portions to be able to hide and view. I know how to hide acDetail section,
Heared or footer but do not know how to hide a potion of the form only, i.e.:
on detail section hide form from grid 2 to 4.

hi all
how can i add a time usage validation in my data base?
thanks

How do I format my tables, queries, reports, etc. to show the (British) pound
symbol instead of regular currency?  Thanks.

I want to change the colour of text in a sub form so that records where the
data is over due will be red and where the data due this week is in orange
and all the rest is black.
there are five fields in each record and all want the colour changing so

       Assume I have a recordset handy, and I'm looking at a record I want to
copy. What is the simplest way?
       In the past, I've used AddNew, then copied contents field by field.  Is
there a better way?

I am somewhat of a beginner in regards to my Access skillset.
I am trying to create two separate queries and am in need of assistance. I
have been trying to use iif, len and replace but am struggling.
1. Text Field (numeric and alphanumeric): If the length of the string is not