I have a main form which is linked to a table.  I have also placed a
sub form on this main form.  For some reason I can't control the
subform for example the scroll bars do not work, the record selectors
don't work.  The subform works correctly when opened as a the main

I have a Database which contains anout 20 tables. each has different data.
for a research centre studying Family History.
I want to create a simple from end that researchers can entre a surname &
First name to find their ancestor, this will give them reference number

I have to create a report, that contains in the section body a list of
record.
For every record it has to appear an incremental additional field that
begins from One; when he reaches the record 50, it is had to activate a page

Dear reader,
The function:
Dim refCurr as Reference
refCurr.Name

I am using the following code to display the total of the amount field in
the Position table.
Private Sub txtTotal_Click()
Dim curX As Long

I'm trying to design a database to track projects and the associates
assigned to them.  I have almost no experience with this.  I have three
tables:
  -Projects

I have an application which contains an Access database with linked
tables that point to another database within the application.  The
problem I have is that when the user installs the application, I need
to update the table links so that the paths are correct for the install

I have a form with several subforms.  Users enter the data, then on the
parent there is a command button that runs code to generate a .pdf
document from a report based on the data they are working with.  If a
user enters data in a subform, then directly clicks the command button

I have a form with two sub forms.  The form is set to data entry. The
form is bound directly to a table I have two buttons at the bottom of
the screen.  One button is named reject and one is named accept.  I
would like the reject button to cancel the current entry being written

Hello again,
While I try and solve the calender issue I also have another problem.
I have a form & table (appointments) where the user records
appointments in the future. The fields include date, time and duration.

Using Access 97.
Background:
I have a main report called rptTrustHeader with a subreport
rptTrustDetails in the Details section of the main report.  The main

I have been manually importing a text file on a weekly basis to an
Access table.  The data on one field is about to change (happens to be
the first field).  It was numeric, and is defined as numeric on the
Access table.  Now it will have a prefix of "K", for example:  K00075.

Ok, in my database I have something like this:
Date One
# of Days to Next Date
These calculate a field "Date Two."

I've started a new topic so as not to get people confused. I apologise
for the number of posts i've put on here over the last few days - i
really am trying to learn this stuff but my brain is getting a bit
frazzled.

Anyone knows how to avoid the limit to 36000 records that access has
with a combo box?
Any help will be appreciated.
Many Thanks... Claudia