P
Placid
I've put together a database that uploads some financial information into
Access and shapes it into a relavent report. My question is this, when I
execute a button on a form which runs a macro hence running several queries I
have no problems. However, when another user on my network tries the same
procedure using the same version of Access he receives an error suggesting
that one of the underlying queries has an error in it.
The query involved contains a nested If statement to assign a Quarter
designation to the record based upon the date the item was posted. When the
other user attempts to run, the error suggests that a ),], or item in query
expression is missing. I've tested the query from both workstations and it
runs. The problem seems to be the execution of the query in conjuction with
the macro it resides in but only from the other party's workstation.
Any ideas??
Access and shapes it into a relavent report. My question is this, when I
execute a button on a form which runs a macro hence running several queries I
have no problems. However, when another user on my network tries the same
procedure using the same version of Access he receives an error suggesting
that one of the underlying queries has an error in it.
The query involved contains a nested If statement to assign a Quarter
designation to the record based upon the date the item was posted. When the
other user attempts to run, the error suggests that a ),], or item in query
expression is missing. I've tested the query from both workstations and it
runs. The problem seems to be the execution of the query in conjuction with
the macro it resides in but only from the other party's workstation.
Any ideas??