Functions are not working in one of my access databases

[sheela]

I apologize for the cross posting.
Thanks to Douglas Steel, Estuardo, and Dennis Schmidt for
replying to my yesterday's query.
I have Access 2002 version.
I have tried all the suggestions, but none of them are
working for me.
According Mr. Douglas Steel's instructions, I wrote a
module, and tried to run that from the query, but it is
saying
That "undefined function MyReplace".
I am new to modules and programming.
I wrote the exact code in a module and saved as
Module_MyReplace.
I called this from the query as

SELECT table1.field1, MyReplace([table1]![field1],"-","")
AS Expr1
FROM table1;
But still giving the same error, saying compile error.
Also I noticed there is a module called "pivot table" in
my database.
This one I didn't create. I guess access created that.
I just noticed that in another access database these
functions (Replace, right, left etc..) are working fine.
But the same functions are not working in my current
database.
I would appreciate any insight on this issue.


To summarize: in one of my access database, the functions
are not working.

Thanks in advance,
sheela

 

[peter walker]

did Douglas advise you to check your VBA library references???

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com

 

[sheela]

no, Yester day my problem was different.
But now the functions work fine, after I delete the "pivot
table" module, which was created by the system.
sheela

-----Original Message-----
did Douglas advise you to check your VBA library references???

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com

I apologize for the cross posting.
Thanks to Douglas Steel, Estuardo, and Dennis Schmidt for
replying to my yesterday's query.
I have Access 2002 version.
I have tried all the suggestions, but none of them are
working for me.
According Mr. Douglas Steel's instructions, I wrote a
module, and tried to run that from the query, but it is
saying
That "undefined function MyReplace".
I am new to modules and programming.
I wrote the exact code in a module and saved as
Module_MyReplace.
I called this from the query as

SELECT table1.field1, MyReplace([table1]![field1],"- ","")
AS Expr1
FROM table1;
But still giving the same error, saying compile error.
Also I noticed there is a module called "pivot table" in
my database.
This one I didn't create. I guess access created that.
I just noticed that in another access database these
functions (Replace, right, left etc..) are working fine.
But the same functions are not working in my current
database.
I would appreciate any insight on this issue.


To summarize: in one of my access database, the functions
are not working.

Thanks in advance,
sheela

.