Is it possible to change the YesNo message box so No is the default
selection?  (So when the user clicks enter, it does the No code?  It is
standard the the Yes button is the default.
Thanks

I have an edit form that when the txtbox for the zip code is changed/entered,
I would like to have cboArea update automatically.  I have put the following
in the On Exit of the txtbox;
Me.cboArea = Me.cboArea.Column(1)

Access 2003. This post is along the same lines as my last but a
different approach.????
Is it possible, on the query grid, to create an expression field based
on a calculated field but convert it to a number format for lookup/

I have just recently upgraded my Access version from 2000 to 2007.  When
attempting to open my database I get the security warning error below...
"A potential security concern has been identified.
Warning: It is not possible to determine that this content came from a

Hello,
I have two list boxes, List27 and List29.  List 27 is a multiselect.
The following code is associated with List27 and runs whenever an item is
clicked in List27.

The following code runs on Form Current:
----------------------------------------
Private Sub Form_Current()
Dim strSQL As String

I have two multiselect listboxes.   List27 has data and list29 has no data.
As I click items in List27, I would like them to appear in List29, and of
course, as I unclick items in List27, I would like them to disappear from
List29.  How would I code this in the listbox properties ...

Two questions in one:
http://allenbrowne.com/ser-58.html  has an example on an improved
lookup table. I'd like to know how in the SQL query "[Enter Bracket]"
is implimented--is this in an Event Procedure, and how exactly (what

I Have A Form With Many Controls And I Enable The User To Resize These
Controls
So I Want To Ask How Can I Arrange These Controls (Height Only) To Remove
The Empty Vertical Spacing Without Loosing The Order Of The Controls

I have a progress bar form that I am working on.
The progress bar form has a thin red label that represents the progress of a
loop. The label's width is controled by whatever loop is running in another
form that is performing an action involving a loop that takes some time to

I've read the code written by Mr Dev on the site but that is not excatly
understand how the code is work.I have condition:
Some data that I want to output to are on the form Header,and the others
are on the detail section of my continuous form.Below is where I've got so

I have query with this fields
TodayDate: Date () (Field type expression)
Dateofbirth (field type date)
CalcDateOfBirth: DateDiff("yyyy";[dateofbirth];[todaydate])

I have a table called LastVisitedRecord. There is but one field in
that table called "lvCompanyID". I'd like to use the OnCurrent event
of my record form to insert the record id (CompanyID) into a new
record in the LastVisitedRecord table.

I have a db which has same idea as the sample db expenses where there are
three main tables
patients
expense reports

Thank you
how can i requery subform from subform ?