In a Access database I have the following table
Id     Machine       Week           Production
1      M1                15               200
2      M2                15               220

I didn't know where to post this, so please forward me if I'm wrong here :-)
There's an Access 2000 of mine database running in a company. The
manager of the chinese daughter company saw the software and wants to
use it there as well.

I have a ASP.net form on a Sharepoint Site that connects to a SQL 2000
database. When I try to update or insert a record I get the following error:
Server Error in '/' Application.
--------------------------------------------------------------------------------

I have a table with two date fields: one an unconfirmed date scheduled
upto 3 years in advance, and a confirmed date which is entered nearer
the appointment time. I need to be able to run a report showing
either: the unconfirmed date if no confirmed date is entered, or the

I have a primary table that keeps information on Experts.  I have a related
table that keeps the Expert's Speciality.  Each Expert has 1 or more
Specialities.  Each Speciality is a record, related to the primary table with
the ExpertID.  I have a form for the Experts and a ...

Good evening:
I'm not sure what title to use for this post, so I'll try to explain
as clearly as possible what I need to do.  This is for a database of
transit schedules, by the way.

Goooooooood evening,
Im using MS Access 2000. I have FormA and FormB....FormB has a subform
on it called "SUBformB" which is in datasheet view...If a user clicks
a button on FormA i'd like FormB to open up and the Record Selector on

I am trying to make a database for my movie collection. I would really like
to be able to have multiple columns of images (DVD box art) to help me make
my choices. So far, the closest I've come to having multiple columns is in
the print preview mode of a report. I have created a ...

Hi, I've added 6 tabs onto a form.  Although the form itself can be
formatted with different background colors, the tabs themselves cannot
(as far as I've been able to try).  Perhaps there's a VBA code that
will allow me to change the tabbed page background colors?  With 6

Using Access97, can I somehow set a form I have as a subform in another
existing form when I have the typical install and no install media? When I
try to follow the Help system procedure it errors saying the necessary
Wizard is not installed. Is it possible to do it by other means?

I tried adding some fields to a form and changing a few things but now it is
blank when I open it. No fields, labels or anything. I reimported the form
from the previous version but it is still happening.
Any ideas?

I need validate that there are no more than 3 dots anywhere in a text
string. If there are at least 3 then there needs to be an error message and
the information gets cleared from the field.
Cheers

I am using a simple addition calculation in Access 2007 and it will not show
the result. Simple form based on a single table field 1 and field 2 with a
following unbound field with the control =[filed 1] + [field 2] after
tabbing through field 1 (all formatted as currency) then ...

I created a new form using 2 tbl the form allows for viewing but will not
allow me to change any data on the tables. also non of the drop downs will
allow selection of the information. did I forget something? how do I go about
fixing this.

I have an option group with 3 radio buttons. I now decide I want to convert
to independent checkboxes and have the border be a rectangle not an option
group. I right clicked but there is no 'convert to' option. when I select the
option group, and do delete, it deletes all my ...