I have a query which includes this expression
FirstName: IIf(IsNull([Preferred Name]),"Member",[Preferred Name])
What is odd is that when I run the query some records where the Preferred
name is blank show Member but others do not. I can't see anything different

I have a form that I do *not* want the user to be able to use the
PageUp/PageDown keys *unless* the cursor is in a particular text box.
I'm using this code:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)

I'm getting the error "The field is too small to accept the amount of data
you attempted to add.  Try inserting or pasting less data" when I run a
report.  I'm simply trying to apply the following criteria/filter to this
report "kEmployee in(select kEmployee from proCriteria;)"  I'm ...

I have a text field that I am using in a query. It looks like this
"123456".
What I want to do is pull out the "1" "2" "3" "4" "5" "6" separately
and put it in a report.  I can pull out the following text in my query

I am currently doing a project on Access and am current stuck in the
"search" process and hoping that you could help me out.
I have got 3 tables designed.
When the user clicks on search option based on the record # (not a

I know this is a painful question and I have searched the group for
past responses and none of the responses seem to cover my specific
need.
We have a table that contains fields like

I've several fields in a report which datatype is Date/Time.
Day            WorkedHours
Monday           8:00
Tuesday          8:00

Using A2K.  I have a form with a combo box that runs a query and
returns a list of patients.  3 users are sharing this database and the
query runs fine for 2 of the users but not the 3rd.  The query takes
2-3 minutes to execute for the 3rd.

I have found some code on the Microsoft knowledge base that 'should' allow
me to send emails and attachments
However the code tries to use Outlook and i want it to use outlook Express
the line that selects outlook is

I have a list box control that is bound to a query.  The form is not
bound to any source since I have a few list boxes from different
sources.  When the form opens the list box is populated correctly.
Now, I have a combo box that contains gender values (male/female).

In my accesstable i have one field with two numbers separated by a slash
(i.e. 753/999).
I want to store the number before the slash (could be between 1 and 10
digits) in a field called "F1" and the number after the slash (could be

Some of my clients are looking for a plattformsindependent database since
Access is only for windows and are asking about SQL server. Is it possible
to to use my Access databases as SQL databases and if so what do I have do
do?

I'm sure this is easy so if you have a sec pls help me out thx.
Let say I have an inventory table and at the end of the month I want
to move the info in 1 field (total end of month 1) into another
field(total beg of month2) and then set the original field to 0.  I

I am manipulating MS Graph and can successfully change the minimum and
maximum values for the Y axis, but can't find a way of doing this for the X
axis.
This works for Y axis

In my accesstable i have one field with two numbers separated by a slash
(i.e. 753/999).
I want to store the number before the slash (could be between 1 and 10
digits) in a field called "F1" and the number after the slash (could be