Can someone tell me why I get an "Application-defined or Object-defined
error" when I run this code?
where objXL = "Microsoft Excel"
intEndPointer = objXL.WorksheetFunction.Match _

With Me.filteron you can filter data of the first table ( company )but ...
how do I filter data based on the third table ;
For instance :
Table 1 = comapny

Can someone please provide the code to change the value in a table using the
following example (Table Name = Data)
Store  SOH SOO
123        5     1

Can someone tell me why I get an "Application-defined or Object-defined
error" when I runt this code?
where objXL = "Microsoft Excel"
intEndPointer = objXL.WorksheetFunction.Match _

I've developed an application in which I export data to Excel with some code
like:
  DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, qry1, xls1
and it works perfectly. Now I have a user who has only the Access Viewer and

I have a simple database that I was working on over the last month. It is a
data entry style MDB right now in the default 2000 format. I work on it with
Access 2003 SP2. All updates applied. I have Admin Privileges. It references
a preexisting 2000 MDE that contains lookups to ...

I'm pretty conversant with using Excel automation from Access, but this
problem has me perplexed.
I'd like to populate a listbox in Access with a list of any Excel files that
happen to be open. However, my code doesn't seem to work:

Good day,
I have a Form that lists the files in a directory. Form Name = Form1
The List box name = List0
I would like to have the an event that onDbl Click it opens the file that

I am using Access 2003 on a system with Windows XP x64.   When going back and
forth from the VBA code window and forms design at random times and without
warning I will get the following error;
Microsoft Visual C++ Debug Library

Good day,
I inherited an Access database which gives the error message "Unknown
function 'Environ' in validation expression or default value on
'tblTable.Field'" when the buttons/functions are executed.

I'm having a problem filtering a recordset and would appreciate your
suggestions on what's going wrong. I apply the filter to the first
recordset, then create another recordset from the filtered recordset.
My understanding is that this should work, but it isn't.

This is my problem, but I lack the programming language/understanding to
accomplish it.
I need to turn a table that looks like this:
field names:        DATE              ABS_CAN                ABS_ONT        

I am attempting to open a form by passing 2 values to the query that the form
is based off of. If I remove the end part of the statement it runs fine, but
if I try and attach the second part it gives me a type mismatch. Here is the
code I have:

I am having problems with the bookmark failing in a subform due to "No
current record".  This only happens when I set a bookmark in the subform and
return to it.  Then requery the subform and try to set another bookmark at
the same location.  

When i try to make an MDE file out of my access database, it gives me the
error listed below.
I really would like to be able to compile this so users won't
adapt/modify/whatever the code by hitting f-11 and bypassing the startup form.