Hi
Can anyone point me in the right direction.
I have a databse which consists of a front end and back end which holds all the data. This was written in Acess 97, upgraded to 2000, and now on of our users is trying to use in Access 2007 on a Vista plateform. I know i should get rid of the macros and write them all in code, but time does not permit at the moment.
My problem, when the user clicks a command button the first command is hourglass on True
setwarnings false
outputto (saves a report to c: in .SNP format)
This is where i think it is falling over, please see error messages below
When you click the comand button a message box appears saying
Enter parameter value
Members birthdate (this is a filed in attached table)
An input boxs opens
Ok or cancel
The user does not know the value so clicks OK
error appears
Action failed
Macro name
Msf payment part 2
Condition
True
Action name
outputTo
Arguments
3 msf monthly report snapshotformat (*snp),c:\msf.snp
Error no 2950
I have searched MS site for error and all i get is the
http://support.microsoft.com/kb/931407/en-us
which the user assures me they are doing.
As i do not have Access 2007 and Vista as yet, i cannot replicate this and resolve.
TIA
KevinG
Can anyone point me in the right direction.
I have a databse which consists of a front end and back end which holds all the data. This was written in Acess 97, upgraded to 2000, and now on of our users is trying to use in Access 2007 on a Vista plateform. I know i should get rid of the macros and write them all in code, but time does not permit at the moment.
My problem, when the user clicks a command button the first command is hourglass on True
setwarnings false
outputto (saves a report to c: in .SNP format)
This is where i think it is falling over, please see error messages below
When you click the comand button a message box appears saying
Enter parameter value
Members birthdate (this is a filed in attached table)
An input boxs opens
Ok or cancel
The user does not know the value so clicks OK
error appears
Action failed
Macro name
Msf payment part 2
Condition
True
Action name
outputTo
Arguments
3 msf monthly report snapshotformat (*snp),c:\msf.snp
Error no 2950
I have searched MS site for error and all i get is the
http://support.microsoft.com/kb/931407/en-us
which the user assures me they are doing.
As i do not have Access 2007 and Vista as yet, i cannot replicate this and resolve.
TIA
KevinG