I have sent a data base to a client and he keeps getting the following error.
Unknown function 'Date' validation expression or default value on
'Processing_List.PL.PL_AOD.
I have set all my forms so that when the user updates the form the PL_AOD

I am having difficulty building a series of switchboards the way I want.
Maybe I am interpreting the documentation incorrectly..
Here goes:
I want to build a main switchboard titled "AAAAAAA". I want 4 or 5 controls

I have two forms FrmClient and frmSite.  A client can have many sites.  
I have created a sort of step sequence for users to add new client
information one screen at a time, clicking a 'Next' button to go to the next
step. I chose this route rather than using a subform becuase ...

I am in the middle of creating a form for a database that acts as an order
processing system for a boat company (part of a uni assignment). i'm using
access 2k3 btw. so far, i have the following on my form:
Booking ID (Autonumber)

I have three fields firstname, lastname and business name.
I want to have a conditional statement that stipulates, if a last name and
first name are provided, then continue to next screen, or if business name is
provided then go to next screen, otherwise, you cannot continue.

Hello i am setting up a form for an inspection process i have about 10 or so
questions i am looking to have on this form. I have answers written out to
each question in another table that is linked to my drop down boxes for the
questions, and from there the selection goes to ...

I have tree tables: “productos”, “salidas” and “entradas”, there is a
relation between Product ID of “entradas” and “Product ID” of “productos”,
and there is a query based on tables “salidas” and “productos” tables, when a
product is sold, you put the amount in the “salidas” ...

I've got a form that collects a little information about employee's.  What I
want the form to do is once it's been filled out and they click the "save and
close" button, I want it to automatically send an email to the address in the
email field.  I've got this mostly working ...

hello i am setting up a inspection process thru access to have this form on
inspections. i have the form made out kinda and am looking to improve on it.
i have about 10 or so questions in this form with a drop down box for the
answers. which are on another table in the database ...

What is the correct syntax to get access to a txt file for appending text
within a form.  I am having struggles finding it
Thanks
bbdobuddy

I changed the record source from a table to a query so I could use fields
from multiple tables, when I did this the subform I have attached disapears,
when I change back to the table it reappears. Is there something I need to do
so the subform shows when I change the record ...

How can I make the drop menu on the combo boxes open when I click on the text
box area, not the arrow drop down button?

Is it possible to have a clock in a form displaying the actual time? TIA
-JS

Hi, I have a mainform (form 1)
which has a subform (form 2)
that subform has 2 subforms of its own (forms 3a & 3b)
Forms 3a & 3b are actually based on the same query, but were broken up into

I'm using the following code to set the report name of a snapshot file
on save and it works perfectly.
*************************
Private Sub cmd_save_report_Click()