Hi I want to connect to a data file that has a database password "hello"
I can manually link to a table in this database and using the debug window,
Debug.Print tdf.Connect returns
MS Access;PWD=hello;DATABASE=T:\DHLdata.mdb

Seeking code/examples, etc. for:
* Employee is registered for a company training class in Access 2003 (I have
this).
* As part of the confirmation, an appointment is created in the employee's

Want to cycle through all the tables in a database using:
Dim MyTable as TableDef
For i=1 to tables.count
or

I have a status field which is auto updated via query.  I want to stop users
from changing any data on sub forms (datasheets) when the status is changed
to Completed.
I have tried the following code but with no luck. This code has worked on

I'm using a Composite Key of 3 indexes and am using 3 ComboBoxes to input.
But as I'm putting in new data into the fields I would come to the last
ComboBox and then I would have the message of that this record exist from
before (I'll have this message: "The changes you requested ...

This may be a dumb question, but other than closing and reopening a
resordset, is there a way to get Access to point to the first record again?  
My code is adding records to a temporary recordset, but I have a test that
only works when it is looking at the first record.

The errror I am getting when I try to Quit Access from VB or a macro is
"Cannot find the file ‘C:\qbxl\Newfrom Paul\LabCst\labcst.mdb’ (or on of its
components). Make sure the path and filename are correct and that all
required libraries are available"

I have developed and Access set of programs and wish to run it from a file
server enviroment.  When I start the application from a workstation I get a
message that the database is read only. I have the correct mapping, the file
is shared and the permissions are ok? Does Access ...

Windows XP, Access 2003
I have a link to a text file that I want to adjust the file location based
on user input. This only works in the TransferDatabase command for the
following (according to help) databases.

Re: Access 2003
I learned recently that writing all vba code out in modules and referencing
form objects out there is better as opposed to the code residing inside the
form object in order to protect your code if your objects should get

I am trying to link oracle tables from an ODBC database to access in VBA
code. I have a small problem though, some of the tables do not have a primary
key and I keep getting a prompt to "select a Unique Record Identifier". Is
there a way to programmatically select all the fields?

I teach computer education to children aged between 6 and 12. I am having a
problem when we use action buttons in PowerPoint 2007. The children place a
blank action button over the words/picture that they want to "hyperlink" to
another slide.. They then are formatting the shape ...

Hi, I am really new to Access and Word (2003)
I want to mail merge but for some reason it is not filling in the << Name >>
all the fields.  What I want is to automaticly open the word document (this
works) and to automaticly populate the fields (this is the problem).  This is

I need to replace the 1st "." in
"PartnerContract_clintonherman@yahoo.com.csv" with "_". Or I need to remove
it completely. This is a filename that I need to import, but this period is
causing the import to error out.

I've got a baffling problem with a particular ADO recordset in a
database I've been developing for the last 6-7 years or so.
Here's the setup:
I'm in the process of optimizing a very large MDB frontend.  Compacted