Error on Invoice Date

  • Thread starter Thread starter jwrnana
  • Start date Start date
J

jwrnana

I am using the Order Entry database provided with Microsoft Access. My
invoices have been working fine until now. When I go to Orders by customer
and preview an invoice, the date has ? in the invoice date field and will
not go on to the invoice. The following error appears ---

On Error GoTo Err_Order_Details_Subform_Enter()

If IsNull(ME![OrderID]) Then
ME![OrderDate]=DATE (Date is highlighted as the error)
DoCmd.DoMenuItem acFormBar,acRecordsMenu,acSaveRecord,acMenuVer70

End If


What do I need to do?

Novice
 
Novice:

Date is a vba KeyWord, which if it isn't working (i.e. erroring) then 999.9%
of the time the problem is a missing reference in the database which is
causing VBA to fail. To resolve, open a general module and from the VB
Tools menu choose References. Look in the dialog for anything listed as
"Missing". If you don't know what the Missing reference is, you might try
simply unchecking the missing reference and that should solve things. If
the Missing reference is critical to the db then find the file the reference
points to and re-browse to the file to re-establish the reference.
 
Steve - VBA means what? When you say open a general module -- how? In the
same database or another one? I looked under tools for references, but did
not see it. Help again, please.
SA said:
Novice:

Date is a vba KeyWord, which if it isn't working (i.e. erroring) then 999.9%
of the time the problem is a missing reference in the database which is
causing VBA to fail. To resolve, open a general module and from the VB
Tools menu choose References. Look in the dialog for anything listed as
"Missing". If you don't know what the Missing reference is, you might try
simply unchecking the missing reference and that should solve things. If
the Missing reference is critical to the db then find the file the reference
points to and re-browse to the file to re-establish the reference.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

jwrnana said:
I am using the Order Entry database provided with Microsoft Access. My
invoices have been working fine until now. When I go to Orders by customer
and preview an invoice, the date has ? in the invoice date field and will
not go on to the invoice. The following error appears ---

On Error GoTo Err_Order_Details_Subform_Enter()

If IsNull(ME![OrderID]) Then
ME![OrderDate]=DATE (Date is highlighted as the error)
DoCmd.DoMenuItem acFormBar,acRecordsMenu,acSaveRecord,acMenuVer70

End If


What do I need to do?

Novice
Click to expand...
Click to expand...
 
Novice:

VBA stands for Visual Basic for Applications. Its the language for the
code you wrote below.

You would open a module in the database you are working on. Either a
general module (by clicking the NEW button on the database window) or when
you have the form module open that was giving you the problem before. Any
module will do. You have to have a module open to get to the proper Tools
area for references.
--
Steve Arbaugh

jwrnana said:
Steve - VBA means what? When you say open a general module -- how? In the
same database or another one? I looked under tools for references, but did
not see it. Help again, please.
SA said:
Novice:

Date is a vba KeyWord, which if it isn't working (i.e. erroring) then 999.9%
of the time the problem is a missing reference in the database which is
causing VBA to fail. To resolve, open a general module and from the VB
Tools menu choose References. Look in the dialog for anything listed as
"Missing". If you don't know what the Missing reference is, you might try
simply unchecking the missing reference and that should solve things. If
the Missing reference is critical to the db then find the file the reference
points to and re-browse to the file to re-establish the reference.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

jwrnana said:
I am using the Order Entry database provided with Microsoft Access. My
invoices have been working fine until now. When I go to Orders by customer
and preview an invoice, the date has ? in the invoice date field and will
not go on to the invoice. The following error appears ---

On Error GoTo Err_Order_Details_Subform_Enter()

If IsNull(ME![OrderID]) Then
ME![OrderDate]=DATE (Date is highlighted as the error)
DoCmd.DoMenuItem acFormBar,acRecordsMenu,acSaveRecord,acMenuVer70

End If


What do I need to do?

Novice
Click to expand...
Click to expand...
Click to expand...
 
Back
Top