There was an error executing the command

G

Guest

Guys,
I get the 'There was an error executing the command'

error message.

I an using win xp & Access 2002.
I created a database using the MS Access template 'Order Entry'


I have entered about 97 customer enries so far.
Now when I choose 'Preview Reports" both the 'sales by employee and sales by
customer reports - when i enter the dates between fields i get this error
message

"There was an error executing the command"

I can view the reports with data up to a certain date fine
eg
16/12/1999 to 02/04/2000
as soon as i put in one more day & beyone eg
16/12/1999 to 03/04/2000
I get the above error.
it seems like the customer entry at this point has an error. I have checked
& it seems fine.


Please help...all the work entering the data for nothing. Any ideas. Is it a
code thing.

I looked at my database and when I go into the design view > Forms > Report
Data Range > and double click to open it, I get an error..."Runtime
error'94' I cannot continue butcan end or debug. when I debug I get the
following code.


Private Sub Form_Open(Cancel As Integer)
Me.Caption = Forms![Report Date Range].OpenArgs
End Sub
Private Sub Preview_Click()
If IsNull([Beginning Order Date]) Or IsNull([Ending Order Date]) Then
MsgBox "You must enter both beginning and ending dates."
DoCmd.GoToControl "Beginning Order Date"
Else
If [Beginning Order Date] > [Ending Order Date] Then
MsgBox "Ending date must be greater than Beginning date."
DoCmd.GoToControl "Beginning Order Date"
Else
Me.Visible = False
End If
End If
End Sub


Is it a date problem? I tried a new order entry dtatbase and I still get the
above runtime error on the Report Data Range entry.
Hope it all makes sense..?

Thanks
Darren
 
Top