I had posted a question on SQL syntax error, unfortunately Im still getting
the the same error even after correcting it as advised by Mathias Klaey and
John Vinson.
What could be the other problem?, should I re-post exactly what Im trying to

There is a very long delay between my typing and the text showing up on the
screen.  This seems to go along with a very long delay when I send something
to the printer (at least 5 minutes).  Thank you very much.

The database that I have developed, is used by others
running Access 2000 run time. The problem is that if there
is an error on start-up the database brings up an error
message and then closes. This is because the

I have been tasked with organising our digital slide library. I believe
Access can do this but need some advice. Is this using by using OLE Bound
Objects

I am trying to auto sync db schemata (in access, among other databases).
Means, there is a C# application that generates SQL for generating schema
changes in the access database.
I am stuck with two problems:

I need a (hopefully free) way to track donations to a non-profit.  Ideally,
this would allow me to enter the "giving unit" (donor), and then post further
donations without entering all the info again.  And, I would like it to then
auto-gernerate a printed receipt that included ...

I have to develop an access app that records commissions for selling
maintenance contracts. I started with a simple sales table but quickly ran
into trouble because sometimes the commissions are paid in full at the time
of the sale, and some times they are paid over time as long ...

I want to follow an individuals medical contacts and treatment from the onset
of the injury over 3 years.  What can I use to set this up for several
clients?
Julie

I want to make the field names in the table I am working on wrap through two
lines.  Is this possible in datasheet view?

I've been reading past messages on calculated fields and realize the general
advice is dont!!... However I need to hold a nominal ledger code against a
record which changes according to branch and charge and which should change
if the branch of department is changed. ie the ...

How do I change a field of text datatype to number, long int datatype, where
all the values in the text field are numbers (within the range of long int)?
I have a field that I evidentally made a text field, which contains all
integer numbers, representing the ID codes for people, ...

I am trying to combine data from two columns to create a unique ID that
populates a third column.
Ex. Auto number field + Company Name = LocationID

MY TABLE IS SET UP TO PRINT TO A WORD DOCUMENT.  WHEN I PUT IN FIVE DIGIT
PROJECT NUMBERS AND CLOSE OUT OF ACCESS THEY DISAPPEAR.  WHAT AM I DOING
WRONG.  WHEN i USE FOUR DIGIT PROJECT NUMBERS THEY SAVE.

Is it possible to combine insert statement with one known value and one
returned by select statement, eg.
insert into Table (u_id, dep_id)
values (2354, select dep_id from Department where dep_id = (

I have no experience at all with datatabases, but now I have to manage a new
access database with 3 tables A,B and C.
Tables B and C are updated with new data on a daily basis and once a week
all the new data should be exported or consolidated to the table A.