In my project, there is a repeat procedure.
In each procedure, I get a value and with the value I will get the
description.
To do that, I coded a simple procedure as following

I'm struggling with having "no current record."   I see a row or rows in the
form in question (this happens to me in a variety of forms), but the code
associated with the form detects "no current record."  I've asked this of
this forum before and various suggestions for testing are ...

I'm currently studying for an ICT a level and for my c/q i
have to develop an ict system.  my chosen system is to
create a time/data management system for a driving
instructor.  I have choosen to use access (XP).

I am trying to print a set of 42 reports that are all
linked to create one document.  I have a database where
data is entered in Forms, and the Reports emulate the
Forms.  When I run the application, the Forms have data,

This database is in most respects after-the-fact recording of employee
attendance at a training event. Many times the user will have to create the
training event record in TblTrainingEvent and then record his attendance at
that training event in In TblTrainingEventAttendee. In ...

Hello, I believe this is a pretty simple question but I can't seem to find
an answer in the help file.
If I have a field called PhoneNumber and I want the default to show the area
code like:

I want to put a button on my form that will allow a Delete
Query to run, but when the list from which to choose a
query displays, the Delete Query isn't there.  Does anyone
know of a rule that does not allow a Delete Query to be

I have spent hours trying to select a count.
I have a table with 3 of the ten columns containing a
student id, a year and a school id.  I am trying to
create a report that will list each school, year, and

Does anyone know of a way to diable the main database window and the table
tool bars such that they are hidden and users can't simply push the
Database Window button and it'll show up?  Thanks!

I'm trying to convert a flat CSV database into a normalised Access
database.
I've imported it into Access and want to replace the field 'Categories'
with a field 'CategoriesID'.   I've run a query on E-listing (the table

I have a list in my database that contains the date in the
following format. 07/08/2001 The data was created in excel
about five years ago and then merged into access. The
dates are sorted by the day and month.

I have a form that has a subform that has a subform.
The subform loads a record based on a combo lookup box in the main form.
I'm trying to set a value in the subform based on a value in a subform of
the subform.

I have 2 tables:
One is inventory: Part_number, Amount_in_inventory
The other one is reservation of the part number (orders): Part_number,
Start_date, End_date, Quantity.

Assume that I have a large taxonomic list of animals.
Column A is the common name.
Columns B to G contain the appropriate Kingdom, Phylum, Class, Order,
Family, Genus.

Until I changed to Access, I had been using Paradox to
maintain a mailing list of about 17,000 names that in
generated about 3 times a year.  When I got a returned
letter, I marked a field indicating that address was no