I have an access application that works on my computer and on another
coworkers computer, but doesn't work on other peoples computers.  
Does anyone have and ideas?  I've check their office service pack and it's
the same as mine.    I doubt that it's the code which I have copied ...

I'm trying to read the security groups associated with a file on an NTFS share.
I tried ...
Set objFile as Object
Set objFile = GetObject("I:\myfolder\myfile.xyz")

I have a routine that creates a compressed file using:
   Open "path to folder/xyz.zip" For Output As #1
   Close #1
This works perfectly fine. The xyz.zip file is created as a compressed file.

Anybody here that have a running / tested code that can determine the time
difference.. For example: an employee timein: 11:30pm and timeout: 2:30am  
the difference must be 3 hrs...

Using Office 2003 and Windows XP;
I have a DB on which I just finished initial development and it tests well.
During development, as you might suspect, I created forms and deleted forms;
created tables, and deleted some tables as the concept was perfected,

I have a procedure that takes SourceTableName, and DestTablename arguments
and creates a table matching the field structure of the table represented by
arg1. I use ALTER TABLE to add some standard fields to the destination table
if those fields didnt exist in the source table. ...

I have this problem.
This is the query i want to run as part of a little batch routine I wrote:
UPDATE tbl_SAP_PRICELIST SET MatchID =
Left(Trim(MatchID),Len(Trim(MatchID))-2) WHERE (((Trim(MatchID)) Like '*AA'

I have a form with not updatable controls. Can i however delete rows in the
table referring to the control clicked on the form ? For example, in my form
i have a productid = 76. Could i clicking this control  delete the productid
= 76 from the table products1 ?

I am using a string name to refer to a field in a table.  When I plug it into
the code, it is not being recognized as a field.  I tried to use a Field
object, which also didn't work.  Here's the code:
With rs

I need  to refer to a bound value's lookup value (in VBA, but also in
expressions).
For example, there are two tables: tblProducts and tblSalesDetails.
tblSalesDetails has a lookup to product names from tblProducts. I want VBA

Good day people.
I need to run a macro (to flush tables)when the user closes an Access
application. I tried trapping the main form-close event but it appears
docmd.quit bypasses my form.close code?

I am new to access and trying to create database for my patients. I have an
access 2000 database that I created using access 2003.  In this, there is a
table called PATIENTS that contains fields for basic information about
patients (ID, name, age,...). The database has another ...

What am I missing here? I'm trying to determine if the recordset returned
from a dynamic query is empty, but it's always returning empty even when it
contains records. Is there a better way to check for an empty recordset?
'decs snipped

I am using vb code to track user names and log in times with the following
code found in this forum:
Private Sub Form_Load()
   Dim t As DAO.TableDef, texists As Boolean, Curr_Usr As String

I've got the following code:
Private Sub PO_AfterUpdate()
   Dim cn As ADODB.Connection
   Dim BArs As ADODB.Recordset