IS there a way to run a procedure if the users close access directly
rather than closing a menu screen that I have built? There is an event
that works on close for this form, but it doesnt seem to run if the
form is open and the suer just closes access all together, is there a

I've recently joined several others in attempt to discourage Steve Santos
from advertising his PC Datasheet business on CDMA. Among the hundreds of
professional consultants who contribute to CDMA, Steve is the only one that
persistently violates the charter prohibition on ...

Image1.Picture = Clipboard.GetData(vbcfbitmap)
the above works in VB5.  What is the equivilent code in Access 97 or
2000?
Thanks,

I have a database in Access 97 which I have inherited from an ex-colleague,
well more accurately lumbered with it since I'm a total novice in Access.
I've want to be able to record the date and time a record is updated and
when a new record is created but am somewhat out of my ...

I have been using variations of the following to determine whether
a functional connection to internet exists. I'm thinking of replacing
it with a simple PING, but I've never seen any code for that. What
is your opinion on the alternative strategy? Have you ever tried it?

This is Randy Harris a liar who is insincere and a person that can not be
trusted. He won't even own up to his worthless garbage by signing his name.
Randy,
Why don't you follow the advise of David Fenton ---

Dear fellow Access 2003 Users,
Is there a way to trim all of the fields in a table in one swoop using
VBA (preferred) or a query?  Right now, I am using an update query and
updating EACH field to it's trimmed counterpart.  Any ideas?  Thanks!

is there a way to create simple help file that i plan on linking to a command
button on a form using what's already in access?  i will probably be giving
out this db that i've written to a number of other offices and the
instructions i'm going to have to pass along with them are ...

I'm creating a query, which I want to use in code in my VB.NET app.
This query produces the correct results when executed in Access:
SELECT tblEncounters.EncounterBeginDT, Query11.RID, Query11.LName,
Query11.FName, Query11.MI FROM tblEncounters INNER JOIN Query11 ON

I want to include some summary data in a report section header.  In the
example below I want to put in the "Apples" section header the date of the
sale of the last red apple.  Everything I try only produces the date of the
last record in that section (10/3/05 instead of 10/2/05, in ...

I have been building access databases for a few years now and have never
built a union or pass through query. What are these strange mythical beasts?
What do they do?
Paul

I am trying to create a simple application to track the "in" and "out"
of a group of employees. The In and Out field is a drop down. When it
is set to "in" I want the background of the filed to be green, and when
it is set to "out" I want the back ground to appear red.  I would

I need some suggestions....
I have a sub-form that acts as a continuos form.  I want to allow the
user to optionally click a button at the end of the "NEW" row that will
copy some of the previous rows contents.

All,
   My VBA experience is very limited so please bear with me. I have a main
form which I want to add several timer events to but they need to fire at
different intervals. One say every 5 minutes and one every 30 minutes. I

From time to time, I find myself cross checking one block of code
against another. Usually older stuff in which I've made modifications
that don't work. I don't remember what all the changes were so I
have to print an earlier version and compare it against a printout