Setting Date format within Concatenated field

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

I'm trying to use the following code in a text box on a
report but it isn't working.

="This used to work on "& format([createDate],"dd-mmm-
yyyy")

The error message I'm getting is "The function you entered
can't be used in this expression". For some reason it
doesn't like the format part of the code.

Does any one know how I can set the date format within
this sentence?

PLEASE HELP!!!!!
 
I'm trying to use the following code in a text box on a
report but it isn't working.

="This used to work on "& format([createDate],"dd-mmm-
yyyy")

The error message I'm getting is "The function you entered
can't be used in this expression". For some reason it
doesn't like the format part of the code.

Does any one know how I can set the date format within
this sentence?

PLEASE HELP!!!!!
Click to expand...

Assuming the name of this control is NOT [createDate], the expression
is fine and should work.
I suspect you have a missing reference.

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://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
 
Hey Doug, how about you do a massive search and replace on the intranet?
Make sure you include all the web sites and news group postings ;-)
 
Fred,

THANK YOU SOOOO MUCH!!! You are a life saver. I had been
testing an add-in and now when I moved my app to another
server that reference was missing.

Thanks again.
-----Original Message-----
I'm trying to use the following code in a text box on a
report but it isn't working.

="This used to work on "& format([createDate],"dd-mmm-
yyyy")

The error message I'm getting is "The function you entered
can't be used in this expression". For some reason it
doesn't like the format part of the code.

Does any one know how I can set the date format within
this sentence?

PLEASE HELP!!!!!
Click to expand...

Assuming the name of this control is NOT [createDate], the expression
is fine and should work.
I suspect you have a missing reference.

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://members.rogers.com/douglas.j.steele/AccessReference Errors.html

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Jeff Conrad said:
Is this a permanent change Doug?
If so, I'll adjust all my links.
Click to expand...

It's permanent... for now, Jeff. My ISP has moved us to Geocities pages,
with a URL that contains the complete e-mail address. I decided I get enough
Spam without that! I'm probably going to get my own domain sometime soon,
but I'll make sure that at least the Access links at accessmvp.com stay
valid.
 
It's permanent... for now, Jeff. My ISP has moved us to Geocities pages,
with a URL that contains the complete e-mail address. I decided I get enough
Spam without that! I'm probably going to get my own domain sometime soon,
but I'll make sure that at least the Access links at accessmvp.com stay
valid.
Click to expand...

Ok, thanks for the info Doug.
I will update all my links.
 
Shoot! I spend most of the day maintaining and programming our company
intRAnet so please excuse my slip. See if you can figure out the intERnet
thing.
 
Back
Top