For some reason, I can't remember to save my life how to add a "+"
sign to the beginning of a field.
I need to do a query to import information into Active Directory, and
I need to add a + sign before the Cellular01 column, so the column

Is it possible for a form to load with a default selection for a multi
select list box? If so, how?
Chas

I have a query in which I am trying to create a formula to check if the date
in a record is in the same month as the current date, if this is true to
return the months name, if not to return another value. The formula does not
fall over but only returns the OR value. The OR value ...

I am trying to create a formula that checks to see if a date in a record is
from the same month as the current date and if so return a value
The formula is not falling over but always returns the OR value.
Could someone take a look and point out my error

I'm struggling to understand why Access 2003 can't save pivot table and
pivot chart layout.
I've tried to:
- build a query\view and set pivot table default view: when opening again it

I created the View and Edit two forms. The first form displays all records
from a table and second form is for editing the record which includes Add,
Save and Delete buttons on it. User could view the record from view form, if
the record does not exit, he will add this record ...

if so, how? Thanks!

I have a Report that has 4 fields one being [Category] on my Form I have a
drop down combo box with [Category] text listed only, What would I need on
my On Click or After Update in my combo Box so as if I click Apples on my
Combo Box my report [rptCategory] will show all records ...

To filter a recordsource, I want something like:
SELECT ...WHERE [Name] =' & strName & ';
I would assign the above to the recordsource property of a form. My intent
here is to save a step over opening the form on a table and then setting a

I have an hp all in one printer.  In order to use attach scanned documents
to my email, I've been told that I have to have Outlook or Outlook Express.
I dislike the idea of downgrading from the new Windows Mail in order to use
my scanner.  I am not real proficient with computers ...

I hv this field and sample data in my table
ID                        DOB
701011123214      11-Oct-70  
ID is text field & DOB is date field.

I'm hoping this is a simple issue but not sure how to track it down in
Access. I have a form needs to show a specific record and the filter seems to
be correct. During trouble shooting I found that the form does not seem to
have any records associated with it.

From: "Zanstemic" <Zanstemic@discussions.microsoft.com>
Subject: Form Not Searchable
Date: January-30-08 3:57 PMidon;t have any idle
I'm hoping this is a simple issue but not sure how to track it down in

I am not familiar with Access and I am not sure if this is what I need.
I get various spreadsheets from multiple clients with variable information
in many different formats.
I want to extract only the information I need into one common format that I

In Access 2000 when I used the Analyse with Excel button to export a report,
text fields are truncated (to 170 characters).  How can i get round this
problem.