Good Afternoon,
    I am trying to set up a form that is used for the criteria of a query.
I would like to use a calendar for one of the criteria but I want to limit
the allowable input to only Sunday dates. Is this possible and can I make the

If the query that the subform is sourced on, returns no records, the subform
will be blank.
I would like in this situation for a nonvisible label "No Data" to be made
visible.  Is there a NoData function that one can use in this situation?

I have this code in a form, but I'm the only one that can use.  What did I do
wrong?
Option Compare Database
Option Explicit

Hi.  I'm using Access 2007.  I have a form where I don't allow New Records to
be added.  It's only for editing or deleting records.  I have a combobox
where the user chooses the record they want to view.
The user is also allowed to navigate thru records by using Access'

I have a field (DRNo) which is a key field and MUST be typed in before the
user can do anything else on the form.  Its the first field on the form.  The
field must be 9 digits and can not be left blank.  The only exception is if
the user closes the form (there is a close button). ...

I am trying to set the value of a text box on a form to the result of a query
that will only ever yield one value.  What type of control should I use and
what should I set the properties to.  So far when I try to connect to a query
I get a : ?Name in the box when I open the form.  ...

I have a command button that prints a report based on a single record.
I would like the option to specify the number of copies I can print rather
then continuously pushing the button.
Here is my code.

Hey, is there a way to display certain values from a record in a drop-down
box, so that each detail section in the form has a different set of values?  
I find it's easy enough to put the combo box in the detail section, but after
that every combo box - each one in every record, I ...

I have a database with separated data and code (different
directories).
When managing tables, themselves, I have Tools->Relationships.
When managing forms, I also have Tools->Relationships.

I have to create a form from which I can print a number of existing PDF files.
I tryed to create an (PDF)-object:
   Dim App As Object, PDFDoc As Object
   Set App = CreateObject("AcroExch.App")

Before we had controls in place, through VBA code, some data didnt get
entered into some fields (text boxes and combo boxes).  What I would like to
do is when the user loads a form, the form will highlight (change the back
color) of key fields that have null values.  This will ...

please give me an idea how to show dat grid rows in MS acess form then add
and update data table also..
Thanks a lot
Amita

Can someone suggest how, from an access form module which I am using to open
an MSWord document, I can open the .doc in minimized form.  Next step would
be to close MSWord.
The coding used to open the Word doc is:

When I open a form I get the 429 Error, ActiveX can't create oblect.
Dim CLClient1 As Clc.ClServer
Set CLClient1 = New Clc.CLServer   'This is the problem.
I have the Active X control registered.

Office 2007
I have a continues form with 'email' field. I want to design a button so
when clicked, all valid emails (length > 8) will be put in To field of
outlook.