I have many fields text and combo bound and unbound in a form. Is there a
situation where the form has a new record and yet dirty or any other
unexpected possibilities. I always think that when a form is new it is
invariably not dirty. I am not sure if this is true always.

I wonder if anyone out there has come accross the same problem - V
Frustraiting!  when I create my switchboard, the normal first message "There
is no switchboard, do you want to create one now?" or words to that effect
does not come up.  I go through the motions of creating all ...

I have a Form and Subform with 40 something Combo, Text and Memo controls.
Users populate the form and print it. Great! all works well....er no. The
user decides to change a few controls values here and there and then want the
changes highlighted on screen and on the printed ...

I've read about 50 examples of how to use Conditional Formatting to change
the color of specific fields in a continuous form. Is there a way to use it
to change the form's background color for that particular record, while
leaving the records that are have not met the condition ...

Thanks for the help.  I don't think my earlier question was clear enough.  I
have a microsoft mapping program called MapPoint.  It resides in C:\Program
Files\MapPoint.  From that Mapping program I have made various Map Files:
MyMap.ptm, Arizona.ptm, PA.ptm, California.ptm, etc.  ...

I'm creating a database that needs to track many many items related to
one employee. To do this, I have had to split up the data into
multiple tables, each with an ID field, with each ID field having a
one-to-one relationship with the ID field in the "personal" table.

Can you change the layout of the form in design view or do I have to go
through the wizard again?

I'm building data for a report and after the data is built I prompt the user
as to how they want the data to be displayed, they can display by individual
or by a category, if they select by Individual I make visible the combo box
where they can select the individual the problem ...

All -
In Switchboard Manager, there is an option to Open Report.  On the Report
I'm trying to open, I have set the default view to Print Preview and Allow
Report View and Allow Layout View to No, as I want the user to see the

Okay I am working with a access database and I am trying to format the form
to display certain information based on a combo box answer.
so I've garnered so far I need to go to on current event of the form and
type in my commands (I planned in using expression builder)

I am about to convert a pair of Access 2000 programs from an mdb back end to
SQL Server 2005 back end. I will still be using mdb front ends.
Is there any advantage of converting the front ends to 2003 or even 2007?
Thanks,

I have a database that i designed for a department that has approx 8 users.  
It is setup on a shared drive with FE and BE.  All users have read and write
access to folders.  Each user has a seperate copy on their desktop that they
access.  My users from time to time receive the ...

i downloaded expense report from online now i can't find my expenses?

Can anyone tell me why this will not work?
[Forms]![frmReferals]![txtReferalID]
I have a form that I want filter by the value of txtReferalID for some
reason this does not pick it up?

I have a form with a sub form on it the sub form is in Datasheet view this is
a 1 to many arrangement. The 1 being the main form and the many being the sub
form.
The sub form is the one in Datasheet view.