Hi,
I have created a search function which at present is coming up with the
following error : Syntax Error In From Clause (Runtime Error 3131)
Access VBA is relatively new to me however, I have included the coding below

I have a form that updates a table.  One field is bound to a memo field.
Users are getting an error once the text goes beyond approx. 2K - 3K.  Before
that, the field works fine.  Is there a limitation on editing a memo field
thru a form, and is there a work around?

Looking for a little help with deleting a table.  I have six tables that I
have two versions of... one new and one old, ie. HQMembers & HQMembers_OLD.  
In my procedure I wish to update the database by deleting the “_OLD” tables,
rename the Current Tables by appending the “_OLD”, ...

I have an application that launches a report to the screen, I then issue
the following command:
DoCmd.DoMenuItem acFormBar, acFile, 11, , acMenuVer20
which brings up the Print properties menu. What I want to do is  issue the

Run-time error '1004,
Select Method of Range class failed.
Can anyone tell me why, the code I was using is
Sheets("Code").Select

Given that
   Me.Form(strFoundItemsForm).Name
returns the correct result, and that
   strSQL = "Item = '1'"

I am writing a function that tests if a record has been created in a table;
it is used before creating a record:
Dim cvdb As Database
Dim cvjoinrst As DAO.Recordset    

I'm passing a form object to a function.
Within the function, I create a new recordset object.
When I attempt to set the new recordset to the form's recordsetclone my new
recordset inconsistently errs.  "invalid object/no longer set"

This might just be a big "NO", but is there any way to make changes to forms,
reports, etc. without having to make the other five users get out of our
database?  It's such a pain (especially cause we are on different floors!)

Access 2003.  As part of a module I use the Shell command to run Kermit (and
old asynchronous communication/file transfer program).  This Shell command
brings up a "DOS" window in which Kermit runs.  How can I programmatically
terminate (close) this DOS window from VBA.  I know ...

A colleague created a db using access 2003 but saved it in access 2000
format, since most access installations here use Access 2000.
Everything seems to work fine except the code used for the switchboard:
Private Sub FillOptions()

How can I assign a default value to an Optional Variable Argument in a
function, specially if it is a boolean ?
The following is a sample function written to highlight my problem. I want
the AddMiddleName argument to be optional, and and should be set to True, if

I am using the following code to send an email in Access 2003.
DoCmd.SendObject , "", "", rs("Email"), "", "", _
     Me.Subject, strEmail, False, ""
It works fine from work where I have Outlook. However, at home I have AOL.

I would like to insert a new field between existing field, how can I do that?
Thanks a lot.
Regards,
Alex AU

I'm a novice at the vba side of things and need a "cleaner" excel output
than just transfereing a table to spreadsheet or outputing a report to
excel.
I have created the following function to create an excel sheet and populat