I use an Access-form to write into an external Oracle table via Oracle-ODBC
driver.
It is not a read-only connection, and batch autocommit mode set to "all
successful statements".

I've got everything in 2000 format right now, but it's now clear that all of the
clients will be running 2003.
Is there any advantage in converting?  

- Open Access 2003
- Create new database (2000 or 2002/2003 format)
- Create a report and insert a label in its Detail section
- Save the report as Report1

I have 2 multi-list boxes, 1 displays course categories based on a
table called CATEGORIES.  This table has 2 fields CATEGORY_ID,
CATEGORY_NAME
The other multi-list box displays courses based on a table called

Hi all, anyone know how I can create a currency table from a website with up
to date exchange rates .
the system I'm working on needs to store the exchange rates (compared to
GBP) every month on a set date.  Each month the exchange rates need to be

Is it possible to prevent the addition of new records but still be
able to edit existing records on a form?

We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC
linked tables. I recently created a new set of tables for the app, and users
are complaining that unsaved data is being lost when they move to a new
record. This seems to be the case when there are multiple ...

I'm a newbie to writing and running code in MS Access so the more
detail the better for me when answering. Thanks.
My Problem ( Or Challange , I should say ) is that I import a csv file
into an access table called 'booked' ; one of these fields is called

If I have a form where the RecordSource property is set to the name of a
table, then on opening the SingleForm form I can cycle through all the
records in the table one at a time via Next and Previous buttons on the
form.

I'm using a tabControl on one of the forms of my MS Access database. The
grey bar looks pretty bad on my form.
Is there any way to change the colour of the tabs or the tab background for
the tabControl in MS Access? I'd even resort to an API call if necessary.

Anyone know the difference between the 2 and/or what the different
combinations of them produce.
Thanks
DS

I have a form which displays data in 3 related tables.  I want to give
the user a prompt to save changes when any field has been modfied on
the form.
Is there a easy way to do this so the 1 or more changes to a field can

Anyone know a good control with text going from the top to the bottom.
Kinda like
S
P

I have a table with a student id and course id.  I would like to make
both fields the primary key since a student can have multiple course
ids but I do not want duplicate records.
How would I go about creating the multiple field PK in Access 2003?

The code below fails on the first Execute.  Can somebody please tell me what
I'm doing wrong?  I'm going to base the results in the table
TrainingModulesNotTaken for a report, otherwise I'd use recordsets for all
this.