I have in a subform 2 yes no fields. One is called 'action successful' and
one is called 'unfinished'. First the unfinished one is ticked but when the
action has been completed then i want to be able to tick 'action successful'
and unfinished will automatically be unticked.

I kept getting errors with my switchboard and finally imported one from a
template database from MS and I still get the same error. I have searched
the web and the help files and found nothing
I get an error compile error: Error in loading DLL. The form works in the

Before attempting to add a calendar control to a form (in Access 2003), I
checked the MS help which specified Calendar Control 11.0.  My tool box
contained Calendar Control 9.0, only, however.  I added 9.0 to my form, but
subseqently deleted it, somehow causing all of the other ...

i got idea from other post to list all tables & queries of a databas
in a combobox with
"SELECT [Name] FROM MSysObjects WHERE [Type] = -32768",
is there way to list all queries only?

Is there a way to prevent the user from modifying the width of columns in
datasheet view.  For example, I have a form and I do not want the user to be
able to resize the columns on the form so that it will fit nicely on the
screen.

Please can someone help, I know its getting late but this one is now
starting to really bug me:-
I have a form that the user enters loads of details into.  One of the fields
is a text field called "DeliveryAddress1"

I realize that propercase is similar to titlecase in word in that it
capitalizes the first letter in each word. Does access also have the
equivalent to sentence case, where it would only capitalize the first letter
in each sentence?

2 questions for everyone:
1. How many characters can a memo field store?
2. I have a list box on one of my forms. The box show a call history (Acct#,
Date, Time, Notes) For my notes section I have it setup as a Memo field.

I have been using a form/subform method to do an order entry system.  This
has worked fine however one of the drawbacks is that if you start adding,
deleting, and editing lines in the subform there is not realy and easy
"undo" once you move to the next/previous line in the ...

I need help Converting numbers to Text ( ie. 12,345.00 to Twelve Thousand
Three Hundred Forty Five Dollars and No Cents).
ML

i want a calculated field to appear in my form.  I can do it but then the
calculated value does not show up in the able associated with the form.  How
do i remedy this?

On my for I have setup text boxes to choose different types of search
methods. I have created queries with criteria statements and then linked the
queries to a Macros using the Action OpenQuery. However, I am unable to link
the Macros to the text boxes and then have the ...

I created a form in A2000 that has a calendar and Date( ).  
The form works just fine on the machine where the mdb was created and on a
machine with A2003.  But it fails on two A2002 machines where I want the app
to live.  The calendar Active X component has to be removed and the ...

I feel pretty silly for even asking, but here goes.
I created a form with the wizard.  I can see it in design view; however,
when I go to form view, the form is empty.  I checked the visible property.  
It is set to yes.  I checked the font color and changed it in case it was set

I've got a form that opens in "Filtered" mode with this code:
DoCmd.RunCommand acCmdFilterByForm
I then have a message box that pops during the Form Filter event that says
"Select filter criteria and click Apply Filter button"