In:
http://groups.google.com/group/comp.databases.ms-access/msg/60d7faa790c65db1
james.ea...@gmail.com said:

I am looking for the best way to store images in a Access DB.
My Idea -
I have a table with 150,000 records. These recoreds represent a Crash
(Traffic Accident).

I would like to do something like this using VBA in MS Access 2000:
Me.num = "SELECT MAX(num) FROM mytable;"
How does one do that in MS Access correctly?   Aggregates in SQL are
SUM, MAX, MIN which return only one value.*

I create a form with three buttons in MS Access 2000. They are Open
Excel Template, Save Draft and Save Final. When I click the Open Excel
Template button, the Excel template will be opened. Inside the Excel
template, I have assigned a draft watermark to the Print icon. When the

Hi Folk
Is there a way to disable the close button for an application?
Thank you
- Nicolaas

I have a question based somewhat on:
http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/ddde99
2b84f762bd/152bbc027bf00720?hl=en#152bbc027bf00720
A local table works well as a poor-man's repository for public
variables with simple 'Types.'  What are the ...

I have a tab control, and I want to highlight certain fields,
determined by their values, when a record is selected.  I originally
used 1 form and used the On Current of the form to set the values.
The On Current does not seem to work with the tab control and I can't

I'm using Access 97 (don't ask) for a project.  I have a search form
that will then return results to another form.  I need to see the
results in this type of format:
Project     Date          Equipment

SQL Beautifier
Just came across a nice website for making !ugly! to !beautiful! SQL
strings
http://www.sqlinform.com/

I have A97 and A2K on my computer at home, on which I do volunteer
work for several databases on our county park system.  One of the
clients uses A97, and the rest, A2K.
    The A97 user is considering upgrading their Microsoft Office.

A2003.  Specifically, I'm looking at MS Graph, but all I really want to
do is have a button in which the on click event will open MS Graph.  I
can do this on a form simply by double clicking the Graph object, but
I'd also like my users to have a button/menu item to do this.

Please read below for my collective response to recent posts on this
topic.
First a repeat of my suggestion:
"Anytime you feel you are in a position to answer a question, but

I have a table that contains, among other things,  2 Container fields.
I am putting jpg's. in these fields. When in Browse mode if i double
left click on the first container it opens up the jpg in my default
photo editor.

I have an MS Access based application almost ready for distribution to
the public and I find that even though I have compiled it into an MDE
file, tables and queries can still be be imported if accessed by
another MS Access database. How can I stop this please?

Below is what I have so far.  The problem I am having is this.  If I
click OK on the message, and then tab out of the field, the rs.movenext
event occurs without resetting the code.  Each record has a field
"fldDate".  Is there a way to have the recordset equal to the open