March 31, 2005 at 7:07 am
the code below works in the form but not in report.
num_days = 14
Me.RecordSource = "exec dbo.spPrint_shipping_sched"
Me.InputParameters = "'" & num_days & "'"
It is giving me the following errors.
MS Access
The record source ‘exec dbo.spPrint_shipping_sched’ specfied on this form or report does not exist.
You misspelled the name, or it was deleted or renamed in the current database, or it exists in a different database.
In the form or report’s design view, display the property sheet by clicking the Properties button, and set the RecordSource property to an existing table or query.
I also tried
Report!rptHMShipping1.RecordSource = "exec dbo.spPrint_shipping_sched"
Error
MS VB
Run-time error ‘2465’
MS Access can’t find the field ‘rptHMShipping1’ referred to in your expression.
I would appreicate any help! Thanks!
April 4, 2005 at 8:00 am
This was removed by the editor as SPAM
April 5, 2005 at 7:04 am
Have you tried removing the "exec" from your report recordsource - either in design-property settings or in code ?!
**ASCII stupid question, get a stupid ANSI !!!**
April 5, 2005 at 7:14 am
Thanks for your response. after removing "exec" it took care the error message but it stilll won't allow me to pass in parameter. I did figured out how I can make it work. Thanks for your input though.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply