I am writing a DELETE statement and I want to filter the records using
another SELECT statement.
My SELECT statement is a GROUP BY query that grabs all social security
numbers from the "Data With Import Date Current" table on a given day

Please help, i'm baffled.
I have opened my db and recieved an error on this code which starts the
switchboard. As i didn't write this code i'm baffled, and I don't think
I have made any changes to it.

I have three combo boxes on a subform.  I have tried setting them up so
that when the user clicks in the combo box the curser moves to the
left.  I have searched the posts and can find nothing that answers my
problem....no matter what I have tried....on click, set focus, got

I have an Access application and I would like to not only run an external
application, but at the point in the code where it is run, I'd like to wait
for the external applicaiton to finish, then run the rest of the code.
Is there any way to do this?

I am designing a database to handle different kinds of products ... and
these products can have different properties...for example, a trouser
can be specified by the width, length, color, and other additional
properties...while you might need only one property for another

I know that an Access-FE (frontend)  can use a BE (backend) from another earlier version.
Question: Are there any caveats there when doing so??
Situation: I still have an old Access 2.0 !! application (FE-BE) that workes a charm.
This app is in use for about 10 years now. Still ...

Anybody know syntax of sage line 50 query?
how can I write sage line50 database conidtion sql query?
when i write this syntax, get error msg of column not found.
'SELECT c.stock_cat_name, a.stock_code, c.description, a.date,

Is there a way to sort/group a report based on the second column of a combo
box, i.e. the text associated with the primary key number?

iCalendar is a standard (RFC 2445) for calendar data exchange.
I plan to transfer data from iCalendar files (extension .ics), to a
linked Outlook calendar table. While Outlook (2002) has an import
strand for this, it does not seem to work with the format I shall be

I'm calling a stored procedure on a sql server from an access
application.  I just need the stored procedure to run I do not need any
data returned from the stored procedure to my Access application but I
do pass parameters from my Access application.  What I have works fine

I have a pivot table feeding from a query, feeding from a table.   My
number results are coming out with 9 places after the decimal
(1.683333333).
I would like to have it round to one or two places.   I have gone into

Any idea why this would happen?

Anyone here with experience with using electronically signed documents
and Access?  My client has some documents which must be signed and
retained.  they are interested in using electronic signatures.  It seems
to me that I could take a document in an Access database, print it to ...

I have an Access 97 report based on tables linked to an SQL back end.
The report has 5 subreports in it (unfortunately unavoidable due to the
nature of the report) and performance is quite slow.  The query runs
quickly and the report displays the first page in a short amount of

Hey all,
I created a Query (in Design View) which asks the user for an "As Of
Date" which would
then display relevant data. I put [Please enter As of Date] in the