After installing Office 2007 I opend a Access 2000 database.
In a form I have a Command Button with an Event Procedure on the OnClick
event.
The Event Procedure behind the Command Button OnClick will not be fired.

Does anyone know if there is a WEB site which lists the differences of
MSAccess between the U.S. and Germany?  I have a database which was created
in the U.S. and sent to Germany to be used, but not everything works there.  
Such as a graph which needs to be previewed doesn't work ...

I am trying to set a filter to a form.
Heres the code I am trying to use, but I get error 2001 all the time.
If FilterOption = 2 Then
   Me.Filter = "Shop = '1'"

has anyoene an idea why this line of code crashes my project:
   Set Application.Printer = Application.Printers(0)
I have access 2003 installed.
henry

i am using access to enter and analyse research data. since i need to have a
clean data, am having entered twice by different people so that on
verification i can have the clean data. i can not be able to do verification
to see the differnces for clean up.

Does anyone know how to set the format via VBA on a field (column) in a
datasheet?  The data for the datasheet is set programmatically and depending
on user selection, the field may need to formatted as a percentage or as
currency

why do I get just the sum with Avg([column1]+[column2]...)

I am trying to understand the use of the RecordsetType property.
I place the statement
If me.CurrentRecord>1 Then
  Me.RecordsetType=2

I have a proc that updates a table with users who have missed training. Some
users miss more than one course, so my code concatenates the course strings
so I only have 1 record in my table per user, and it does so in a way that is
like using Alt+Enter to separate text while in a ...

I have created a program is MS Access which allows me to create text output
that is readable by our mainframe (main purpose). This process includes
running cutome queries what are appended to formated tables and then these
tables are output to text. I would like to migrate this ...

I have a StartDate and EndDate field (in a table) for a project.  I would
like to take the year out of the dates and have that go into the field
StartYear and EndYear.  I can get the year out alright, my problem is even
more basic.  How do I get the year back into the table?

Off-line Help in Office 2003 products and VB6 does not display properly
(apparently some undisplayed graphics ... I see box w/red X). And I am
constanly get Internet Explorer Script Errors.
Does anyone else have this problem? And if so, do you know what to do to

I have several one line If - then statements (by one line, I mean "If x>1
then y=x+1") which I could recode as a select case structure.  Is there trade
off  point for execution/memory efficiency?
Code segment:

What is wrong with my code?
Private Sub cmbFilterStatus_AfterUpdate()
  Dim rslt As String
  rslt = Me.cmbFilterStatus.Value

I get an error when running the following :
Sql = "Delete * from " & RecordsetNaam & " IN '" & BackendNaam & "'"
DoCmd.RunSQL Sql
where RecordsetNaam is a table name with a space 'gemaakte offertes' wich I