C
Chris
Hi,
The other day I had code working and then the next day I somehow broke it.
The code worked perfectly for 2 days and then does'nt work at all.
I may have changed some settings or something in Access or the SQL database
but
can't remember what they might have been to do this.
I have tried to get a simpler version of my code to work in an entirely new
ADP file and even it does'nt work.
in the open event of a form I put the following code:
Me.InputParameters = "'CAD','BB','A','Regular'"
Me.RecordSource = "dbo.getaudit-sum-app2"
when I step through the code the properties are set but on the end statement
of the procedure it throws up a paramater request window as though I have'nt
set the parameters.
I tested it by putting the input parameters and recordsource into the
property sheet of the Report it it works fine.
any ideas, i'm pulling my hairout trying to figure out why.
thanks
The other day I had code working and then the next day I somehow broke it.
The code worked perfectly for 2 days and then does'nt work at all.
I may have changed some settings or something in Access or the SQL database
but
can't remember what they might have been to do this.
I have tried to get a simpler version of my code to work in an entirely new
ADP file and even it does'nt work.
in the open event of a form I put the following code:
Me.InputParameters = "'CAD','BB','A','Regular'"
Me.RecordSource = "dbo.getaudit-sum-app2"
when I step through the code the properties are set but on the end statement
of the procedure it throws up a paramater request window as though I have'nt
set the parameters.
I tested it by putting the input parameters and recordsource into the
property sheet of the Report it it works fine.
any ideas, i'm pulling my hairout trying to figure out why.
thanks