Function not available? It was yesterday...

  • Thread starter Thread starter Bonnie A
  • Start date Start date
B

Bonnie A

Hi everyone! Using A02 on XP. I have a file that is used by many folks as a
lookup tool. That's all it is. A form opens on AutoExec and you can select
a variety of buttons for searches or you can open a very few additional forms
that show a bit more detail based upon which record you are on. I rarely have
had to edit this file. Just last week, I added a button on the main form to
open a new form that, once again, only opens a bit more information. I rolled
it into production with no problem. However, one person (out of more than
50) cannot open the file. She gets this error: Function is not available in
expressions in query expression 'Right([PlanNumber],4). Our contract numbers
all have "GP" and four digits. Everywhere I have a policy number search, I
have a field in the underlying query with PolNum: Right([PlanNumber],4). I
can open the file with her UserName and Password on my PC with no trouble at
all. However, I get the error on her PC.

I've opened a module in design view and checked Tools, References and
matched hers exactly to mine (there seemed to be a few only minor
differences) and it STILL doesn't work.

I am stumped. Must I create a new shell and import all my objects to create
a new file? Just not sure and would appreciate any and all assistance or
advice.

Thanks in advance for your time!
 
What sort of "minor differences" are you seeing in the References?

Assuming none of her references have MISSING: in front of them, try
selecting an additional reference from the list of available references,
backing out of the dialog and then going back in and unselecting the
reference you just added.

If that still doesn't solve the problem, try to unselect as many of the
selected references as you can (Access won't let you unselect them all),
back out of the dialog then go back in and reselect the references you just
unselected. (NOTE: Write them down in detail, because they won't be in the
same order when you go back in!)
 
Hi Mr. Steele,

When I first opened her References, she was missing the Microsoft Office XP
Web Components and a few others were in a different order than mine.

I mirrored hers to mine but she still cannot open the file. I can open it
with her Name and Password on my PC but cannot open as me on her PC.

What jerks my chain is that she CAN open all the other files that use that
exact same parsed field in underlying queries.

In the past when there seemed to be no 'fix', I've had to open a new blank
file and import all my objects. I wonder if I must do it on this one.

My references are:

Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.5 Library
Microsoft Office XP Web Components
Microsoft DAO 3.6 Object Library

Are there any others you would recommend I add or replace?
--
Bonnie W. Anderson
Cincinnati, OH


Douglas J. Steele said:
What sort of "minor differences" are you seeing in the References?

Assuming none of her references have MISSING: in front of them, try
selecting an additional reference from the list of available references,
backing out of the dialog and then going back in and unselecting the
reference you just added.

If that still doesn't solve the problem, try to unselect as many of the
selected references as you can (Access won't let you unselect them all),
back out of the dialog then go back in and reselect the references you just
unselected. (NOTE: Write them down in detail, because they won't be in the
same order when you go back in!)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Bonnie A said:
Hi everyone! Using A02 on XP. I have a file that is used by many folks
as a
lookup tool. That's all it is. A form opens on AutoExec and you can
select
a variety of buttons for searches or you can open a very few additional
forms
that show a bit more detail based upon which record you are on. I rarely
have
had to edit this file. Just last week, I added a button on the main form
to
open a new form that, once again, only opens a bit more information. I
rolled
it into production with no problem. However, one person (out of more than
50) cannot open the file. She gets this error: Function is not available
in
expressions in query expression 'Right([PlanNumber],4). Our contract
numbers
all have "GP" and four digits. Everywhere I have a policy number search,
I
have a field in the underlying query with PolNum: Right([PlanNumber],4). I
can open the file with her UserName and Password on my PC with no trouble
at
all. However, I get the error on her PC.

I've opened a module in design view and checked Tools, References and
matched hers exactly to mine (there seemed to be a few only minor
differences) and it STILL doesn't work.

I am stumped. Must I create a new shell and import all my objects to
create
a new file? Just not sure and would appreciate any and all assistance or
advice.

Thanks in advance for your time!
Click to expand...
Click to expand...
 
My general rule is have as few references as you can. Are you using ADO in
your application? If not, remove the reference to Microsoft ActiveX Data
Objects 2.5 Library. Are you using the Web Components? If not, remove that
reference. (If you're not sure, remove the reference and compile your
application--it's under the Debug menu in the VB editor. If it compiles, you
shouldn't need the reference.)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Bonnie A said:
Hi Mr. Steele,

When I first opened her References, she was missing the Microsoft Office
XP
Web Components and a few others were in a different order than mine.

I mirrored hers to mine but she still cannot open the file. I can open it
with her Name and Password on my PC but cannot open as me on her PC.

What jerks my chain is that she CAN open all the other files that use that
exact same parsed field in underlying queries.

In the past when there seemed to be no 'fix', I've had to open a new blank
file and import all my objects. I wonder if I must do it on this one.

My references are:

Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.5 Library
Microsoft Office XP Web Components
Microsoft DAO 3.6 Object Library

Are there any others you would recommend I add or replace?
--
Bonnie W. Anderson
Cincinnati, OH


Douglas J. Steele said:
What sort of "minor differences" are you seeing in the References?

Assuming none of her references have MISSING: in front of them, try
selecting an additional reference from the list of available references,
backing out of the dialog and then going back in and unselecting the
reference you just added.

If that still doesn't solve the problem, try to unselect as many of the
selected references as you can (Access won't let you unselect them all),
back out of the dialog then go back in and reselect the references you
just
unselected. (NOTE: Write them down in detail, because they won't be in
the
same order when you go back in!)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Bonnie A said:
Hi everyone! Using A02 on XP. I have a file that is used by many
folks
as a
lookup tool. That's all it is. A form opens on AutoExec and you can
select
a variety of buttons for searches or you can open a very few additional
forms
that show a bit more detail based upon which record you are on. I
rarely
have
had to edit this file. Just last week, I added a button on the main
form
to
open a new form that, once again, only opens a bit more information. I
rolled
it into production with no problem. However, one person (out of more
than
50) cannot open the file. She gets this error: Function is not
available
in
expressions in query expression 'Right([PlanNumber],4). Our contract
numbers
all have "GP" and four digits. Everywhere I have a policy number
search,
I
have a field in the underlying query with PolNum:
Right([PlanNumber],4). I
can open the file with her UserName and Password on my PC with no
trouble
at
all. However, I get the error on her PC.

I've opened a module in design view and checked Tools, References and
matched hers exactly to mine (there seemed to be a few only minor
differences) and it STILL doesn't work.

I am stumped. Must I create a new shell and import all my objects to
create
a new file? Just not sure and would appreciate any and all assistance
or
advice.

Thanks in advance for your time!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top