I have a form based on a query (reefing) which is based on a table
(tblcontacts) The query looks up the field TX. the form has a combo with a
control source being a control TX in the table tblcontacts. When the user
chooses the appropriate surname by selecting from the combo and ...

I disable radio buttons within an option group based on criteria in other
controls on the form. Although the buttons are succesfully disabled, the
labels don't go grey as they do for other disabled controls. Any suggestions?
Bill

I have a text box that when the query runs, it either returns a value, or
there may not be a value (empty). When the form is displayed, the textbox
reads #Error
Here is my script thus far that returns #Error in my textbox

Yesterday this code was opening a form from a button on a subform but
today...oh today! It is opening a new instance of the form......I want it to
open the form with the information I entered on the subform!
Private Sub cmdCollect_Click()

What I am looking for is a way to limit a user to having more than 127
characters in a Text Box.  I know the simple way is to have an Input Mask.
But I dont want to use the Input Mask Property, I can explain why if needed.
So one way I know you can is in the KeyDown Event...

I loves to advertize my new Free Hosting Site:
i Will pay YOU lots of Dollar to post in newsgroups upto $250,00 Dollars for 1000 posts  !!
If you promote my site :   http://www.dhosted.com
Email me on :

I have a databse where I've set up a mail merge squence to output certain
records to a word document that's already created.  This worked fine when my
database was in Access '97 but we've upgraded to Access 200 and now it
doesn't work.  I keep getting told that there's an error ...

I am working on a database in which I will have different data types.  What I
want to be able to do is if, for example, the field [datatype] equals 1 it
would display a text box on the form, if 2 a combo box, if 3 a list box, etc.
Any suggestions?

I have the following code to determine if a form is loaded when another form
is opened and if so the first form should be closed.
Private Sub Form_Load()
If IsLoaded("frmfindrecord") Then

I have a custom toolbar that has a print button on it.  I want the print
setup dialog to appear when this button is pressed but can't find a way to
make this happen. When customising the toolbar, you can add the print button
and the properties for this are identical to those on the ...

I am recording or a user the number hours each employees worked each week in
Access.  For example:
Name        Days Worked     Week Ending Date
John Dull            4                   11/04/2005

I have a main Form that is unbound, called frmContracts.
On frmContracts, I have 2 sub forms:
subfrmContracts - where it's record source is a Cross Tab Query
and

Hello again,
When my form is on a new record, I would like this to happen:
1. Have combo box named FullName be enabled, but all other objects disabled.
2. When FullName is populated, enable all other form objects.

Is it possible to do the following with NEW RECORDS ONLY:
1. Prevent record saves if FullName field is blank.
2. Allow move from record if fields dirty, but DON'T SAVE if FullName is
still blank.

Hi (A2K3)
Is it possible to be able to lock a select group of records via a button and
also be able to unlock them with a button?
After a time period is closed off by the finance department, we want to be