When I add a button and choose in the wizzard for Delete Record
operation, it does not work, instead it ADD's a record? How come?
This is the VB contents of the button:
Private Sub CmdDelete_Click()

I have a button on mainform(F1) to open subform (F2).
The problem is when i press the button for opening F2 to record, then i
close F2, come back F1, the button is PUSHED STATUS.
i want to see the button rised for next action.

tblDetails has the following fields:
AgencyCode, ProducerCode, AnnualPX
How can I create a query to show the Top 5 producers per agency with
the highest

I've built a system to enter and manage purchase orders.  This is in
use by >10 clients.  Some use it in Access 97, most are in A2k.  About
half use it through a Citrix implementation.  It is separated into a
front end and 3 back ends (1 network for permanent storage, 1 local for

Some button text in the switchboard items consisits of a underlined
character, to access it with ALT-....
How to have this dismissed as I don't want to use it?
Bart

I have a table of several account executives (A.E.'s).  I need to
assign the loan A.E.'s to prospect mailable records.  A data file is
sent to a printing company on a biweekly basis and count varies on each
mail piece.

Hey there folks,
I was wondering if there was a way to store a list of variables in a
table and then call them one at a time in some loop method.
Here's what I've got:

I have a report that uses a stored procedure as a record source.  The stored
procedure accepts a parameter  InspectionDate smalldatetime which it prompts
for when the report is run.  I have a textbox control on the report with the
control source of:

I have a main form that with a subform which is based on a parameter
query.  I have 2 controls on the main form [OpenDate] & [Close Date]
which are used as parameters in the query.  It all works fine and dandy
until the query returns no records.  The main form just "whites out"

We have a simple database which stores employee audit results.  Many
audits are done on each employee.  I have a table with int_AuditNumber,
txt_Name, and txt_Score.  The txt_Score field shows the result of the
audit and can only be "Correct", or "Error".

Currently developing  a project in database. The problem is my front
end and back end are in  the same .mdb file but when ever i tried to
open the database connection it throws following error.
The database has been placed in a state by user '<username>' on machine

I have several reports being auto-emailed via macros from Access.  With
our company's recent upgrades Outlook now pops up a lovely warning
requiring the user to press the Yes button each and every time to allow
the email to be sent.  Currently there are 77 iterations of each report

I know this will be simple but it has me stuck. I've trawled the
newsgroup and can't find the answer that I need.
I have 2 fields in the query grid:
WithHaz: Nz([CountCsafes2].[CountOfCSNo],0) and

Well I have an old database that all the text fields are set to 25-50
don't know why but I needed to change them all to 250.
Well I wrote some code to change the size of the fields in the tables
to 250 but I get a read only error when I try to change it.

With earlier help from this group (thanks Ben!) I've ended up with this
OnLoad code for my popup form:
Private Sub Form_Load()
If IsNull([Forms]![frmCustomerOrders]![MarketPlaceID]) = True Then