Error Executing the command

[Lisa B.]

1. I have an Access97 application front-end back-end program installed on
several users computers.

2. When some users try to run a report from the switchboard they get the
following error message:

There was an error executing the command

3. Others are able to run the report with no problem

4. It is a simple report based on a simple query

Do anyone know what might be causing this problem and/or how I can go about
tracking down the problem?

 

[JeffK]

Lisa,

The error message you indicated is the generic message the
switchboard displays when there is an error executing any
of the code in the HandleButtonClick procedure. You will
have to step through that procedure to determine what is
actually happening.

Open the switchboard in design view and switch to the VBA
window. Locate the HandleButtonClick procedure and place
a breakpoint on the first line. Click the button that
opens the report, step through the code and print
Err.Description to the immediate window when the code
branches to the error handler. You can then see the
description of the actual error that is occurring which
will make it easier for you to find the real problem.

HTH
Jeff

 

[Lisa B.]

Is this still the case eventhough some computers are able to run the report?

This error only occurs on some users computers.

 

[VanT.Dinh]

It sounds to me that there are some Reference errors at
the problem PCs. Go to the problem PCs, open any code
module the use the Menu Tools / References ... and see if
any Reference is marked as "MISSING".

Douglas J. Steele has a very comprehensive article on
Reference errors which I haven't got the link handy.
Search for his posts in these newsgroup and go to his Web
site.

If you can't, repost and I will find the link (or someone
else will post the link).

HTH
Van T. Dinh
MVP (Access)

 

[Lisa B.]

I did that and did not see any.

I also traped the error code as suggested by JeffK and got this

Function isn't abailable in expression 'Left([First Name],1) & " " &
Left([Last Name],1)'.

I use the Left$ instead of just Left and still got the error.

I am going to go back and double check the Reference issue just to make
sure.

 

[Van T. Dinh]

1. Make sure you check the Reference errors on EACH of the problem PCs.

2. Even if nothing is marked as MISSING, still follow the steps given by
Douglas J. Steele:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--
HTH
Van T. Dinh
MVP (Access)

I did that and did not see any.

I also traped the error code as suggested by JeffK and got this

Function isn't abailable in expression 'Left([First Name],1) & " " &
Left([Last Name],1)'.

I use the Left$ instead of just Left and still got the error.

I am going to go back and double check the Reference issue just to make
sure.

It sounds to me that there are some Reference errors at
the problem PCs. Go to the problem PCs, open any code
module the use the Menu Tools / References ... and see if
any Reference is marked as "MISSING".

Douglas J. Steele has a very comprehensive article on
Reference errors which I haven't got the link handy.
Search for his posts in these newsgroup and go to his Web
site.

If you can't, repost and I will find the link (or someone
else will post the link).

HTH
Van T. Dinh
MVP (Access)

 

[JeffK]

Every time I have ever seen this error:

Function isn't abailable in expression 'Left([First
Name],1) & " " &
Left([Last Name],1)'.

It has always been due to the situation Van described.
His suggestions should work fine.

-----Original Message-----
I did that and did not see any.

I also traped the error code as suggested by JeffK and got this

Function isn't abailable in expression 'Left([First Name],1) & " " &
Left([Last Name],1)'.

I use the Left$ instead of just Left and still got the error.

I am going to go back and double check the Reference issue just to make
sure.

It sounds to me that there are some Reference errors at
the problem PCs. Go to the problem PCs, open any code
module the use the Menu Tools / References ... and see if
any Reference is marked as "MISSING".

Douglas J. Steele has a very comprehensive article on
Reference errors which I haven't got the link handy.
Search for his posts in these newsgroup and go to his Web
site.

If you can't, repost and I will find the link (or someone
else will post the link).

HTH
Van T. Dinh
MVP (Access)


able
to run the report?

.

 

[Lisa B.]

I read the document suggested by Van T. Dinh and it worked

Eventhough the References did not have "MISSING," when I changed the
Microsoft DOA 2.5/3.5 compatibility Labrary to Microsoft DOA 3.5 object
library and back the error message goes away!

I Thank You both very much.

Every time I have ever seen this error:

Function isn't abailable in expression 'Left([First
Name],1) & " " &
Left([Last Name],1)'.

It has always been due to the situation Van described.
His suggestions should work fine.

-----Original Message-----
I did that and did not see any.

I also traped the error code as suggested by JeffK and got this

Function isn't abailable in expression 'Left([First Name],1) & " " &
Left([Last Name],1)'.

I use the Left$ instead of just Left and still got the error.

I am going to go back and double check the Reference issue just to make
sure.

It sounds to me that there are some Reference errors at
the problem PCs. Go to the problem PCs, open any code
module the use the Menu Tools / References ... and see if
any Reference is marked as "MISSING".

Douglas J. Steele has a very comprehensive article on
Reference errors which I haven't got the link handy.
Search for his posts in these newsgroup and go to his Web
site.

If you can't, repost and I will find the link (or someone
else will post the link).

HTH
Van T. Dinh
MVP (Access)



-----Original Message-----
Is this still the case eventhough some computers are able
to run the report?

This error only occurs on some users computers.

.