I have a client who is wanting me to develop an Access DB or VB app
that is basically a fairly simple call tracking system.
They are expecting approximately 15-20 users, and possibly about
25,000 calls per year.

Here is the code up to the relevant point. When I try to obtain
rst.edit, I am only offered rst.editmode
Dim DB As Database
Dim RST As Recordset

I'm trying to create a simple data entry database that has yearly /
monthly forms for which I want 6 different update fields.
I have a tbl_Projects which is the main form. This holds the fields,
ProjectID (PK) and ProjectName.

SInce about 1996, I have been happily using MS Access for Windows 95,
but would now like to upgrade to a recent version. If I get a Windows
XP version, will I be able to import all my Access 95 files without
problems?

I need a little guidance here. I have set up a table for job estimates with
a large number of data fields. On the estimate form is a command button to
convert the estimate to a scheduled job. When the user clicks the button I
would like to copy certain fields and paste them to ...

this is probably very simple but I don't know.  Is there a way to
prevent two people from signing
on to an Access Application using the some login information????
I can't have two people on the application at the same time with the

just really want to know if someone can help me with a query.
I have the following table
[item code]              [product name]             [entered
date]         [obsolete]

Is there any way that individual words or phrases can be formatted
within a memo field? Obviously, the whole field can have formatting
applied but I'm interested in being able to format just part of the
field. This will be in a report

I was wondering if anyone could help me. I have an access form with
tabbed pages on it. I would like the colour of the tab name to change
when a user inputs information into the fields on the page, i.e when
they start a new record all the tabbed pages have their name in black

I have a form that I have subforms in.  I have set up relationships between
all tables for cascading delete so that once I delete from the main table it
should delete the entry that shares the relationship in the other tables as
well.  It's not.

If the RecordSource for subform SF on main form MF
is a query and I change one of the field values in the
subform control from 75 to say - 13 and click on another
record, the value in the underlying table is changed. It

i encountered a little problem. bear in mind that i am an amateur in
this access thing so... Anyways, here is the problem. I have a text
field in which i would like to have an auto-incrementing combination
of text and numbers. for example, i would like it to say "Working

I have searched high and low for a sample for this, and I just can't
find any.  Sorry for the length!
Background Information
The issue revolves around setting up a system-generated increase in

I have problem of coding the parameter query which does a cumulative sum of
quantity of  a group of same chemical item. I get error "Too many parameters.
Expect 1".  If I were to remove the parameter from the Query2  QBE criteria,
these codes work fine.

I'm having the following problem. I have a table that contains
information about books people read, i.e. each row has two columns,
people id and book id.
I need to do the following query: retrieve the list of all people that