I have an application where I have defined a field (yes/no). In a form
this checkbox can on or off .
I would like to have a button in this form which will reset this field
for all the records.

Is there a form event sort of like "on current" which I think means "on
current record" where as you exit/leave the last field for a record on a
continuous form, you could put some code to check for null values in one of
the fields for that record before letting the user proceed ...

I've switched from Access 2003 to Access 2007. I have fields called
CompanyName, Address, and Phone that I would like to have in seperate lines
in a single textbox and display them on a report. I used the following vb
code in Access 2003.

I have a form that just the top row of fields are bound to a query. The
remaining fields I fill in the data and I print a report while the form is
open. Next I use the Navigation button to scroll to the next record. The
problem I have is the data I typed in the unbound fields do ...

The sort button does not appear to be functioning properly. For example. I
ask it to sort  unit numbers 1,2,3,4,5,6,7,8,9,10 & 11 and the records are
displayed in the following order 1,10,11,2,3,4,5,6,7,8,9. It appears to be
sorting the first number only. Can this be changed?

I would like to add code to each field in a record so that after adding new
data or updating data in any field the record will be forced to save, for
example if I have the following fields installdate, installdescription and
installnotes and I add info or update info in any one ...

Some time ago (3-4 years) I remember discussions about the performance issues
of Requery vs Refresh.  I know that 'RunCommand acCmdRefresh' superceeded
(replaced) DoMenuItem, 5...' in the late 90's.  Supposedly ( as my memory
serves) Refresh was better for performance than ...

On my form the top row of fields are bound to a query. All the remaining
fields are unbound and I would like for them to clear as I navigate thru the
records. I haven't been able to figure that out so I created a sub form for
all the unbound fields and though I could get them to ...

I've gone through all the forms and can't seem to get the code straight for
displaying the next month on a text field on my form.
I just want the entire month name and nothing else and I have been struggling
with:

How do you set a field to "locked" on the OnOpen event of a form?
I don't always want it to be locked, just sometimes. So I don't want to
permanently set the control's property to "locked" in its design.

I am hoping for some help on this one, as I am baffled and in a crunch. I
tried posting in the queries section, but have had little luck and have had
great luck in here and think this is more of a coding question as well.
I have inherited some funk data that has come to me in a ...

I can't seem to locate the earlier answers to this sort of question...
I've got a table that is to be exported as a .dbf file.  It is for invoicing
information.  It has a number of specific requirements in order to be
uploaded into the corporate system.  One is that for credit ...

I have a macro which runs a (very long) series of make table queries.
The process takes up to 10 minutes and I  run it by clicking on a
button in a Switchboard page.  Is there any way to have the name of
the particular query show somewhere on the screen so I can make the

I have three checkboxes on a subform, S5, S10 and S15, indicating
whether a vehicle has had a service at 5k, 10k and 15k intervals.  I
want to loop through these to test if a service has been completed
already, depending on the kilometers entered on the main form

I would like to place a calendar control on a form and show it as a little
icon and when the user clicks it have it open into the calendar and allow
them to click on the date they want and then it goes away back to the icon.
is this possible in Access 2003?