Search results for query: *

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

ETOH = alcohol 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...

Nevermind . . . that was the problem, I had to call by the whole object name: "Exec [WT\jsmith.spMyStoredProc" SP

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