I need a function that will return a string from a passed string value.  This
is an example of the passed value:
12/10/2007 10:51:04 AM kwithrow Open Call
==================================

I have a form that is a replica from the Northwind db; the Customer Phone
List. I have thousands of accounts in my database. Closed accounts (no longer
buying,) are specified with four (*'s) in the account name. For example,
account name****.

I don't know the syntax to make this work... everything surrounded by * is
unknown
My aim is for the project status to update based on the status of all the
associated tasks.  I have a table with all my projects and their name, point

I'm using Access 2007 and have a database that contains an account ID number
and 30 fields that each represent a procedure conducted by a healthcare
office (Proc1, Proc2,....,Proc30).  
What I need to know is how many records have a non-null value in Proc 2 but

Is there a way that access can notify me of a change to the data base via
email?  Basically I am trying to streamline the interation that I have with a
database.  I am the owner and have to check the data base every day, however,
the data base is not changed every day, just once ...

I wish to validate that a file exists before I start the import.  This is to
be done programaticlly since I am importing many files.  Is there a simple
IsFile() function that I can write or use?  I can't seem to locate one.
My code is something like this:

I am using Access 2003. I have the following lookup in a report.
 intFirm = (DLookup("FirmSun", "stblFirmDays", "[StoreID]=" & Me.StoreID &
" AND [OrdGrpID]=" & Me.OrderGrpID))
It keeps on stopping at Me.StoreID saying Data member not found. StoreID is

I have two combo boxes.  one for a part number and one for description.  I
would like to limit the choices for the description combo box based on the
value in the part number box.
The table this is based on has two fields. PartNmbr and Desc.  I found some

I have an Access application that links to a number of spreadsheets via VBA.
The Access VBA opens either a template or an existing spreadsheet as an
object, modifies the content of the spreadsheet and then closes the
spreadsheet before continuing with other functionality.

Some help needed for a VBA novice.
I have a table called Totals which has one field called Count and another
called CumCount.  Count contains a series of integers and I need to update
CumCount to show the cumulative total as in the following example

(already read the old posts on this)
1.  Any thoughts on a good book for someone who is fluent in Access but new
to Access programming, and who wants to learn Access Programming?  
2.  How "far off" is a book of the wrong version?   Right now I use mostly

In a database I have a subform. The record source for this depends on two
succesive select-queries. Their sql content, set by VBA code, depend on
settings in the main form.
The subform works well, but only if I've used the shift-key to bypass an

This is a bit confusing so let me give an example.  If I have the
following data in a table:
PO         Style   Date           Store
100012   2012   10/31/05      Adam's

I want to delete all files in a folder, and only error show the error
message if one or more of these files happens to be locked for any reason.
Unfortunately, this code is showing error message even when the folder is
empty, not when there is really a problem with deleting one ...

Hello all, I have a pretty weird request. I've been tasked to come up with a
little motivation program on access which uses climbing a mountain as a
metaphor. What I want to do is as peoples sales increase I would like them to
be higher on the mountain. I have a little sherpa ...