Format$ Error

[DebK]

I just converted a 2003 .mdb over to 2007 .accdb and now when I try to run
some reports I have I get a message saying Enter Parameter Value for Format$.
I rebuilt the report based off a query using the report wizard and still get
the message and #Error in the field on the report itself. This is what I
have for the control source =Format$([Timestamp],"mmm yyyy"). Can anyone
help?

 

[toddr]

what exactly are you trying to format?

 

[DebK]

I'm trying to format a date/time field named timestamp by month.

what exactly are you trying to format?

I just converted a 2003 .mdb over to 2007 .accdb and now when I try to run
some reports I have I get a message saying Enter Parameter Value for Format$.
I rebuilt the report based off a query using the report wizard and still get
the message and #Error in the field on the report itself. This is what I
have for the control source =Format$([Timestamp],"mmm yyyy"). Can anyone
help?

 

[toddr]

that command works for me when i use in access 2007. in an intermediate
window i enter x=Format$(now(),"mmm yyyy") and it reutrns "Aug 2008" for x.

what value is in [timestamp]?

I'm trying to format a date/time field named timestamp by month.

what exactly are you trying to format?

I just converted a 2003 .mdb over to 2007 .accdb and now when I try to run
some reports I have I get a message saying Enter Parameter Value for Format$.
I rebuilt the report based off a query using the report wizard and still get
the message and #Error in the field on the report itself. This is what I
have for the control source =Format$([Timestamp],"mmm yyyy"). Can anyone
help?

 

[DebK]

mm/dd/yyyy

that command works for me when i use in access 2007. in an intermediate
window i enter x=Format$(now(),"mmm yyyy") and it reutrns "Aug 2008" for x.

what value is in [timestamp]?

I'm trying to format a date/time field named timestamp by month.

what exactly are you trying to format?

:

I just converted a 2003 .mdb over to 2007 .accdb and now when I try to run
some reports I have I get a message saying Enter Parameter Value for Format$.
I rebuilt the report based off a query using the report wizard and still get
the message and #Error in the field on the report itself. This is what I
have for the control source =Format$([Timestamp],"mmm yyyy"). Can anyone
help?

 

[toddr]

i mean what is the actual value in the variable [timestamp]. i assume it does
not actually contain the value "mm/dd/yy". the #error may be because there is
not valid data in that field.

mm/dd/yyyy

that command works for me when i use in access 2007. in an intermediate
window i enter x=Format$(now(),"mmm yyyy") and it reutrns "Aug 2008" for x.

what value is in [timestamp]?

I'm trying to format a date/time field named timestamp by month.

:

what exactly are you trying to format?

:

I just converted a 2003 .mdb over to 2007 .accdb and now when I try to run
some reports I have I get a message saying Enter Parameter Value for Format$.
I rebuilt the report based off a query using the report wizard and still get
the message and #Error in the field on the report itself. This is what I
have for the control source =Format$([Timestamp],"mmm yyyy"). Can anyone
help?

 

[DebK]

Sorry it took so long to get back. Actual dates using two digit month, day
and four digit year. i.e. 6/1/2007 or 12/31/2007

i mean what is the actual value in the variable [timestamp]. i assume it does
not actually contain the value "mm/dd/yy". the #error may be because there is
not valid data in that field.

mm/dd/yyyy

that command works for me when i use in access 2007. in an intermediate
window i enter x=Format$(now(),"mmm yyyy") and it reutrns "Aug 2008" for x.

what value is in [timestamp]?

:

I'm trying to format a date/time field named timestamp by month.

:

what exactly are you trying to format?

:

I just converted a 2003 .mdb over to 2007 .accdb and now when I try to run
some reports I have I get a message saying Enter Parameter Value for Format$.
I rebuilt the report based off a query using the report wizard and still get
the message and #Error in the field on the report itself. This is what I
have for the control source =Format$([Timestamp],"mmm yyyy"). Can anyone
help?

 

[fredg]

I just converted a 2003 .mdb over to 2007 .accdb and now when I try to run
some reports I have I get a message saying Enter Parameter Value for Format$.
I rebuilt the report based off a query using the report wizard and still get
the message and #Error in the field on the report itself. This is what I
have for the control source =Format$([Timestamp],"mmm yyyy"). Can anyone
help?

Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access' for
the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for
how to reset a missing one.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html