I'm teaching in a lab with two versions of Office and Clean Slate on all of
the computers.  Access is not behaving well in either version -- can't use
the Form Wizard or do command buttons in the 2003 version, and opening but
locking up as soon as anything is clicked in the 2007 ...

Hi, I set up a database for recording quality issues, the main input form
requires that you  enter the details of the issue and enter the date the
issue occurred, is there any way you can count the number of records that
have been entered between 2 dates ie the first of the month ...

I have an access table that stores a customer's balance for xx months.  I
want to run a query that will pull the last month's balance.  However, one
accounts last balance could be in December while another accounts last
balance could be in February.  I just want to pull the Last ...

Hi, I have been using transferspreadsheet to
import a named range from Excel.  Unfortunately,
as so many have discovered, this results in import
errors if the 26th row contains a text value and

Hallo Peter,
..na wie geht es dir ?  -- wir hoffen gut !
..wir wünschen dir recht gute Besserung; Geduld und Zuversicht.
..und wie Jack Nicholson zu seinem 70. Geburtstag gesagt hat:     "Ich

Could someone give me a brief discription of how a N-Tier system could
be setup in a Hospital Wan

now i'm doing a system using access 2007. i want this system can detect who
is the user was changing the data. due to this system was using by many user
and in their own pc. but the data is keep in the server. in their pc is jus
hav the form n the report. so now if have an user ...

In a report I have a calculated field that calculates the average of 3
fields:
=([Field1]+[Field2]+[Field3])/3
However the division factor should not always be 3. When for instance only

Good day.
We are using a legacy Access 97 db and are accessing this remotely via a
network share mapped drive.
I will refer to the access server as the machine hosting the access db and

I have database that I put it in shared folder between two PCs, but when I
try to open this database from the other pc it gives me the following msg:
Microsoft Access cannot open this file
This file is located outside your intranet or on an untrusted stie.

Am wondering what are the key parameters that would make the decision between
Access vs SQL Server.
Clearly if one is going to exceed the Access size limits.
Given security direction of Access07 then for a new install security itself

I have several Access databases that are in 2000, 2002, and 2003.  I have
recently been upgraded to 2007.  When I open any of these databases that were
created previously I am unable to open forms and reports.  It tells me it
cannot find the Event Procedure.  There is no code ...

I have an access db that as several tables. I want to create one table
(or file).
The tables have keys. Some tables might not contain information for
the keys.

I have a query that ran in the previous version of access but fails in 2007.  
The error is with a function - "cusip_wo_dash: [Left$]([cusip_id],6)".
The error message is "Undefined function 'Left$' in expression".  I tried
removing the $, but get the same error.

I have a database which is in 2003 format & is password protected. when I
tried to convert it to 2007 format, it tells me that I should open it
exclusive to remove the password, which I did. When I try to save it in 2007
format it tell me  that it can't save it as it is open ...