I've written an utility that enables me to send SMTP mail from MS
Access using DDE and a custom VBA object.. I've got a client who is
unable to install the utility due to company policy.
I'm looking for some example VBA code that that can be used from within

Hi again,
This time i have an excel file stored as a OLE object field in a table,
and im trying to export it as an excel file as C:\Temp\template.xls.
Ive tried several ways of doing it but none seemed to work properly,

How do i change the whole databse to readonly thru code.
Thanks.

I have an Access database that was designed with Office1995 version.  It has
a Sub which has array in it and it doesn't seem working with MS Office 2002
XP version.  The program is a bit long but basically it is like this:
(the following Sub is called by another Private Sub)

How do i change the whole databse to readonly thru code.
Thanks.

How can I, without using Replication technology, append a table in my
master database from data in another database? I have several field
offices with sales data that I want, on demand, to append up to my home
office Master database... any ideas?    Thanks!!!!  Dav

What is my best option for enabling users to copy and paste an entire
recordset, but allowing them to change the value of the "one" record in a
series of one-to-many relationships?
For example:

I use this line
DoCmd.SelectObject acTable, "tblAdmin", True
when I want to display database window. Often-
times, working on a remote mde via a TCP/IP

-- previously posted on newsgroup ::  <microsoft.public.access> --
Has anyone else noticed this behavior?
Focus jumping from current cell to upper left in embedded datasheet.
If not, would you be willing to test your environment and report back?

I am using MSACCESS 2000
I can hide Tables from appearing in the Database Window with the following
code:
       For Each tbldef in MyDB.TableDefs

I have a table "tblSprayApplication" in a project for a nursery. Each
record refers to a single spray application across the nursery,
recording which groups had been sprayed. Multiple applications (in
different parts of the greenhouse) can occur targetting the same set of

I found the Access reports too limited to do what i wanted so i created
a module to export a crosstab query to an excel file, and then i modify
it as i want. My problem is that i created a unique query for every
"sector", saved them, and select the right one according to the user's

I have a Continuous form in Access 2000. The form contains a date field
and the user has requested( demanded nicely) that they want the date
field to be yellow if there is no data in the field. Does anyone know
how to do this?

Am trying to open an Adobe .pdf file from Access2000.
I use the following code:
Shell "C:\Program Files\Adobe\Acrobat 6.0\Acrobat\Acrobat.exe /c start
C:/Temp/Circulation summary.pdf"

How would I put dashes into a number? I have numbers like 1233450983 that
need to have dashes in them like 1-2334-5098-3. How can I add the dashes in
an update query?