Question on Error Message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don Sealer - 30 Sep 2005 11:12 GMT

I have a database that I going to use for tracking expenses/income. I've
used functions and other things I've learned here. Anyway all went well,
everything works very nicely. As I was building this database I kept it on
my desktop and when I was satisfied it was working correctly I moved it to a
folder in windows explorer.
When I click on any of the command buttons that are linked to a crosstab
query I get a message that says, "Undefined function "Format" in expression.
I get the same message when I try to open any of the crosstab queries.
I thought I'd work on it so I made a copy of the database (from the folder
in windows explorer) and pasted it on my desktop. However it now works fine
when I access the copy from my desktop.
Any idea what causes the Undefined function "Format" in expression error?

Thanks,
Don...........

Reply to this Message

Tom van Stiphout - 30 Sep 2005 15:15 GMT

You're saying both folders were on the SAME machine? That's very
unusual. Typically this is caused by a broken reference, but that most
often occurs when the app is moved from one machine to another.
Still, it's worth compiling the app to see if there are any problems
(Code window / Debug / Compile), and to review the references (code
window / Tools / References)

-Tom.

>I have a database that I going to use for tracking expenses/income. I've
>used functions and other things I've learned here. Anyway all went well,
[quoted text clipped - 11 lines]
>Thanks,
>Don...........

Reply to this Message

Don Sealer - 30 Sep 2005 22:16 GMT

Tom,
Thanks for your reply. Yes it's the same machine. I started building this
database and had the file on my desktop. After I was finished building it
and certain everything worked I cut and pasted the database to a folder
within Windows Explorer. I put a shortcut on my quick menu toolbar. I
entered some data and everything seemed fine. However when I clicked on any
of my "command buttons" to view a report I got that error message. I then
just made a copy of the same database, from the folder within Windows
Explorer, and pasted it back on my desktop (because I was going to try and
figure out why it was not working). When I opened the copied version on my
desktop "everything" worked as it was supposed to, thus my post to the BB.
Well once again I see how much of an armature I really am. I know nothing
about the features within Access. Your suggestion to debug and compile
worked!! It found a piece of code that wasn't valid. The reference check
box came up, I unchecked the code and everything is back to normal. At one
point while I was building the database I tried to use a "button painter".
I couldn't figure out how to make the button painter work so I thought I got
rid of it. Apparently I missed something.
Thanks so much for your help and advice,
Don..............

> You're saying both folders were on the SAME machine? That's very
> unusual. Typically this is caused by a broken reference, but that most
[quoted text clipped - 20 lines]
> >Thanks,
> >Don...........

Reply to this Message