Greetings;
My chart report trys to print one chart (Pie) per record. All the charts are
exactly the same.
I want to print only one chart.

Access XP. The main date entry in the F/E file contains a date field where
the user type today's date.
Management wanted the date to show automatically. No problem I used date()
and locked the box. The problem is that the user can change the date in

Could anyone help me out with these codes. Something is wrong but I can't
figure it out.
This particular line of code is suppose to have 3 OpenArgs for the form
"Invoice by Dates" but only the first two gets included. Me.cmbReviewer.Value

Do anyone know how this works and if so, is it correct the way it is written?
Private Sub CommandButton_Click()
  Call DoCmd.OpenForm("Form2")
  Forms![Form2]![txtBox1]=Me("txtBox1")

Got a table with Dates, Types, and Amounts.  
Types are Longs like 1, 2, 3, 4.
Dates are.... well, dates.... as in "02/05/2007".
Call it Table_A

I apologize in advance for the cross posting, but I'm trying to widen the
set of eyes that is able to see this from
microsoft.public.access.formscoding, since I haven't gotten an answer there
yet.

We have associates who would use the Ctrl F feature to search for records.  
With this, people would type in the fields by mistake.  I added the
Binoculars and told everyone that the HAD to use this to search.....  it
worked for a while, but people are still searching within the ...

Someone asked me to build up a datastructure and also denote the file
specifications. I actually don't know what is expected of me to do? My
datastructure defines sets, indices and parameters, so if I am correctly I
can create my structure by inserting relationships. But what ...

In a large application I have many combo boxes with Auto Expand
property set to "Yes".  There are two fields in the row source:
SELECT DISTINCTROW TBL_TOWN.TCODE, TBL_TOWN.TNAME
FROM TBL_TOWN

Please feel free to use the correct terms when responding.  But my MS Access
2003 Design View is only displaying the boxes up top with Tables/Fields
attached to other Tables/Fields.  But at the bottom(?????don't know the
name???) there is no box for selecting tables, fields, sort ...

I have an edit form that I open after some one enters the appropriate NC#.
How do I validate if that number exists before opening the edit form?

i have a query that sums up all hours and stores this as a main figure lets
for this question say
78:34
to store this in an access table i need to use a text type

I created a form that allowes add and update.  There are several combo box
controls.  After a number of the records were added, users bring up the form
and for some reason fiddle/play with the combo box controls.  This results in
the data being changed.  And they don't seem to ...

This line of code is suppose to open another form and use these OpenArgs as
values in some of the controls in the new form.
DoCmd.OpenForm "Invoice by Dates", acNormal, acWindowNormal,
OpenArgs:=Me.txtStartDate.Value & "," & Me.txtEndDate.Value & "," &

Hello...ok I have a form with a button that I am trying to get to call on a
function. I have been able to do this and the funtion processes but I keep
getting an error. Now, the funtion works perfectly if I run it from the
switchboard/menu, but when run from the form button I get ...