I have a main preprinted form that has a front and a back to it.  The front
and back of the form require some data fields to be printed on it from the
main table MainCatTbl = Field PriCat .  There are two blocks on the front and
on the rear of the form.  The two blocks on the ...

I have a database for people to book on to courses that we run.  One of the
tables is course Instances eg Course name Course Date Course Time etc.  I
would like to create a Macro that I can add to a button that willl check to
see if the course already exists in the table is there ...

I have a table that allows me to look up a cost factor based on 3 criteria.
So the table has 3 foreign keys and another column that contains the cost
factor.
I am trying to design a  form to maintain the cost factor data. So what I

I am sorry to have to post again.  But I have not had any luck with
Conditional Formatting.  I have tried: If isnull([Date field 1]) and [Date
field 1] Is Null, "", Not Null, etc.
I have two date fields.  Date 1 and Date 2.  I have a condition set for date

I have a bound textbox on a form and the control may contain large number of
chars from a table. My method is to set its Can Grow property, but it doesn't
work.
How can I handle it?

  Okay, I'm kind of a newbee to Access. I'll try to explain what I've done
thus far and
what I'm trying to do.
  I've put a combo box (named: Artist1) in a form (named: Artist2) and I've

I have a form in data sheet view that I am trying to open from a
switchboard. So while opening the firm directly opens it in data sheet view,
opening it through the switchboard button opens it in a Single Form view. How
can this be fixed?

Hi, I have a consult in a form, but went I open the form I have the first
register in display, I can move backward and forward, but if I try to use the
option I created to bring a specific record (Typing the ID and click on a
command Buttom) and show the description, basically ...

My table has 3 fields (DivID, DivName, DivCode).  I made a query based on
the same three fields, sorted by DivName ascending.
My form is based on the query and has a combo box for DivID(0 width) and
DivName.  As desired, the combo box displays its DivName records in alpha

I am sure this is a common question...but I could not find the answer.
I have a form where purchases are recorded (stock table) and it has a
supplier name field, with additional supplier details such as address
below all stored on the (supplier table).

I'm hoping I can even explain my problem!
I have a table of SubTasks and a table of ESLOCS.  I have a query
qryLatest_SubTasks (based on the latest SubTask date) and a query
qryLatest_ESLOCS (based on the latest date the ESLOCS were entered).  The

I wish to set a default for a text box based on the current month and year
but I wish the month to be in UPPER case, for example MAY-07. I can get the
date but can't get the month to be upper case. When I try and force this in
the format property, it changes the mmm-yy to be in ...

Access 2000.  I need a to assign an Audit number that is alphanumeric and
partially auto number and partially assigned by the user.  Example: Audit
Number:  01086AB07  The first two digits of 01 is the first audit, which
will advance one number automatically for each audit ...

Hi, I am trying to run this code and I get an error in this line of the code.
Set rs = db.OpenRecordset(vSql, dbOpenDynaset)
The error is:
Run-Time error '3061'

I have a patient database.  My main form is based on my patients table.  A
subform on my main form has Pt. location which has the fields Area, Room
number and bed number.  How can I set something up so they can search for a
patient by room number?  I don't want to use any code.  ...