The following function works great on my desktop but does not work on any
other computer that I use it on. I have verified that the directory tree on
each computer is as required in the function and that the file does in fact
exist in that directory but I keep getting a "File not ...

Currently we have number of queries in an Access mdb that we run to update a
couple of SQL tables. The problem is that all the queries must be run and in
a certian order or the updating is not correct. The process is subject to
human error. My thinking was to combine all the ...

I have a form that a user picks date criteria and then clicks a command
button to update the query, verify that the query returns data and if it does
return data export the results to an Excel workbook and generate a pivot
table.

I have a corrupted record in In my Access 2K mdb file.  I have tried to
compact the file and it just hangs up.  The compacting bar continues to show
and the databse container comes back up on the screen.  It does create an
db1.mdb of exactly the same size of the corrupted file.

Every time I try to run the following code I get "Compile Error   Label not
defined"
Private Sub cmdShowDetails_Click()
On Error GoTo ErrorHandler

I have a routine which builds a form, adding CommandButtons depending on the
entries in some table.  I built a class module KWButtonClass which has the
code I list below.  It's supposed to run whenever a button on the built form
is pressed, but the Click Event isn't firing.  ...

I have an unbound form designed to take a part #, break it down, and tell the
user the specifications of the part.  strConfigCode contains a single
character that is a key value in a lookup table.  I'm tyring to get a
description (in the field ConfigurationCode) from this lookup ...

Am trying to add a Default value to an unbound text box.  The value appears
in the box but is not added to the properties sheet for future use!!  
code is :-
           ...........

I have an application developed in ACCESS 2000, distributed as a .mde. We
distribute the app with the ACCESS 2000 Runtime. Needless to say we have had
many clients that have moved up to OFFICE packages higher than OFFICE 2000.
The problem is that we just had a client move to ...

A botton is pressed which brings up a seperate form to allow the user to
enter some text. The "calling" code waits until a button on the "seperate
form" is pressed before continuing. Whilst waiting it chews up huge processor
usage. Any suggestions.

I have a VBA procedure which sends an email.  This procedure was running
fine when I was on Windows Professional 2000.  Last week I was upgrade to
Windows XP, and now when I run the code I get the following error message:
VBA Error #429: ActiveX component can't create object

ADP in Access 2003
I would like to create a module to set programmatically the following
options existing in
tools/options tab view:

I'm doing a count on a table and it's not got the criteria right. It's just
doing a count on the whole table.
strSql_count = "([SDNTCWRK.UNIUCASC] = '" & Uni_UCAS_Code & "')" & _
                    " AND ([SDNTCWRK.INTRNCOD] = '" & Dep_Code & "')" & _

I figured out how to have Access send an email, but now, I want to enter some
info into the email from text boxes on the form that has the button that
sends the email.  Here's what I want to do:
 1. get recipient name from a text box

I have a database with a table that has a field that contains a site "start
date" which is a date in the future sometime.  In the meantime, it's status
is "Pending".  When the current date is now >= to that site's Start Date, I
would like the database to send an email to me ...