Hi. When code expects an action like clicking a button
and the user chooses instead to just close the window, I
get an error message because I have no code to handle
these exceptions.  Could you give me an idea of what I

I've been up and down these forums looking for a solution to this
issue, but so far have had no luck.
I need to automatically assign serial numbers starting from 1 and then
incrementing by 1 as each new record is entered.

How do you set the focus on a subforms subform?
I have one main form with three subforms:
The mainform is called: Requests
The 1st Subform is called: Subrequests

I couldn't find related threads so I figured I'd post this one.
I want to change the layout of a form on the fly, such that dependant on a
user's authorization level, they might see one form field but not another.
However, I want to make this transparent to the non-authorized user, ...

I have a somewhat simple database split to a front end and a back end.  
Everything works well for 99.9999% of the time .  However, every now and them
someone wants to update the same record that someone else has locked.  How
can I tell if another user has the record locked BEFORE ...

I have a control on a form that has code which creates a message if the user
does not input any data. If I put this code in the OnLostFocus property of
the control it works fine, but if I put it in the BeforeUpdate property of
the form it doesn't. Here is the code:

Hey, I am new here and new to Access. I was asked to try to updat
some features in something that someone else created (he is no longe
around), and I had run into a couple roadblocks. So, I was hoping yo
guys could help

Using an ADO recordset, how do i read the contents of a specific record
number's fields.

I want to use a calendar on a form to accept a date range from a user...and
then use the range to limit the results of a query. I used the
dtCriteria1=StartDateCalendar.Value code for the Calendar...but I'm not sure
how to code my query to run based on dtCriteria1.

I am trying to export a large number of records one at a time into a word
template .dot file from access.  The problem that I am having is that each
time a new document is created from the template I have to click on the
header of the Word application for the code in access to ...

I'm testing various ideas to make Access forms work elegently - eliminate
meaningless default messages etc. One idea is to set values in the table defn
- required = yes etc - then trap data errors in the forms Form Error section.
Questions:-

I need to have the sample code from Albert D. Kallal - using unbound check
box on continuous form. I can not download it from
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html, page not
found.

I've inherited this awfully designed parts inventory database. There is no
method of caturing parts that were checked out of which some or possible all
were returned.
There is a field for incoming items, and issued items, then, the there is a

I have 2 tables Invoice and InvoiceDetails. They have a relationship 1 to
many. In Invoice table the items are:
(invoiceno,companyname,invoicedate,paymentdue,subamount and totalamount)
and in InvoiceDetails table the items are:

I tried the following sample code from Microsof
(http://support.microsoft.com/default.aspx?scid=kb;en-us;161007) an
I notice that when I change the customer's name to somethin
different than what I previously entered in the combobox it give