I'd like to have a "Cancel" button on a form which could
interrupt VBA execution.  I was able to do this in another
DB language: the program repeatedly called a function
CancelCheck(), which checked if a click event had occurred

I have a subroutine which has vba code.  But the issue
is   if i want to run another code (from a diffrent form)
from that subroutine, how i can do that. One way is that i
write the label name in the main subroutine

I've been scratching my head trying to figure out why the runtime error
occurs when the DAvg (or DMax or DMin) function call is made in CalcAvg (or
CalcMax or CalcMin) function.  I try to avoid creating and deleting (query
and recordset) objects since they make the db really ...

I'm doing something which should be simple, namely a loop
through a table and updating one field via .Edit, .Update.
When there's a huge number of records, I get the following
message "File sharing lock count exceeded.  Increase

How to select the first field of a table in VBA?  I am
using Access97?
Rst = CurrentDB.OpenRecordset("SELECT Count(" & -
table.field.1- &") AS Count1 FROM EMP;")

If some could help me with this.  I would like to use the
Transferdatabase command in a a close expression.  What
I'm trying to do is have the the database export and
create a file with the current date has it's filename.  I

I don't know that this is the right newsgroup, but I'll
give it a shot.
I need to ensure that a user has Microsoft's ActiveX Data
Objects 2.5 Library selected under the References in VBA

I have an application that imports a file, then compares
the file with an older file, adding only non-duplicate
records.  I have two ways to compare the files and a form
(frmCompareMethod) that pops up to let you choose what

I'm looking to create a macro/code to run a query, export
the data to an Excel file, increment the query criteria
automatically, run the updated query, export the new
results to a new excel file, etc. until the end of the

Anyone know the way to code an ATAN2 function using the
functions provided by MS?  Thanks, Ken

I need to have the date and time that a report is PRINTED automatically
entered into a field.  I know I can display the time printed but I'm using
this information to compare in and out times.  I'm entering data through a
form and that is set to show when the form is opened but ...

Does anyone know of a way of putting custom text on the buttons of a
msgbox??  I would like them to read Print, Preview and Cancel??
I'm using Access 2000
Many thanks in advance

Please help with syntax error.  Thank you
DoCmd.RunSQL "INSERT INTO [Monthly Sales]( DISTRIBUTOR,
SLSLNO, SLSLNO_NEW, SLSLNM, SALES, SALES_MO )SELECT
Distributors.Distributor, [qrySelect Distributors].SLSLNO,

Can someone please tell me what would be the best way to
read a CSV file and perform actions according to values
within that file?
Thank you.