Is there a web site that can ofer some help. The quotation marks are posing
an issue as well as other items for this function. I have some books but
they are not consistent in their use of the code lingo. Thank you for any
help. Presently I have tables and forms to gather ...

Hi
I have Created A form to allow the user to  query a text field which
is  a name
i am trying to create a query that runs of a button.

Being fairly inexperienced at Access 2000, i've been reading many posts
here for the last several days, and testing myself to find the best
approach to do the following in A2K:
SET UP:

I get this error message when trying to compact and repair my database:
(Could not find field "Description").  When I clicked on Help, the error message number comes up as (Error 3799)  It's the first time I see this.  Help anyone?

I want to open an excel template from a specific location i.e.
C:\MyDocuments\Sheet1 using a button on a form in access 2000.
Obviously when the spreadsheet opens it will re-name itself, and i need
the users to be able to enter data, that if they want to save it will

Does anyone know an alternative way to get the result from a query in
access vba?  I've got a form with a few labels that need populating.
Even if I only need a single value, the only way I can see to get some
of the data is by creating a recordset object and populating it, and

I have 8 tables in Access 2000, 1 Main table (Member Details) then 7
Tables that relate to this table using an ID from table 1.  In all
there are 262 fields in the 9 tables.
I want to design a VB front end that has 6 tabs per record and when you

dear gurus,
I had written one dll file hereunder, just to perform the same actions
on all forms and i can call them from any where, means write once then
run everywhere:

Please help.
GOAL: I hope to calculate a total amount in a TotalQuery (or field in
the SubQuery?), based upon three field amounts in a SubQuery.
STATUS: When I create an expression in the TotalQuery based upon

Our company have used Excel to filter out documents base on date,
from_company, type_of_document, country to generate a list of where
the documents physical location is. The number of records have grown
to 8000 and I think it is time to use Access 2000 to handle those

I have a table with many months of data on it. I am attempting to create a delete
transaction, based on matching a date in the table with a date in another table. The match
works perfectly in a Select Query, but when I change the query to a delete, it asks me to
specify which table ...

Hello world:
Background:
Yesterday, January 21, Doug Steele was kind enough to help me out on a Left
Join problem.  I was trying to return all stores and their Gross Adds for

Does anyone know the record limit for a single table in Access 97? I
have a client who has over 800,000 records in one table. They are
experiencing math problems and timeouts when running reports.
Microsoft's KB didn't seem to have a good answer.

I have several databases that are opened using various versions of
Access and VB.  Up till recently everything worked fine, then I started
getting a variety of lock file error messages, both on my PC and other
computers (both Win2k and WinXP).

I have an issue where I have three Cases that SHOULD act the same but
don't.  If you look at the code below you will see that the general
premise is to open a MSWord template and then use SendKey commands to
get it to save the file using a new name (NewFName is assigned earlier