I have finlly got my code to work but I am trying to implement the final piece which is AND ((tblacq.Acqdate) Between #" & _
Format(Me.Startdate, "mm/dd/yyyy") & "#" & _
" and #" & Format(Me.EndDate, "mm/dd/yyyy") & "#"
Eveything works fine until I add this in. I have added to ...

Form_A has many controls AND a Tab Control. One of the tab's pages (Page_5)
is full and I cannot make the tab larger.
I want to have a new form (Form_B) that contains the Page_5 controls plus
more.

I've created 3 split forms in AC 2007. The Form Properties are identical
except for
the Record Source, of course.
Each form when opened the Navigation Bar is 'grayed out' until I select

I would like to apply conditional formating to a form text field when
non-apha numeric characters are within the fields value (such as "." "," "-"  
etc.).  Is there a way to search a field for specific characters and apply
conditional formatting to it if those characters are ...

How To:  Using a value from another field I would like to display a certain
selection in a combo box.  For example if a user selects 'X' then I would
like to display ITEM(3). What combo box properties/methods should I be using?

How do I input the first item from a list/combo box in a form if the user
doesn't select any other item? I want the first item to be the default entry
to the form field if the user did not select any other value. I'm a newbie so
if you could suggest creating expressions instead ...

I have a calculated textbox with data source
=Nz([A],0)+Nz([B],0)+Nz([C],0)+Nz([D],0).  Any one or more of the textboxes
B, C, D can be invisible.  Everything works fine at data entry time.  But
when I recall the record for edit, the calculated field is #Error.  I tried

I found an old thread and krissco responded with the method
that I was looking for (see below).  However, I'm getting some
unusual results and I'm not sure if there's some configuration
or versioning issues.  I'm running Office 2002, though my

I am working in Microsoft Access 2003 when the cursor changes to an
hourglass - as though it were doing something, and it stays that way.
How can I find out what it is doing, as I have no processes running to
my knowledge?

Here's my problem: A client comes in enters their client ID, enters in some
data. I have a second form that an employee takes the client ID and inputs
other data. The problem is I don't know how to display the Client's info on
the employee form? How do I get the info from the client ...

I have a form where a date must be entered.  I have defined a constriction
where only dates within a certail range are acceptable.  This application
has multiple client sessions running.  It runs fine than suddenly, the date
field will only allow the current days date to be ...

I have two tables, one a Staff list and the other an Asset list
extracted from seperate databases, the information in the tables has
absolutely no common data, I have a form with the user name and other
bits and pieces on from the staff list and also a drop down list of

I would like to have a command button pull up a form that is linked to the
main form.  The main form displays milestones and I would like to command
button to pull the progress notes form with the record that is linked to the
corresponding milestone.

I have a form with the Control Source as
"=Query!QTYForPPMProduction!SumOfQTY_PRODUCED"
and this query runs prior to the form opening.
The query runs fine, and the proper data displays in the datasheet view, but

How do I make a few subforms on a form but make each subform have a tab
across the top so the users can click the tab and see each subform
individually?