I have a button on my form that will delete a record.  I then need it to go
to the next record, if there is one or the previous record if there is one.  
If not a previous or next record, close the form.  The following code has
been unsuccessful.  Any help is appreciated.

I have a form with subform and I need to add spell check button.
How to begin? what to do?
TIA,
   Tom

Hi,
How can I disable the warnings in executing a make table query? I have a
command button that executes the make table query with the following code:
CurrentDb.Execute "qryRODetailTempMake", dbFailOnError

I'm new to Microsoft Access, and I've been having a few frustrating
problems. Today I'm wrestling with a main form that has a number of
subforms and an #Error that appears in one of the subform controls ONLY
when the main form is first opened and ONLY if a particular control

Hi,
I am trying to update a record in a different database to the current one
that I am using. I wish to update the Job status field to INSPECTION COMPLETE
in the other database. The problem that I have is that I only know how to

A2K
I have four unbound controls that I am using to give the user a summary based
off the Task List. An example of one of the controls would be, how many Tasks
matching today's date. I am doing this by using an IIF statement in the

Hey I am trying to take the functions I have in excel and try and
import them into access. I can only import the data. Is there anyway to
get the equations I have in excel and have them transfer or convert to
access?

I want to set a field (docId) value to be equal to: two Letters + year +
incremental number.
Ex: VD20061; VD20062; VD20063
I have the fowling code for the letter and for the year:

Hey! I am kinda stuck here with a database I'm doing. I am using VB code for
som calculations. An error is coming up saying, "CANNOT JUMP TO
'txt_Interest' BECAUSE ITS NOT IN THE LIBRARY 'Q:..........'  WHICH IS NOT
CURRENTLY REFERENCED.

I have a membership database and I use combo-boxes to find member names for
various different tasks.  I have set up an option to "sort" the data by
Member name or Membership Number, but I have done this using two different
queries which have different columns and sort orders.

I have cmd button on a form to print a report.  If am mailing the report, I
do not want to print the first page of the report.  The user selects whether
the report is faxed or mailed.
I can use the PrintOut action but need to make the report the active object.

I would like to include a like statement in my combo look up filter.  This
is what is in the criterion now:
[forms]![frmSearch]![cboStreetNames]
This is the SQL I've used in the past, it works great but I would rather use

I am designing my own contact managent database and i have changed some of
the auto columns to my own heading but i am getting an error code(little
green tag) i have tried all suggested ways of removing the error code but to
no avail... am i doing something wrong and can any one ...

I am building a database that tracks a dealership's current stock and sales.
Units are added as records to a table called "StockUnits". A "TCA" is created
to negotiate a deal with a customer. An "Appraisal" for a trade in can be
attached to the "TCA". Multiple TCAs can be created ...

Is there are way to count distinct values?
For instance,
If DCount("Distinct [Current Auction #]", "tbl_Ordering_File_Edit") > 0 Then
Thanks