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..............
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:qv********************************@4ax.com...
On Fri, 30 Sep 2005 10:12:03 GMT, "Don Sealer" <vz******@verizon.net>
wrote:
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,
everything works very nicely. As I was building this database I kept it
onmy desktop and when I was satisfied it was working correctly I moved it
to afolder 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
folderin windows explorer) and pasted it on my desktop. However it now works
finewhen I access the copy from my desktop.
Any idea what causes the Undefined function "Format" in expression error?
Thanks,
Don...........