I am creating a database in Access 2003.  I am not sure what I did to cause
it but when I try to open a module I get a message indicating that the
project is locked.  I have tried to figure out how to unlock it but I haven't
been successful.

Hello,
I have 2 tables and the key fields in both tables are CoName and
ContactName.  I am comparing the 2 tables in order to delete matching records
in the other table.  Here is my SQL string:

I need to strip all the "." from a string for a routine I created to open a
document based on what is in the current form.  Does anyone know how to do
this?
I.E. I have the string "A.E.G. Srl"  I need to strip all of the periods in

I am having difficulty accessing some help topics.  For example, I can get
help for the close method but not the close action.  In fact, I can get help
on all method topics but no action topics.
Additionally, when I get a runtime error message dialog during debugging,

When I use ado to retrieve information from a table that contains a memo
field for my unbound form. I only get about 255-256 characters back on the
form and it cuts off the rest of the comments is there a fix for this.

I am very new to access, but I do have some VBA experience.  
I have created a form with 5 checkboxes that represent contact methods for
customers (Mail, phone, email, pager, other).  Any combination from all blank
to all checked is possible, which is 32 distinct possibilities.  ...

When running an SQL update from a subroutine, e.g.
DoCmd.RunSQL <update sql statement>
I get a dialog popping up warning me that a row is going to be updated and
do I want to continue (YES/NO)

I would like to run an update query and remove everthing to the right of the
comma in a particular field.  (Actually I want to remove the comma and
everthing to the right of the comma)
IE: San Francisco, CA

I have a table that I would like to remove everything to the right of the 1st
3 letters in a field.
IE: LAX Los Angeles, CA or SFO San Francisco, CA
All I want to keep in this field is the Airport Code Designation which in

      In a form, I have set it up so that when the user sets the focus on a
specific field it displays certain other fields and then when it loses the
focus it hide those same field.  My problem is that although I want to hide
these fields when the user goes elsewhere, I want ...

I have a table with the following columns:
Mgr, Rep, RepNum, HireDate, TermDate.
I need to export this to an Excel workbook with a seperate
worksheet for each manager. I know I can create queries to

I have developed a fully functioning sub that parses data from a CSV file
and writes new records to a table in a SQL Server 2000 database.
I am currently in the process of optimizing my code and was wondering if
there is a more efficient/advanced way to parse the data before I ...

I have a bit of code that I am running directly in AC2003 to import emails
from oulook.  Everything works perfectly except that I can not get emails
meeting a certain criteria.  I need all emails that start with ABC* (see
code below).  I have tried lots of different possibilities ...

Yes, I need more help.  Sorry.  My modDosomething has a function called
"doit"
Partial code enclosed:
Public Sub Doit

I have a form where a subgrant has detailed record for a particular year.
The way it is designed is first for a subgrant a year is chosen which creates
the initial record. Then the detials are added to this record. There is a
validation check to make sure the sum in each group ...