Well I give up!
I just going with:
Report's Recordsource: spA1
Report's InputParamaters: @Dummy=Forms!frmDummy!txtDummy
Not elegant, but it works
Thanks to all who respnded,
SP
1DMF,
Thanks much . . .
I'll probably take a closer look at it after the weekend. For now, I have my mind on BBQ and ETOH. I'm looking forward to doing some heavy damage, lol!
SP
My apologies to the moderators for trying to start a new thread based on the text below (it was removed from the Coding forum--sorry for the redundance, my bad!).
Anyway, I thought that the above post was the last word, unfortunately I was wrong. For some reason, when I add the "Exec" to the...
1MDF,
I have to declare ignorance on that one. However, I will take you up on your offer on the code for using wininet.dll.
I'm sure others who have participated in this thread would like to see it also.
Funny, but this thread sort of surprised me by not dying out. When someone posted to it...
Hey 1DMF,
Basically I was in the same position as you. I'm assuming that you are working with Access 2000, standard addition. My suggestion is not Kosher (but probably neither legal or illegal, see below), however it worked for me.
Basically I borrowed a friend's copy and installed it on my...
Last word . . .
It was much simpler than I thought. I just switched my front end from a regular Access front end to an Access project front, much simpler way to do it. Here's a scaled down version--I was making it much too complicated:
Private Sub Report_Open(Cancel As Integer)...
OK, the fires been put out . . .
I just redid my connection to the DB and it worked as I originally coded it. That was really strange . . .
I knew there was nothing wrong with the line of code--I'd seen the same thing posted in several places.
Thanks for your responses,
SP
Hey no problem dhookum . . .
Actually I have been searching threads from several forums (other websites) and have seen this same scenario pop up a few times in the past. No one ever had this resolved due to the fact that its just not possible (oh well . . .)
Anyway, I am going back to binding...
cmmrfrds,
You are definitely right, it's something that I was to fall back on if I could not do it all in the code.
However, I still cannot figure why it does not work in VBA. The Project is in Access 2000, could it be due to limitations in 2000 vis a vis 02, 03?
Anyway thanks,
SP
Thanks Roy,
Unfortunately, that typing error was not in my actual code, but instead in the example I typed above (that is, my project code had the space as you suggested).
SP
By the way, thanks for responses so far, however, I think I must have failed in communication.
Let's start over (and simplify things). I'll give you a simplified version of what I'm trying to do.
Situation: Report's record source:StoredProcedure
Report with two text fields...
I don't want to set my record source for my forms/reports in the Properties box, but instead in VBA (by the way, its an Access Project front ending to Sql server DB).
On the Open (report) or Open (form) event I attempted the following:
Me.Report.RecordSource = "Exec dbo.spA1" & myParam
or...
with rs
do until rs.eof
me.txtRev = !ReturnVal
Loop
End with
As noted above in my previous post, thats what I started with. Unfortunately, that just writes over the previous data each time I access a new value from the recordset
For example, the code leads to the following:
say MyVar in...
No the report as it stands is unbound.
The format is something like this:
Project Type Budget Wedge etc . . .
Acquistion $1.00 $0.99
Completion
Facility Capital
So the values would be currency values. I have been hunting down threads, and I feel like I almost have...
Ok, my problem is as follows:
I am helping a colleage debug the code behind his reports. Originally, his text boxes were bound to Stored Procedures. Unfortunately, this did not provide him with the control of his data he desired. So instead we call the procedures in VBA. Fine. However, his...
That's the first thing I tried George, all permissions were present.
How about the fact that I'm not the dbo? In Sql Query Analyzer my stored procedures are labelled:
WT\jsmith.spMyStoredProc
Would that make a difference?
SP
Ok, I'm not sure whether this is a SQl server question or a VB.Net question, but I'll give it a try here:
Problem: I have a VB.Net program that calls a stored procedure from SQL serv. It works just fine on my computer. After compiling the release version, it still works fine.
However, when I...
Ahhhhhhhh . . . resolved with this added to dataset call (typical newbie omission I bet,lol)
Dim grst As DataSet = New DataSet
Dim NextTable As DataTable = grst.Tables.Add()
Sweep, actually you got me thinking in the right direction . . .
SP
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.