I'm debugging an app that has a Reference to Excel 9.0 (i.e. Office 2000's
Excel).
A guy who is trying to test it for me has Office 2003 (Excel 10?  Excel 11?)
installed on his PC and the most I've gotten out of him so far is that "There's

I have read last news, but not found same trouble ...
I have a form with subform control used to put in some report-querys  ...
for example:
Private Sub List0_AfterUpdate()

Hi
We are currently upgrading from access 97 to office 2003 on site. We
would like to upgrade our access databases to Access 2003 but we wish
to remove Microsoft access software from our end users so that we can

i need some help again
i have a form
based on a recordset
Private Sub Form_Load()

If I have two compatible tables, but in two separate databases, can I append
the records in one table onto the records in the other by code in either a
module or a form.  If the two databases were DbA and DbB and the tables were
called MyTableA and MyTableB, what would be the ...

I have created a report based on a Crosstab query
the crosstab query is based on another query
problem i have is that the results this month may be different next
month

I'm currently working on a payroll database, and it has a form that is
used to make payroll adjustments (overtime, vacation, etc).  This
particular form does not work on my computer.  When I enter in some test
data,  and then hit the close button, I am given the error message

Does anyone know of a way to create import/export specifications via code? I
want my users to able to create a table when needed but in order to allow
importing into and exporting out of I need these specifications in place.
I'd like to have it automatic somehow, possibly through ...

I have been trying to get a chart built on the fly for a report for
about 3 days.  I have tried multiple query formats, table references,
etc and I keep getting the same problem.  The chart will only show the
count() of a field.  Yes I've tried selecting SumOf(), but this returns

I'm using A2002. I go into Page Setup, then page, for a report. In the Size
drop-down, there is a selection for User Defined Paper Size but nowhere for
me to enter the size of the paper (as there is in Word). Am I missing
something? Thanks -- Mike

I have a subform with two list boxes on it.  The first listbox has a
SQL rowsource that builds from one of the tables that lists multiple
work skills (ex - Word Exp, Excel Exp, 10 Key).  When end users double
click on values in the first listbox it creates a new record in a

Hi there, i'm doing a databse right now and i want it to be secure,
about 20-30 people (max) will be using it and it will be on a SQL
server.
My first question: I saw some web page about adding password to the

Background: Access 2000 running on Windows 2000, Did not design
inherited (three previous database maintainers in last 18 months),
Non-existent comments for existing code modules and objects, six
users on LAN, BE on shared server.  Each user has own FE to allow

I'm sure I saw this somewhere, but I'm not finding it now.  I'm using Access
XP.  Some time ago I decided to go with DAO instead of ADO.  Earlier today I
found a very cool article at The Access Web at
http://www.mvps.org/access/forms/frm0047.htm about having the background

I have a Surviellance Incident reporting program with a SQL Server 2000
backend and I want to have a Access 2000 front end. My boss wants me to
use ODBC to connect to the SQL backend. I set up the ODBC data source
but I have no idea how to connect to it using ODBC. The literature ...